Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.Draw a dependency diagtam to show the functional dependencies in the relation 2.Decompose the relation into a set of 3NF relation 3. Draw a relational
1.Draw a dependency diagtam to show the functional dependencies in the relation
2.Decompose the relation into a set of 3NF relation
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints.
4. Create an ERD that represents your 3NF relations
Value: 13% Due Date: 14-Sep-2018 Return Date: 09-Oct-2018 Length: Submission method options: Alternative submission method Task back to top Meeting ID Meeting Date 24/1/2018 Meeting Time 11:40 am Meeting Venue Library Event IDUser ID Rating Person ID Satus 25/1/2018 10:30 am Trail St 26/1/2018 9:00 am Blessed Bean 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 thatrepresents your 3NF relations be.comywatchiveUyuLL gmwo NOTE from a dependency diagram, watch this very short YouTube video: htps://www.yourt For guidance on how to normalise database relations back to top Manually drawing the dependency diagram, or the set of 3F relations or the relationalt schemais NOT acceptableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started