The third stage of the project is the development of the logical database schema from the entity-relationship (RE) model. The relational schema should be fully normalized with documentation to show that it adheres to good database design.

Expected duration
3 hours
Deadline
1645 on Lesson 18
Points
50 points

Learning Objectives

  • Create a normalized relational database schema from an entity-relationship (ER) model

Help Policy

Authorized Resources
Any, except classmates working on other teams
Notes
Never copy another person’s work and submit it as your own.

You must document all help received from all sources, including the instructor and instructor-provided course materials (such as the textbook).

Assignment

You must develop a relational schema for your ER diagram. Provide a table with the following information for each relation:

Attribute
Name of attribute
Data Type
Data type, including length (if applicable)
Keys and Constraints
Identify primary and foreign keys and any constraints that exist on the allowed set of values

For example,

Attribute Data Type Keys and Constraints
id INTEGER PRIMARY KEY
name VARCHAR(255) NOT NULL

Include a brief prose description of each relation, especially if it does not correspond to an entity in your ER diagram.

Your relational schema should be normalized to at least 3rd Normal Form (3NF). Although you need not list all the functional dependencies, ensure that the documentation for each table is sufficient to infer that the database satisfies 3NF (which may necessitate identifying the functional dependencies in some cases).

Submission

Submit your schema using Blackboard and include a copy of your ER diagram as a separate attachment. Include your documentation statement as part of your Blackboard submission.