For this week you will design a model schema table structure based on the data model shown below: First

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.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Place Order