Lab Exercise: Complete a Company Database with EER Diagram

Create an EER Diagram for the Company 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:

1. Complete an EER diagram of the company database described in chapter 4. You may use Visio, PowerPoint, MySQL Workbench, or gliffy.com

2. 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

3. Under Course Lab files you will find lab documents. Under chapter 4 use the data files provided to load the database.