Instructions

For this week you will design a model schema (table structure) based on the data model shown below:

  First Table: Employee entity:

          EmployeeID

          Employee First Name

          Employee Last Name

          Employee Department

          Employee Position

          Employee Email

          Employee Phone

  Second Table: Project Entity

          ProjectID

          Project Name

          Project Description

          Project Start Date

          Project End Date

          Project Budget Code

 Third Table: Department

          Department Number

          Department Title

          Location

  Fourth Table: Assignment

          ProjectID

          EmployeeID

          Hours Worked

You will design the physical database diagram consisting of four tables using the database design language (DBDL) notation and table composition format that must include table name, attributes, data types, validation criteria.

This assignment does not follow APA format expectations for citations and references.

Upload your document, (database schema design), and click the Submit to Dropbox button.