Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 6.85PAE
Program Plan Intro
Problems that are there with company’s
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Suppose you are a judge trying to decide a dispute between a buyer and a supplier. The buyer claims not to have produced a particular email purchase order, while the supplier shows you the purchase order, and certificates and CRLs (Certificate Revocation Lists), demonstrating that the purchase order was signed by the buyer. All documents have been signed by a notary. How would the dates on the various pieces of evidence influence your decision? What if only the purchase order was signed by the notary?
Suppose you want to store the records of the employees of your company. They all have employeeID's like IT-012 for the IT department, LG-012 for the Legal department, RD-012 for the recordsdepartment, and so on.In the massive company where you work, there are literally thousands of employees. "Habib" is apretty common name, and there may be many Habib’s in different departments. So what do youdo?It's simple- because the Database manager knew about hashing, Now it’s your task to make hashtable of all departments and store 5 to 10 employees with their IDs, then search the employee IDof ‘Mr. Habib’ to change the post in database. For this you have to print the updated record ofpromoted employee. Save the employee record in File as well.
Damon Davis was preparing the worksheet for Drano Plumbing Company. He calculated the net income to be $50,000. When he totaled the Balance Sheet columns, the column totals were debit, $400,000; and credit, $300,000. What was the probable cause of this difference? If this was not the cause, what should he do to find the error?
Chapter 6 Solutions
Modern Database Management (12th Edition)
Ch. 6 - Prob. 6.1RQCh. 6 - Prob. 6.2RQCh. 6 - Contrast the following terms: a. base table; view...Ch. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Prob. 6.6RQCh. 6 - List six potential benefits of achieving an SQL...Ch. 6 - Prob. 6.8RQCh. 6 - Distinguish among data definition commands, data...Ch. 6 - Prob. 6.10RQ
Ch. 6 - Prob. 6.11RQCh. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Drawing on material covered in prior chapters,...Ch. 6 - Explain and provide at least one example Of how to...Ch. 6 - Prob. 6.16RQCh. 6 - What is the difference between COUNT, COUNT...Ch. 6 - What is the evaluation order for the Boolean...Ch. 6 - If an SQL statement includes a GROUP BY clause,...Ch. 6 - Prob. 6.20RQCh. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Explain why SQL is called a set-oriented language.Ch. 6 - When would the use of the LIKE key word with the...Ch. 6 - Prob. 6.25RQCh. 6 - Prob. 6.26RQCh. 6 - In what order are the clauses of an SQL statement...Ch. 6 - Within which clauses of an SQL statement can a...Ch. 6 - Prob. 6.29RQCh. 6 - Prob. 6.30RQCh. 6 - Prob. 6.31RQCh. 6 - Explain the difference between the WHERE and...Ch. 6 - Prob. 6.33RQCh. 6 - Prob. 6.34PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.36PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.40PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Are based on the class scheduling 3NF relations...Ch. 6 - Prob. 6.45PAECh. 6 - Prob. 6.46PAECh. 6 - Prob. 6.47PAECh. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Prob. 6.50PAECh. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Modify the Product_T table by adding an attribute...Ch. 6 - Prob. 6.55PAECh. 6 - Add an order to the Order_T table and include a...Ch. 6 - Use the Pine Valley database to answer the...Ch. 6 - Prob. 6.58PAECh. 6 - Prob. 6.59PAECh. 6 - Prob. 6.60PAECh. 6 - Prob. 6.61PAECh. 6 - Prob. 6.62PAECh. 6 - Prob. 6.63PAECh. 6 - Prob. 6.64PAECh. 6 - Prob. 6.65PAECh. 6 - Prob. 6.66PAECh. 6 - Prob. 6.67PAECh. 6 - Prob. 6.68PAECh. 6 - Prob. 6.69PAECh. 6 - Prob. 6.70PAECh. 6 - Prob. 6.71PAECh. 6 - Prob. 6.72PAECh. 6 - Prob. 6.73PAECh. 6 - Prob. 6.74PAECh. 6 - Prob. 6.75PAECh. 6 - Prob. 6.76PAECh. 6 - Prob. 6.77PAECh. 6 - Prob. 6.78PAECh. 6 - Prob. 6.79PAECh. 6 - Prob. 6.80PAECh. 6 - Prob. 6.81PAECh. 6 - Prob. 6.82PAECh. 6 - Prob. 6.83PAECh. 6 - Prob. 6.84PAECh. 6 - Prob. 6.85PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- FOOTBALL-PLAYER(CodFP, Name,Surname, Address, CityOfBirth) TEAM(CodT, Name, Category,ConstitutionDate) AWARD(CodA, CodFP, DeliveryDate, DeliveryPlace, Type) PLAYER-TEAM(CodFP, CodT, StartingDate,EndingDate, NumPlayedMatches, NumGoals) For each team in which players living in Turin (attribute “City of birth”) have never played, find team name and category and, for each football player, code, surname, and total number of days of militancy in that team (computed as the difference between ending and starting dates) SELECT T.Name, T.Category, FP.CodFT, FP.Surname, FP.Name, SUM(EndingDate - StartingDate) FROM TEAM T, FOOTBALL-PLAYER FP, PLAYER-TEAM PT WHERE PT.CodFP = FP.CodFP AND PT.CodT = T.CodT AND PT.CodT NOT IN ( SELECT PT.CodT FROM PLAYER-TEAM PT, FOOTBALL-PLAYER FP WHERE PT.CodFP = FP.CodFP and CityOfBirth= "Torino" ) GROUP BY T.CodT, T.Name, T.Category, FP.CodFT, FP.Surname, FP.Name; this is the solution but please help me as i am not understanding…arrow_forwardA restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagramarrow_forwardCan you draw Entity Relationship (ER) diagram based on the text. (Please use the draw.io web site for drawing.) Entity: HoneynetCentralServer Attributes: server_id (Primary Key), cronjob_interval Relationships: one-to-many with Honeypot one-to-one with LogProcessor Entity: Honeypot Attributes: honeypot_id (Primary Key), ip_address, ssh_credentials, server_id (Foreign Key) Relationships: many-to-one with HoneynetCentralServer one-to-many with LogEntry Entity: LogEntry Attributes: log_entry_id (Primary Key), timestamp, message, action_type, attack_level, honeypot_id (Foreign Key) Relationships: many-to-one with Honeypot Entity: LogProcessor Attributes: processor_id (Primary Key), rule_filters, server_id (Foreign Key) Relationships: one-to-one with HoneynetCentralServer Entity: MongoDBAtlasDatabase Attributes: database_id (Primary Key), connection_string Relationships: one-to-many with StoredLogEntry Entity: StoredLogEntry Attributes: stored_log_entry_id (Primary Key), log_entry_id…arrow_forward
- The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…arrow_forwardABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…arrow_forwardABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…arrow_forward
- What are the 4 requirements for a deadlock to occur? Please explain why each one needs to be present for a deadlock, and show why the deadlock would not occur if any are missing?arrow_forwardIn MS Access, to ensure that a grade must be either A, B, C, D or F, whichvalidation rule should be used?A) ="A" or ="B" or ="C" or ="D" or ="F"B) between A and FC) like "A", "B", "C", "D", "F"D) not in ("A" or "B" or "C" or "D" or "F")E) in ("A", "B", "C", "D", "F")arrow_forwardDraw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.arrow_forward
- Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date} Consultant means: id of some Staff member Staff={idPerson(PK), surname,dob, boss, email} Dob means: date of birth, boss: is id of another Staff member supervisor Insurance_Type={idT(pk) , Tname , price , length } Length = number of months it is valid (from the date when it was bought ) Find consultants born after some contract was already signed?arrow_forwardEach company operates four departments, and each department belongs to one company. Each department in part (a) employs one or more employees, and each employee works for one department. Each of the employees in part (b) may or may not have one or more dependents and each dependent belongs to one employee. Each employee in part (c) may or may not have an employment history, which includes his employments until the employee joined this enterprise as well as the employment history within the enterprise (after joining). Which of the following statements are true about the ER diagram (assuming it is a good design)? Department will be a weak entity. Employee will be a strong entity. There will be a one-to-many relationship between employee and dependentarrow_forwardI asked this question on Bartleby but didn't get a very clear response, I would like further explaination please. The answer on Bartleby said that it would be none of the options but didn't really explain why. What is the cardinality of the 'writes' relationship type? a) One-to-many b) Many-to-many c) One-to-one d) None of the other options My thought process was that it would be b) Many-to-many since: A person writes many books. And one book is also written by many people. Thus the relationship will be many to many. One to many would mean that one instance is related to many other instances. For example, the address of a house contains many people living in the house. One to one would mean that one instance is associated with only one other instance. For example, one employee will have one unique ID in an organization. So why is the answer none of the other options?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you