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#30251 | Written in 18-Jul-2015

Price : $47
SiteLock