Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help on this Part 3 - Normalization [20 marks total] Case 1: The table R (A, B, C, D, E, F, G, H, Y)

need help on this

Part 3 - Normalization [20 marks total] Case 1: The table R (A, B, C, D, E, F, G, H, Y) holds the following functional dependencies: FD1 A, C B, D, E, F, G, H, Y FD2 B H, Y FD3 G E, F Answer the following questions: 1- What is the primary key in the table R? [2 Marks] 2- Name the partial dependencies and the transitive dependencies if they exist in R. [2 Marks] 3- Is the table R in the 1NF or in the 2NF or in 3NF, and why? [2 Marks] 4- Normalize the table up to the 3NF. [2 Marks] 5- Identify the primary and foreign keys in your 3NF relations. [2 Marks] Case 2: The table R (A, B, C, D, E, F, G, H, I, J) holds the following functional dependencies: FD1 A, B, C D, E, F, G, H, I, J FD2 B E FD3 F G FD4 I D Answer the following questions: 1- What is the primary key in the table R? [2 Marks] 2- Name the partial dependencies and the transitive dependencies if they exist in R. [2 Marks] 3- Is the table R in the 1NF or in the 2NF or in 3NF, and why? [2 Marks] 4- Normalize the table up to the 3NF. [2 Marks] 5- Identify the primary and foreign keys in your 3NF relations.

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

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions

Question

What is the objective of the statement of cash flows?

Answered: 1 week ago

Question

c. Will leaders rotate periodically?

Answered: 1 week ago

Question

b. Will there be one assigned leader?

Answered: 1 week ago

Question

d. How will lack of trust be handled?

Answered: 1 week ago