Draw A Dependency Diagram To Show The Functional Dependencies In The Relation 3627751

/in /by

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
NOTE
For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ
Document Preview:

Assessment item 3 HYPERLINK “https://outlines.csu.edu.au/delivery/published/ITC114/201960/S/I/outline.html” l “contentPanel” back to top Normalisation Submission method options: Alternative submission method Task Task Meeting IDMeeting DateMeeting TimeMeeting VenueMeeting IDUser IDRatingUser IDUser Availability124/1/201911:40 amLibrary1IA3KCYes124/1/201911:40 aLibrary1DD4YANo124/1/201911:40 aLibrary1KC2DDYes225/1/201910:30 amTrail St2IA5IAYes225/1/201910:30 amTrail St2DD4AKYes225/1/201910:30 amTrail St2KC2225/1/201910:30 amTrail St2AK3326/1/20199:00 amBlessed Bean3DD3326/1/20199:00 amBlessed Bean3IA2Using 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 NOTE For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ  Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.    Rationale HYPERLINK “https://outlines.csu.edu.au/delivery/published/ITC114/201960/S/I/outline.html” l “contentPanel” back to top This assessment task will assess the following learning outcome/s: be able to analyse a database design and apply normalisation theory and techniques.   Marking criteria and standards HYPERLINK “https://outlines.csu.edu.au/delivery/published/ITC114/201960/S/I/outline.html” l “contentPanel” back to top Each task is worth 5 marks. The marking criteria for this assignment is:  CriteriaHDDICRPSbe able to analyse a database design and apply normalisation theory and techniques.Analysis identifies all PKs and functional, partial and transitive dependencies. Accurately identifies all 3NF relations,…

Attachments:

normalisation….docx