Details of this Paper

Database Assignment Relationship Model week 3 Deep Blue Sailing

Description

solution


Question

Question;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

 

Paper#36831 | Written in 18-Jul-2015

Price : $32
SiteLock