The table shown below displays the details of the roles played by actors/actresses in films. dirNo...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF.
Expert Answer:
Answer rating: 100% (QA)
Based on the provided table the given table is not in first normal form 1NF due to the repetition of actor information within each film This repetition leads to data redundancy and potential inconsist... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
How might you market your products similarly or differently to those who are colour-blind versus those who have normal color vision?
-
How does diversification impact the potential for investment gains?
-
The table shown in Figure 14.19 lists dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of...
-
Regal Department Store sells gift certificates redeemable for store merchandise that expire one year after their issuance. Regal has the following information pertaining to its gift certificates...
-
Prove that the function f(x) = x101 + x51 + x + 1 has neither a local maximum nor a local minimum.
-
With unionization on the downturn, from the reading, why should an organization be concerned about labor relations? Contrast the style of labor unions in the U.S. to that found in another country?...
-
Section2.1 described a sample of \(n=50\) geographic areas (Zip codes) containing sales data on the Wisconsin state lottery ( \(y=\) SALES). In that section, sales were analyzed using a basic linear...
-
How does perception affect behavior?
-
Image transcription text v X aXcelerate - Learner + X - C A entryeducation.app.axcelerate.com/learner/course/class/13950840/mod/19654/assessment/14117890/run Q Item List All BSBTEC301 - Design and...
-
Jake claims that he can buy a $210,000 for about the same as his rent, and therefore he should definitely buy because he has heard that "renting is bad". Help him walk through this argument. a....
-
The idea that I will be working on is a juice product that is provided in a juice bar. There will be self-serve kiosks where you can make your own juice. Or you can opt for some pre-designed drinks....
-
The agency that results when a person approves an unauthorized act done in the principals name by a person who had no authority to act as agent. a. agent b. agency by necessity c. agency by ratifi...
-
The precise legal term for an agent. a. agent b. agency by necessity c. agency by ratifi cation d. apparent a uthority e. attorney in fact f. express a uthority g. contract of agency h. disclosed pr...
-
Assume that the indirect quote is for 10.0 Mexican pesos per U.S. dollar. What is the direct quote for dollars per peso? (0.10 dollars per peso)
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. A competent party may delegate his or her service on a jury to another by appointing an...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. A general agent is a person authorized to assume complete charge of his or her principals...
-
Given the ordered basis 9 B = -----A- 4 U find [v] 3, the coordinates of v = -8 5 U3 = 21 19 -25 []} 1 8 with respect to B.
-
You deposit $10,000 in a savings account that earns 7.5% simple interest per year. What is the minimum number of years you must wait to double your balance? Suppose instead that you deposit the...
-
Suppose that the leakage-adjusted money multiplier can be calculated using a simple modification of our money multiplier formula: 1/(Reserve Requirement + Excess Reserves + Cash Holding), Where each...
-
According to By the Numbers, if the average price of a barrel of oil is $100, and total aggregate demand in 2012 was $15 trillion in the United States and $9 trillion in China, what percentage of...
-
For what type of borrowing do the federal funds rate and the discount rate apply? Which rate is used in more transactions in the United States?
-
In 2022, Mark purchased two separate activities. Information regarding these activities for 2022 and 2023 is as follows: The 2022 losses were suspended losses for that year. During 2023, Mark also...
-
Jerry sprayed all of the landscaping around his business with a pesticide in June 2023. Shortly thereafter, all of the trees and shrubs unaccountably died. The FMV and the adjusted basis of the...
-
In 2023, Julie, a single individual, reported the following items of income and deduction: Julie owns 100% and is an active participant in the rental real estate activity. What is her taxable income...
Study smarter with the SolutionInn App