|
Draw a dependency diagram to show the functional dependencies in the Home Library relation
|
The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies
|
The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies
|
The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies
|
The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies
|
The dependency diagram identifies and shows few or no PKs and few or no functional, partial, and transitive dependencies
|
|
Decompose the Home Library relation into a set of 3NF relations
|
The set of relations is in 3NF and accurately identifies all PKs and all the relevant attributes
|
The set of relations is in 3NF and accurately identifies all PKs and most of the relevant attributes
|
The set of relations is in 3NF identifies most PKs and some of the relevant attributes
|
The set of relations is mainly in 3NF and identifies some PKs and some of the relevant attributes
|
The set of relations is not in 3NF and identifies few or no PKs and few or none of the relevant attributes
|
|
Draw a relational schema for each of the 3NF relations and show the referential integrity constraints
|
The relational schema accurately describes each entity and correctly shows all of the referential integrity constraints
|
The relational schema accurately describes each entity and correctly shows most of the referential integrity constraints
|
The relational schema describes each entity and shows some of the referential integrity constraints
|
The relational schema describes most entities and shows some of the referential integrity constraints
|
The relational schema describes few entities and shows few or none of the referential integrity constraints
|
