Using above table 1. Draw a dependency diagram to show the functional dependenci

ID: 3868849 • Letter: U

Question

Using above table
1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose the relation into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
4. Create an ERD that represents your 3NF relations

sold Prod priceInyNo Iy Date rod code Prod Name Purchase date S12345 endoi 19.50 85 190 -5565 -5570 -5572 Esky Soft 12/7/2016 60 10 13/10/2016 50 17/7/2016 112 18/9/2016 106 18/9/2016 103 isfa Cooler AK2347 15/9/2016 C To

Explanation / Answer

Rationale

This assessment item is designed to test your ability to

Marking Criteria

Marking Rubric

Task

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