Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 4, Problem 10P
a.
Explanation of Solution
Crow’s Foot ER diagram for first LOST:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Tour” table contains details of the tour and the “Tour” can have many “Qualification” which equally “Guide” can works in many “Qualification”. Here the M:N relationship is break into two 1:N relationship. The “Qualification” is a bridge between “Tour” and “Guide” table.
- The “Stop” table contains details of the stop and one “Tour” can have many stopping place so 1:N relationship...
b.
Explanation of Solution
Crow’s Foot ER diagram for second LOST:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Tour” table contains details of the tour and the “Tour” can have many “Qualification” which equally “Guide” can works in many “Qualification”. Here the M:N relationship is break into two 1:N relationship. The “Qualification” is a bridge between “Tour” and “Guide” table...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
ABC 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,…
ABC 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,…
A 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 diagram
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - What is a derived attribute? Give an example. What...Ch. 4 - Prob. 11RQ
Ch. 4 - Discuss two ways in which the 1:M relationship...Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
Knowledge Booster
Similar questions
- *SI schema contains customers that have bought one or more vehicles.They can be classified using the following criteria:Customers that have bought only one car (one-time buyer)Customer that have bought two cars (two-time buyer)Customers that have bought more than two cars (frequent buyer)Using a SINGLE SELECT statement, display a list of customers withtheir names and what type of buyer they are for all those customersthat have bought Mercedes car makes.arrow_forwardTesta Inc. is a company specializing on self-driving electric vehicle (EV) production. In Testa, a self-driving EV is represented as a model, which is identified by its Model_No and has the attributes of Model_Desc (description), Production_Date, and Model_Cost. Each model uses one to many parts in its production; each part may be used in zero to many models. The number of parts (Num_Parts) is recorded for each part used in a model. Each part is identified by Part_No and has the attributes of Part_Name, Part_Cost, and Effective_Date. Each part may consist of zero to many other parts; each part may be a component of zero to many other parts. The nearby entity-relationship diagram shows the aforementioned situation. Testa is asking you to develop a MySQL database to manage its part and model data. You will create the tables and their data in your MySQL account and upload the MySQL script here. First, you are required to download a text file (click here) and then open it using a text…arrow_forwardDifferentiate between normalizing and standardizing. Explain your response by providing specific instances.arrow_forward
- Draw an E-R Diagram for: -Customers pay with credit cards. -Customers have: id, name, address, phone -Credit cards have: type, number, exp_date, ccv_number, zip_code -Each customer can pay with several credit cards -Each credit card belongs to only one customerarrow_forwardQuestion 1: Create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. Emergency cases do not require an appointment. However, an emergency is entered into the appointment book as "unscheduled" for appointment management purposes. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. Each visit updates the patient's records to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be…arrow_forwardComputer Science The Academic Affairs Department of ABC College provides photocopy services for the lecturers. Lecturers need to provide their name, staff id, faculty code (FHTM-Faculty of Hotel and Tourism, FSSR-Faculty of Sports Science and Recreation), type of assessment (quiz, test, examination), number of pages for master/original copy and number of copies required, to request for the photocopy service. The following class of Photocopy defines all the details for the photocopy service.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_forwardUsing the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:- A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill directly, or…arrow_forward
- Draw an ERD of following scenario Vehicle registration System has three types of users Admin, Applicant and Bank Employee. There is only one Admin in this system. The system is intended to do two major tasks i.e. registration, verification, tax/token fee payments and transfers of vehicles and keeping track of vehicles insurance. Different types of users have different privileges to the system, whereas admin has the maximum access to the system. It also keep track of every enrolled vehicles and can generate the reports for admin. In our system applicant fills the registration form as per its required specification and submits it to system, where its data is shifted on system by profiling it, here system will check the applicant’s registered information in order to abide by the redundancy factor of data then the application of end user is submitted in accordance to its feasibility of requirements likewise vehicle registration or vehicle…arrow_forwardUsing the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. Show all connectivities, relationship…arrow_forwardA company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education