Question: when we write out a relational form how do we know what needs to be underlined and have a asterik *, when we write out

Question 3-Normalisation Use Lectures and INE 1NE Tutorials in Unit 4 Also note, both the Sort Code and the Account Number are Given the above form, the Un-normalised form (UNE) has been extracted as follows: needed to uniquely define each (Client Number, dient Name, Date of Birth, Client Address, Telephone Number, (Account account. Number, Sort Code, (Transaction Date and Time, Amount in) Identify and write out the first Normal form (1NF) in relational schema form UNF - 1NF 4 marks (Client.Number, Client Name, Date of Birth, Client Address, Telephone Number, Account Number, Sort Code, Transaction Date and Time, Amount ) Question 3-Normalisation Use Lectures and 1NF NF Tutorials A freight company uses many aircraft to distribute customer packages around Europe. in Unit 4 The company charges by a combination of miles travelled and the weight of the package supplied. Individual flights can carry many packages, more than one package on any one flight may be transported for a single customer. Given the comments above and constructed first Normal form below: Delivery (Flight No, Flight_Date, Flight_Departure_Point, Flight_Arrival_Point, Flight_Distance, Customer No, Customer_Name, Packase No, Package_Weight. Pilot_Name, Co_Pilot_Name, Aircraft_No, Aircraft_Type, Aircraft_Seats, Cost_per_kilometre ) Identify, and write out in relational schema form, the Second Normal form (2NF). 5 marks INF - 2NF Delivery (Flight No**, Customer No*, Packare No*) Flight (Flight No, Flight_Date, Flight_Departure_Point, Flight_Arrival_Point, Flight_Distance, Pilot_Name, Co_Pilot_Name, Aircraft_No, Aircraft_Type, Aircraft_Seats, Cost_Per_Kilometre) Customer (Customer No, Customer_Name)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
