Question
Draw an E-R diagram for a database recording information about teams, players, and their fans, including For each team, its name, its players, its team
Draw an E-R diagram for a database recording information about teams, players, and their fans, including For each team, its name, its players, its team captain (one of its players), and the colors of its uniform. Remember that a set of colors is not a suitable attribute type for teams. For each player, his/her name, and the history of teams on which she/he has played on, including the start date and ending date (if she/he was traded) for such team. For each fan, his/her name, address (only one address for each fan), teams she/he likes, players she/he admires, and favorite color. Hint: Between two entity sets, there can exist more than one relationship set.
Draw an E-R diagram for a database for a hospital: The hospital has a large number of registered physicians. Each physician has a Name, Specialty and a unique Physician_ID. Patients that are currently admitted. Patients are admitted to the hospital by physicians. Each patient has a Patient_Name and a unique Patient_ID. Any patient who is admitted must have exactly one admitting physician. A physician may admit any number of patients. Once admitted, a given patient may be treated by any number of physicians. A particular physician may treat any number of patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment, including Date, Time and Results. Hint: Between two entity sets, there can exist more than one relationship set.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started