Create Entity Relationship diagram with at least two tables and their attributes

DatabaseIIRubric.docx

Home >Information Systems homework help >Create Entity Relationship diagram with at least two tables and their attributes

ISAS 600 – Database Project Phase II Rubric

Assignment:

Create and submit an ER Diagram with at least two tables (one for each table of your proposed database).

Your diagrams should exhibit;

· Some amount of normalization (first, second and third normal forms)

· Primary and Foreign keys are identified

· Type of field (text, currency, numeric) and field length is included

	Does not meet expectations	Meets expectations	Exceeds expectations
*Conceptual Data Modeling*
Did you correctly identify the entities in the case based on the Project Charter?	Did not identify entities correctly	Identified regular entity types	Identified and listed all entity types and listed all data elements
Did you correctly identify the relationships in the case?	Did not identify relationships	Identified regular relationships	Identified all relationships with proper notation
Did you correctly identify the keys of the entity types?	Did not identify any keys	Identified primary or foreign keys	Identified both primary and foreign keys.
Did the student correctly identify the attributes of the entity types?	Did not identify attributes	Identified regular attributes	Identified regular attributes as text, currency, numeric or other types and field length for text
*Logical Database Design*
Did you correctly map the E-R diagram constructs into the logical database design?	Missed Entity Types mapping to tables. Missed Attributes mapping to table columns Missed foreign keys for 1or more relationships	 Entity types mapped as tables,  Some relationships mapped properly (foreign keys or separate tables),  Some primary and foreign keys designed properly 	Entity types mapped as tables,  All relationships mapped properly (foreign keys or separate tables),  All primary and foreign keys designed properly
*Normalization*
Are the tables in 3rd Normal Form?	Few tables 3NF	Most tables in 3NF	All tables 3NF