Assignment week 3 Review the Entity Relationship diagram and derive a relational schema using the ru
Assignment
week 3
Review the Entity Relationship
diagram and derive a relational schema using the rules and naming conventions 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
Below are the criteria that will be
used to evaluate the performance of your work on Assignment 2 (Relational
Model). Level 4 indicates that all requirements have been met and that you have
demonstrated a strong understanding of the Relational Model. Level 1 indicates
that many requirements are missing or incomplete and that you lack a general
understanding of the major concepts. Directly below each requirement and the
evaluation criteria is the point value awarded for the performance level. For
each requirement, the criteria that most closely matches your work product will
be the performance level (and points) awarded. The maximum score for this
assignment is 90 points. Late submission of assignments will be assessed a
penalty of 10% per day. Assignments more than two days late will not be
accepted and will receive 0 points.
Requirement
Level 4
Level 3
Level 2
Level 1
Relations
All relations have been correctly
identified and have been named appropriately.
There are 1-2 missing and/or extra
relations. 1-2 relations have been incorrectly named.
There are several missing and/or
extra relations. Several relations have been incorrectly named.
There are many missing and/or
extra relations. Many relations have been incorrectly named.
18 Points
18
16
14
12
Primary Keys
Every relation has been given a
primary key that is composed of the correct attribute(s).
There are 1-2 primary keys that
are missing or not composed of the correct attribute(s).
There are several missing and/or
extra primary keys identified. Several primary keys are not composed of the
correct attribute(s).
Most relations have missing and/or
extra primary keys. Most primary keys are not composed of the correct
attribute(s).
18 Points
18
16
14
12
Primary -Foreign Key Constraints
All primary-foreign key constraints
have been identified for applicable relations and are referenced using the
correct syntax.
All primary-foreign key
constraints have been identified for applicable relations, but several are
not referenced using the correct syntax.
There are several missing and/or
extra primary-foreign key constraints. Several primary-foreign key
constraints are not referenced using the correct syntax.
Most primary-foreign key
constraints are incorrect and have not been referenced using the correct
syntax.
18 Points
18
16
14
12
Attributes
All attributes provided in the ER
diagram have been correctly identified and named.
1-2 relations have missing, extra,
or incorrectly named attributes.
Several relations have missing,
extra, or incorrectly named attributes.
Most relations have missing,
extra, or incorrectly named attributes.
18 Points
18
16
14
12
Clarity of Presentation
The work follows a standard
notation, is easy to read, and could be used in a professional setting.
The work would require minor corrections
to notation and/or appearance to use in a professional setting.
The work would require substantial
revisions to notation and/or appearance to use in a professional setting.
The work is unreadable or
illegible.
18 Points
18
16
14
12
Total Points
90
80
70
60
PLACE YOUR ORDER TO GET STARTEDThe post Assignment week 3 Review the Entity Relationship diagram and derive a relational schema using the ru appeared first on Essay Gem.
For any questions, feedback, or comments, we have an ethical customer support team that is always waiting on the line for your inquiries.