Consider the following scenarios and create an ER Diagram for the same: A company wants to
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the following scenarios and create an ER Diagram for the same:
- A company wants to keep track of its employees, departments, and projects. Each employee is assigned to a department, and each project is managed by a department. An employee can work on multiple projects, and a project can have multiple employees working on it.
- A hospital wants to keep track of its patients, doctors, and appointments. Each patient is assigned to a primary care physician, and each physician can have multiple patients. An appointment is a relationship between a patient and a physician.
- A movie rental service wants to keep track of its movies, customers, and rentals. Each movie can have multiple copies, and each copy can be rented out to a customer. Each rental can have multiple movies, and each movie can be associated with multiple rentals. A customer can rent multiple movies, and each rental can only be associated with one customer.
- A hotel wants to keep track of its guests, rooms, and reservations. Each guest can make multiple reservations, and each reservation can be associated with only one guest. Each reservation is for a specific room, and each room can be reserved multiple times. Each reservation also has a start date and an end date. ER diagram to represent this scenario, including all the relevant relationships and cardinalities. Also include an attribute for the length.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: