ERD CASE

ERD CASE
A company has several departments. Each department has a supervisor and at
least one employee. Employees must be assigned to at least one, but possibly
more departments. At least one employee is assigned to a project, but an
employee may be on vacation and not assigned to any projects. The important
data fields are the names of the departments, projects, supervisors and
employees, as well as the supervisor and employee number and a unique
project number.
You are required to:
1. Create an ERD with cardinality notation.(Use MS Word save as: LastnameERD.doc)
2. Create 3NF table designs. (Use MS Word put in : LasnameERD.doc)
This process has two steps:
1. Convert the ERD into tables expressed using "Standard Notation Format"
2. Ensure that the tables are in 3NF.

3. Use MS Access to design the table. Create relationships.
4. Populate the table.