PhD TIM- Design a Database Conceptual Model

PhD TIM- Design the Application Supporting Network Architecture
May 18, 2020
Please answer the following. 250 words minimum for each question
May 18, 2020

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.