This lab focuses on the design, build, and use of a relational database. You are

This lab focuses on the design, build, and use of a relational database. You are to chose a database of your choice (the labs use MySQL, but you can use MS Access or other database) and complete the following:
Complete an EER diagram of the company database described in chapter 4. You may use Visio, PowerPoint, MySQL Workbench, or gliffy.com
Create the database based on your design. Write the Create table statements (even if you create the tables in MS Access, you need to provide the Create Table statements). Keep in mind keys and referential integrity requirements
Under Course Lab files you will find lab documents. Under chapter 4 use the data files provided to load the database.
Prepare the following queries:
Select * from each table
Complete a query with at least 2 joins
Complete a query with 2 joins and the use of an aggregate function like average or sum
Complete a query using an outer join
You should submit your EER diagram, DDL statements, Load DDL, and queries in a single document by the end of the course
The lab is worth 12% of your grade