DATABASE MANAGEMENT SYSTEMS

Assignment 1:

A segment of the project Model for Old Hound Pet Store database shows data model containing 3 entities.

1. Store: an organization that sells pets
2. Pets: animals that are owned by the store and sold to domestic customers.
3. Customers: people and organizations that buy pets from Old Hound Pet Store.

Determine the following:

1. The relationship (one-to-one-, one-to-many, many-to-many) type between
   1. Store and Pets
   2. Pet sand Customers
   3. Explain in words the relationship between the above-mentioned entities?
   4. Draw data model which contains the entities and their relationships