Instructions from the Professor:
Using Visio draw the ERD for your project, discuss whether it is in 3NF and why, create an SQL Database and insert at least 5 records in each table. Create 5-7 queries to retrieve data that would be useful. Your documentation for the project should include: the project description, the ERD, any business rules, the normalization discussion, the questions that your queries answer.
Details on the project I decided to make my ERD with:
I would like to create a database tracking the different types of chores that parents assign to the children throughout the week. Parents would track the daily types of chores each child is responsible for. I assigned my children a list of chores for daily check-off. Some chores are given to one child to accomplish that day while others are assigned to the other child.
Example: On Monday my son takes the trash out, sweeps the floor, takes care of the dishes, and folds clothes while my daughter vacuums the carpet, mops the floors, and takes care of laundry making sure clothes get washed and dries and makes sure the folded and hung clothes end up in dressers, drawers, or closet accordingly.