Schema Design
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.