Assessment Item 3
Normalisation
Value: 13%
Due date: 04-Sep-2017
Return date: 26-Sep-2017
Submission method options
Alternative submission method
Task
Arco code Prod Nemo Purchase dale Oty_sold Prod_soce Inv No nv Date 'Vendor ID Vendor Name
1E612345 Esky Scli Cooler 12/7/2018 50 19.50 13-5565 171712016 112 00151011
1A1(2347 Angle Grinder 199/2018 10 85 B-5570 181912016 106 RC TocIs
KAR62705 111gh Pressure Cleaner 1311012016 50 190 13-5572 16912016 103 ArdoNy
AEC25874 Circisar See 198/2016 15 119 6-5570 18/9/2066 106 RC Tools
252386 deterred 2018/2018 45 28.50 135585 2518/2016 112 00151011
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
NOTE
For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.voutube.cornAvatch7vmdUyuLLornwC1
Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema or the ERD Is NOT acceptable.
Rationale
This assessment aligns with the following subject outcomes:
• be able to critically analyse a database design and apply normalisation theory and techniques;