Question: 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

Using the functional dependencies identified in part (ii), illustrate the process

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.

\begin{tabular}{|l|l|l|l|l|l|l|l|} \hline filmNo & fTitle & dirNo & director & actorNo & aName & role & timeOnScreen \\ \hline F1100 & Happy Days & D101 & Jim Alan & A1020 & Sheila Toner & Jean Simson & 15.45 \\ & & D101 & Jim Alan & A1222 & PeterWattD101JimAlan & A1020KinderSilviaSimpson & 25.38 \\ & & D076 & Sue Ramsay & A1567 & StevenMcDonald & Tim Rosey & 19.56 \\ \hline F1109 & Snake Bite & D076 & Sue Ramsay & A1222 & PeterWatt & Archie Bold & 10.44 \\ \hline \end{tabular}

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 Databases Questions!

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

14.8The table below lists customercar hire data. Each customer may hire cars from various outlets throughout Glasgow. A car is registered at a particular outlet and can be hired out to a customer on...

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Database Systems and KE - 2 0 2 3 . 0 5 . 1 7 . II . Part: Tasks Define Functional Dependencyl List the only the Armstrong axioms and state the below statement using only theml { W x Y , x Z , Z W Y...

need help with a and b QUESTION A2 (10 marks) Consider the relation schema: Borrowings (accNo, Author, pYear, sID, sName, iDate, Library, Building) intended to contain data on books that student...

QUESTION A2. (10 marks) Consider the relation schema Borrowings (accNo, Author, pYear, sID, sName, iDate, Library, Building) intended to contain data on books that student borrow from different...

Question A2. (20 marks) The table below (Table 2) lists hairdresser/customer appointment data. Each customer may have several appointments with different hairdressers at different times. Hairdresser...

need help with part b and c Consider the relation schema: Enrolment (Dept, UnitNo, Offering, SID, SName, EnDate, CName, CLoc) intended to contain studen enrolment data for My University, a...

question from pastpaper 2016 transform into 3nf table , most answers i see as examples are wrong because they dont use a composite key. In this case accNo and sID are composite key because none of...

(b) (4 marks) (i) Identify the functional dependencies based on your understanding of the My University domain. Explain how the data in Table 1 satisfy those dependencies. State any assumptions you...

The 2015 income statement of Adrian Express reports sales of $15.2 million cost of goods sold of $10 million, and net income of $3.2 million. Balance sheet information is provided in the following...

To test its line of sight adjustment, a level is setup near C (elev 193.436 m) and then near D. Rod readings listed in the order taken are C = 1.256 m, D = 1.115 m, D = 1.296 m, and C = 1.151 m....

18. The average 15-year-old purchases 100 song downloads from Apple Music and buys 20 cheese pizzas in a typical year. If cheese pizzas are inferior goods, would the average 15-year-old be...

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Understand what is involved in designing a career management program

Explain specific ways that management development can be linked to organizational goals and strategies

Describe the approaches that have been taken to describe the managerial job