Question: this assignment for database class / Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s). Dogs may, or may
this assignment for database class / Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s).
- 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).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
