Question: We would like to design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. Construct a crows
- We would like to design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. Construct a crows feet diagram using the information provided. The information we need includes:
- Staff, including their names, addresses and social-security numbers.
- Patients, including their names, addresses, and the name of their insurance company.
- Patients are each assigned to a ward (room).
- Those staff who are nurses are assigned to zero or more wards. Each ward has at least one nurse assigne
- Those staff who are doctors are assigned to zero or more patients. Patients may or may not have a doctor assigned, and they may have more than one doctor. Patients in the same ward may have different doctors but will always have the same nurse(s).
- We would like to construct a database for the NHL. Using the following information, construct a crows feet diagram. The information is as follows:
- The NHL exists of many teams
- Each NHL Team has a name, city, coach, captain, and players
- The NHL keeps track of each game played between two teams on specific dates, as well as the score.
- Each NHL player has a first and last name, a position (center, goalie, etc.), and a hometown.
- Each NHL player belongs to only one team
- Team captains are also players
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
