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
thumb_up100%
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.
A student may register for classes during a specified registration period. To register, a
student must see their advisor. The advisor must approve each course that the student has
selected. The advisor will use the registration system to determine if the student has met the
course prerequisites, is in good academic standings and is eligible to register. If the advisor
approves the courses, the advisor enters the student's college id into the course registration
system. The course registration number for each course is entered. The course description,
course number and section for those courses will automatically display. The system will check
for schedule conflicts before saving the registrations. A bill for the courses will print in the
Bursar's office. The student should proceed to pick it up.
b)Draw a class diagrams which represents the generic objects and relationships described
above. Make c)sure to specify multiplicities for all associations shown in your diagrams.----
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
- In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.arrow_forwardIn an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write an algorithm in pseudocode, a flowchart and NS diagrams that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.arrow_forwardTairiq 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_forward
- A 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_forwardRick and Ryan Enterprises is an agency that specializes in representing clients in the fields of sports and entertainment. Given the nature of the business, some employees are given a company car to drive and each company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle ID and also contain a license plate number, make, model, and year. Employees represent clients. Not all employees represent clients while some employees represent many clients. Each client is represented by one and only one employee. Each client has a unique client number. Additional attributes required for each client are name, address, and date of birth. Draw an ER diagram that shows the entity types and the relationship types for Rick and Ryan Enterprises. While you must name each relationship type and define the structural…arrow_forwardDisjoint restrictions overlap?arrow_forward
- 3- Write the business rules that are reflected in the ERD shown below (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the orientation of the ERD components.) PUBLISHER BOOK publishes submits wrtes CONTRACT AUTHOR signs %23arrow_forwardCreate Functional and Non-Functional requirements for the following system: A parking deck system manages an entry/exit gate, which opens to let a vehicle (i.e., car) into or out of the deck and closes when the car has passed through. A driver must push a button to print a parking permit. When the driver takes the parking permit, the system raises the gate. The system lowers the gate after the vehicle has passed through. A permit id and time of entry is printed on the parking permit, and is also encoded on the permit’s bar code. When the vehicle leaves the parking deck, the driver inserts the parking permit into a bar code reader, which scans the bar code, and then transmits the bar code to the parking system. The parking system calculates a fee that is based on the number of hours that have elapsed since the vehicle entered the parking deck, and displays the fee to the operator and driver. The driver must pay the operator with cash or check. The operator accepts the payment, and if…arrow_forwardQ: Front office of any hotel is responsible for all room reservations, room allocations and fınal settlement of bills. Any company or person can reserve room for their future stay. They have to indicate from what date to what date they need the room. They also have to indicate how many rooms are required. Sometimes the reservations could be cancelled or dates or number of rooms changed. For reservation, cancelled or modification of rooms, customer receives an acknowledgement from the hotel. Draw sequence diagram for reserve room scenario, also draw the class diagram.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. 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. Please make the solution clear.arrow_forwardTairiq 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. 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 allocatedarrow_forwardOverview: A new bank wants to make a simple application to keep track of all accounts and transactions. In this TMA, it is required to help the bank manager implement the required application. Requirements: After a quick meeting with the bank manager, you got the following information: It is required to store all bank accounts in one collection and all the transactions happened in another collection. Each account has a unique account number, a holder and balance. There is a specific prefix (common for all accounts) that should be added to the holder's civil id to create the unique account number. In addition, it is not allowed for a holder to have more than one account. Furthermore, only three transactions are allowed on any account: deposit, withdrawal and transfer money to another account. Each holder has a unique civil ID (national id), a name and other attributes (add at least 2 attributes from your choice). For each transaction, it is required to store the account(s) affected,…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