Darrin’s Dubious Dog Kennel Project
Darrin is looking to upgrade his business processes to include a database to store his information. He knows his business and has given you some details about his business shown below. Create an ERD Diagram with all the requisite parts on a drawing tool. Build out a database called Kennel with the parts from your ERD. Create 2 rows of dummy data for each table you build. Tables will be no longer than 5 columns wide.
Darrin’s Information:
- He owns several Kennels throughout the north east
- He keeps several dog breeds
- He stores customer data
- He stores employee data
- He stores order data
- He keeps an inventory current and previous dogs
- He keeps account of which employees sold what dog
- He keeps track of which employees are managers
- He knows what state each kennel is in
- He keeps track of information of where the dogs come from people, organization, or state
- He keeps track of which dogs can be service dogs and their age
- He also keeps a separate record of some general data about each dog breed
- Finally he keeps sales data including but not limited to including sold for, total cost of ownership, taxes, and payment id
You will be graded on the below:
- ERD completeness
- ERD readability
- Cardinality
- Attribute types
- Database tables
- Database completeness
- ERD Database match
- Thoughtful attributes and columns