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.