Database Assignment Relationship Model week 3 Deep Blue Sailing

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

Database Assignment Relationship Model week 3 Deep Blue Sailing

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A