Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q 7 . Consider the relation R = { A , B , C , D , E , F , G , H ,

Q7. Consider the relation R={A,B,C,D,E,F,G,H,I,J,K,L,M,N} and the set of functional
dependencies ,
{D}{G,H}.
(a)(2%) What is the key for R?
(b)(6%) Decompose R into 2NF, then 3NF relations.Consider the relation R ={A, B, C, D, E, F, G, H, I, J, K, L, M, N} and the set of functional dependencies F ={{A, B, C}->{L},{B}->{D, E, F},{A, C}->{M, N},{D, E}->{I, J, K},
{D}->{G, H}}.
(a)(2%) What is the key for R?
(b)(6%) Decompose R into 2NF, then 3NF relations
image text in transcribed

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

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions

Question

i need correct answrrs 4 9 2 . .

Answered: 1 week ago