Question: 1. Problems Draw an E-R diagram for a database recording information about teams, players, and their fans, including For each team, its name, its players,

 1. Problems Draw an E-R diagram for a database recording information

1. Problems 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. 2 . . 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!