Overview of Assignment
In this assignment you will pick a scenario from your life and design a database from scratch using conceptual and logical modeling.
Part 1 Assignment Details
Take inspiration from your life and interests to come up with an idea for a database. Is there a group you belong to that could use a database?
Could you design a sample database for the kind of company you would like to work at?
Would you like to keep track of your favorite sports stats? Etc. Your idea must be sufficiently complex enough to satisfy the requirements detailed below.
Explain why you choose your idea and write down business rules.
Business rules are what you wrote down when you interviewed me about the Employee Performance
Reviews Database. You can see examples of more business rules in lab 8.
Identify and document the entities, relationships and attributes of the data requirements.
Create a conceptual ERD from those data requirements.
Map the conceptual model into a logical model.
