B01DBFN212 - Database Fundamentals Assessment Answer

Assessment Details:

Assessment Task: The design, building, querying and testing of a relational database.

Given the above information:
1. Create a complete ERD with all entities and relationships.
2. Convert the ERD to a set Relational table in at least 3NF and draw a dependency diagram.
3. Create a database using MS ACCESS - with primary keys, foreign keys and other attributes mentioned for each entity using proper constraints. 
4. Create a form to input/update data.
5. Input some significant data in each table showing your understanding of the scenario.
6. Create three Queries.
7. Create a report.