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.