PhD TIM- Design a Database Conceptual Model

 
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.