Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 acceptable

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions