Question: Lab 6 1. Given the table T(A,B,C,D,E) with functional dependencies ABC and C-DE. explain why this table is or is not in 3NF. If the

Lab 6 1. Given the table T(A,B,C,D,E) with functional dependencies ABC

Lab 6 1. Given the table T(A,B,C,D,E) with functional dependencies ABC and C-DE. explain why this table is or is not in 3NF. If the table is not in 3NF, decompose it into tables that are in 3NE 2. Given the table T(A,BC,D,E) with functional dependencies AB and C-DE, explain why this table is or is not in 3NF. If the table is not in 3NF, decompose it into tables that are in 3NE 3. Give functional dependencies for the table T(A.B.C,D,E) that would result in a 3NF table The following table, called "tennis" records tennis victories at the four grand slam events for the past 3 years: Year Grand Slam Winner Homeland Host_Nation 2015 Australian Open Djokovic Serbia Australia 2015 French Open Wawrinka Switzerland France 2015 Wimbledon Djokovic Serbia England 2015 US Open Djokovic Serbia United States 2016 Australian Open Djokovic Serbia Australia French Open Djokovic Serbia France 2016 Wimbledon Murray Scotland England 2016 US Open Wawrinka Switzerland United States 2017 Australian Open Federer Switzerland Australia 2017 French Open Nadal Spain France 2017 Wimbledon Federer Switzerland England 2017 US Open Nadal Spain United States 4. What are the functional dependencies of this table? ANSWER: Grand Slam - Host_nation Winner homeland Year, Grand Slam -- winner 5. Why isn't this table in 3NF? 6. Give an example of an update anomaly for this table (Hint: What would happen if somebody wanted to move?) 2016 7. Break this table into multiple tables that are in 3NE. For each table give the name of the table, the attributes within the table and the functional dependencies for each table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Part 1 : Normalization 1 . Consider a table Alphabet ( A , B , C , D , E ) with the following functional dependencies: FD 1 : AB C FD 2 : AC B FD 3 : BC A FD 4 : D E a . Determine all the candidate...

In which normal form is this database table? (1NF, 2NF, or 3NF?) Why? Edition Book Name DB fundamentals DBfundamentals DB fundamentals DBfundamentals Author Navathe Elmasri Elmasri Navathe...

Consider the following relation R, where {A, B} is its PK. Assume that R is in the first normal form (INF). R (A, B, C, D, E, F) Functional dependencies: FD1: BC FD2: ADE FD3: ABF Why is this table...

10:55 P I o. @ * .lbl 73% ReviewQ_for Final.pdf SQL Questions Part-A- Employee Empld, Lname, Fname, Posid, Supervisor, HireDate, Salary, Commission, Deptid, Qualld) PosId: REFERENCES Position...

Please explain 6. Given a relation R(A. B. C. D) with the functional dependencies F ABC D. D C). Which highest normal form is the relation in? a BCNF 3NF d) 1NF 7. Given a relation R(A, B. C. D) with...

Insert anomaly means the inability to create a new record due to the absence of other data (2 points) True False 2 Specialization S: S = {V1, V2, ..., vn) is a set of subclasses with the same...

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,...

This question aims to analyze schemas to determine dependencies and convert them to 2NF. Remember to state any assmptions you make. 1. Suppose we have the Schema R(A, B, C, D, E) and the...

2. Given the relation R (A, B, C, D, E) and the following set of functional dependencies: F = {ABC, AE, BD, C>B} a. Specify the key of R. b. Is R in the 3NF? If not give a decomposition of R that is...

Given a relation schema R(A, B, C, D, E, G, H), with F={ABC, BC, CDG, DCG, HDEG, EDH} 1- Give a minimal cover of F 2- Determine all keys of R 3- Give a 3NF decomposition of R 4- Is your decomposition...

Considering the four perspectives of the Kaplan and Norton Balanced Scorecard including the lag and lead indicators, prepare a pro-forma sustainable balanced scorecard for a sugarcane factory that...

Camer Pharmaceuticals is testing a new product in the market 1 . The demand for the new product is estimated to be Normally distributed with a mean 2,000,000 and standard deviation 250,000. The...

Using the alternative Form of the Derivative In Exercises 6 9 7 6 , use the alternative form of the derivative to find the derivative at x = c , if it exists. 6 9 . f ( x ) = x 3 + 2 x 2 + 1 , c = 2...

The companies should also be developing strategies for growth and downsizing. Question 1 7 options: False True None of the above

Every time a credit card company sends our bill late with barely enough time for us to make our payment without incurring late charges and we dont threaten to cut up our card if the practice...

Every time were served restaurant food that is too salty, overcooked, too tough, or whatever, and we dont say anything, the restaurant has no way of knowing its food is substandard or that the new...

Every time we receive shoddy luggage service at a hotel and the bellhop sticks a hand out for a tip and we give the bellhop money, were telling the bellhop that tips arent connected to the service...