Posted: January 25th, 2016
Review the Attached ER and derive a relational schema using the rules and naming conventions outlined in Chapters 16 and 17 of the course text.
Review the Attached ER and derive a relational schema using the rules and naming conventions outlined in Chapters 16 and 17 of the course text. To receive full credit for this assignment, your schema must be well organized, easy to read, and include:
- All relations, labeled with appropriate names
- A primary key identified for each relation
- Attributes listed for each relation
- Primary-foreign key constraints
-
Relations
|
All relations have been correctly identified and have been named appropriately.
18 pts
|
There are 1-2 missing and/or extra relations. 1-2 relations have been incorrectly named.
16 pts
|
There are several missing and/or extra relations. Several relations have been incorrectly named.
14 pts
|
There are many missing and/or extra relations. Many relations have been incorrectly named.
12 pts
|
|
18 pts
|
Primary Keys
|
Every relation has been given a primary key that is composed of the correct attribute(s).
18 pts
|
There are 1-2 primary keys that are missing or not composed of the correct attribute(s).
16 pts
|
There are several missing and/or extra primary keys identified. Several primary keys are not composed of the correct attribute(s).
14 pts
|
Most relations have missing and/or extra primary keys. Most primary keys are not composed of the correct attribute(s).
12 pts
|
|
18 pts
|
Primary -Foreign Key Constraints
|
|
All primary-foreign key constraints have been identified for applicable relations, but several are not referenced using the correct syntax.
16 pts
|
There are several missing and/or extra primary-foreign key constraints. Several primary-foreign key constraints are not referenced using the correct syntax.
14 pts
|
Most primary-foreign key constraints are incorrect and have not been referenced using the correct syntax.
12 pts
|
|
18 pts
|
Attributes
|
All attributes provided in the ER diagram have been correctly identified and named.
18 pts
|
1-2 relations have missing, extra, or incorrectly named attributes.
16 pts
|
Several relations have missing, extra, or incorrectly named attributes.
14 pts
|
Most relations have missing, extra, or incorrectly named attributes.
12 pts
|
|
18 pts
|
Clarity of Presentation
|
The work follows a standard notation, is easy to read, and could be used in a professional setting.
18 pts
|
The work would require minor corrections to notation and/or appearance to use in a professional
16 pts
|
The work would require substantial revisions to notation and/or appearance to use in a professional setting.
14 pts
|
The work is unreadable or illegible.
12 pts
|
|
18 pts
|
Total Points: 90
|