Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 4, Problem 8P
Explanation of Solution
Entity Relational (ER) Diagram:
The following figure illustrates the ER Diagram for given business rules using Crow’s Foot notation:
Explanation:
The above ERD contains several entities such as “PATIENT”, “APPOINTMENT”, “DOCTOR”, “PATIENT_PAYMENT”, “VISITING”, “BILL”, “VISIT_DETAIL”, “INSURANCE” and “INSURANCE_PAYMENT”. Each entity has its own attributes.
- A doctor keeps several patients; similarly, a patient may request many doctors. Hence the relationship between the entities “DOCTOR” and “PATIENT” is M: N...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of
artwork. Each piece of art has a unique id [ArtID], an artist, year and title.
Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a
paintType and style. Sculptures have a material, height and weight.
Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate.
A listing of the artwork displayed at an exhibition is also retained.
Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for
entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1
and relationship type RT1.
Start_date
End_date
E1
E1
11
RC1
PaintType
Style
E3
13
A1
Title
Year
A/
A
A/
A/
A/
A/
A/
A/
A
A/
A/
E2
12
A/ E2
E3
E4
11
12
13
14
A1
A2
RC1
RT1
RT1
A2
Height
Weight
E4
14
Activate
Go to Settin
Systems Analysis and Design
Use any suitable tool, represent, using the proper symbols, the following action:
A young inventors club has decided to implement a website to motivate its members. The website has the following data. Members are requested to fill the application forms. Member details are stored in member file. Accounts department gets the details from member file and decides the membership fees. And it sends the receipt to the member.
need: entity relationship 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 - Prob. 11RQCh. 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
- Tairiq MinesError! Bookmark not defined. Tairiq Mines in Texas has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. 1.Represent the above as a single Entity Relation model. Provide any assumptions necessary to support your model 2.Write an SQL query that displays the parking space number, location as well as the name of the staff member to whom the parking space has been allocated.arrow_forwardMake use-case diagram: The customer wants a system for bike racing registrations where Organizers of eventscan publish races, people who want to race can sign up and the system should also keeptrack of the old races to racers can "level up" and start in higher categories (cat).Racers who officially want to race need to sign up with the system with their name,credit card information. To be able to register for official races they need to buy alicence. The license is always valid for 1 year and has a specific ID and is for the racerscurrent level (cat). Racers are sorted into categories 5-1 where 5 is beginner and 1 isthe best category. Racers can only race in official events if they have the cat required,so they need to race against others their level.Organizers can create races. The interesting part is though that a race can consist ofdifferent stages. E.g. one stage is a road race, the other a criterium and the other atime trial (you can find what these are online). Each stage is on a…arrow_forwardA library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…arrow_forward
- Using 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 oppointment is made with only one doctor and one patient.Emergency patients do not ned 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 instalments,and a payment may cover more than one bill.A patient may pay the bill directly,or the bill may be the basis…arrow_forwardDisjoint restrictions overlap?arrow_forwardA rail transport company wishes to hold details of train services, stations and operators. Details include the following: Trains: A train has a unique id code, a collection of days it runs on (Monday, Sunday etc.), and the number of carriages it has. Each train must have at least one driver but can have many drivers that can drive it, and a driver may drive many trains. Each driver is identified by an employee number and a name. A train is designated as either an InterCity or District train though other types of train are possible. Each train must have an operator and not more than one operator. Each operator has a name and a phone number. The operator can operate many trains (or none at all!) Stations: A station has a name and the number of platforms it has. All stations are classified as either Main or District only. There are no other types of stations. Timetable: A train has a number of stops at a station during its journey. It never visits the same station twice on the same…arrow_forward
- Tairiq MinesError! Bookmark not defined. Tairiq Mines in Glen Austin has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. 1. Represent the above as a single Entity Relation model. Provide any assumptions necessaryto support your modelarrow_forwardWrite at least 10 requirements for a calculator. Make sure you use the word SHALL in each requirement and each requirement shall have an unique identifier such a number.arrow_forwardEach publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERDarrow_forward
- Conference Planning The following table shows a training company's workshops, the number of days of each, and their registration fees. Conference Number of Days Registration Fee Handling Stress 3 $1,000 Time Management 3 $800 Supervision Skills 3 $1,500 Negotiation 5 $1,300 How to Interview 1 $500 Conferences are held in several locations. The table below contains locations and hotel fees per day. Location Hotel Fees per Day Austin $150 Chicago $225 Dallas $175 Orlando $300 Phoenix $175 Raleigh $150 When a customer registers for a conference, he or she must pay the registration fee plus…arrow_forwardAn employee has only one job code, but a job code can be held by many employees. ERDarrow_forwardAlert dont submit AI generated answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
C++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr