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:


          Employee First Name

          Employee Last Name

          Employee Department

          Employee Position

          Employee Email

          Employee Phone

  Second Table: Project Entity


          Project Name

          Project Description

          Project Start Date

          Project End Date

          Project Budget Code

 Third Table: Department

          Department Number

          Department Title


  Fourth Table: Assignment



          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.