Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MSIS Assignment:Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s). Remember to make a copy for yourself. Dogs may,
MSIS Assignment:Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s). Remember to make a copy for yourself.
- Dogs may, or may not, have an owner but dogs never have more than one owner. An owner may own many dogs or no dogs at all. Dogs have a DogID, Dogname and DogBreed. Owners have an OwnerID, OwnerName and OwnerAddress.
- A student may earn up to one scholarship though not every student earns a scholarship. Every scholarship is only goes to a single student. Students have a StudentID, Name and GPA. Scholarships all have a unique name, an endowment and a reward duration (Spring 2018, Fall 2019, etc).
- An NFL player has a unique NFLID, a name, a position and a salary. Each player plays for one team. An NFL team has multiple players. Each team has a unique name, a home city, a salary cap and an owner.
- A driver may have a traffic ticket, have no tickets or have many tickets. Each ticket has a CitationID, a date, a location and a description. Drivers have a Drivers License ID (DLID), name and address that is composed of street, city, state and zip code. A ticket is issued to only one driver and all tickets are associated with a driver.
- Employees (EmpID, Name, HourlyRate) work in only one of our several warehouses. Each warehouse has several employees and always at least 5 employees. Each warehouse is also managed by one employee. Each warehouse has a unique lot number (LOTNUM), size in square feet, and may or may not have the capacity to store frozen items.
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