Design a Database Conceptual Model
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
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowEmployee 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.
Design a Database Conceptual Model