Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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