Databases are everywhere in our lives. Think about (or create) a database you interact with and recreate it to understand how it works.

Examples

How university students are related to the courses they take, professors, and dormitories

How a restaurant tracks menus, inventory, customer orders, and employees

How a online store tracks orders, inventories, site usage

How a movies are tracked and sorted so people can look up reviews

Part 1 - End from the Beginning

1. Create a Report view of the data to show how someone would view it. Your end state does not have to have more than 5 records, but it should be a view of an output representative of the data which would be stored in it.

Part 2 - Articulate the business logic

Outline the business rules for the relationships - how is each table related in reality, are their restrictions for data?

While your logic does not need to be complicated, the end view should contain at least 4 tables of information

Part 3 - Visualize your database

Visualize the data types and relationships (crows feet) in an ERD. Show how each table relates

Your ERD should include the attributes and keys

For this part of the project, the ERD should be at a Conceptual level, indicating keys of attributes and the attributes contained in the tables. In part 2 you will indicate the data types

Write out the relational schema for your tables

Create the Data Dictionary for each table, communicating the data type and limits to the data (its OK if the data types are not SQL accurate yet, just define what type of data (text, number, etc)

Normalize your tables to 3NF

Show the dependency diagram(s) to reach 2NF and 3NF