DATA MODELING
Overview of Entire Assignment part 1 and Part 2
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.
Talk about why you choose your idea and write down business rules.
Business rules are what you wrote down when you interviewed about the Employee Performance Reviews Database.
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.
Again, the system you decide to model is of your choosing. Generally, the more complex your data requirements the higher your potential grade will be.
