Design a database conceptual model

 

Instructions

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

Don't use plagiarized sources. Get Your Custom Essay on
Design a database conceptual model
Just from $13/Page
Order Essay

  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.

Upload your document, (database schema design), and click the Submit to Dropbox button.

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper