Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

when we write out a relational form how do we know what needs to be underlined and have a asterik *, when we write out a normal from how do we know what needs to be underlined and have a asterik around it?
image text in transcribed
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

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

Accounting And Auditing Research And Databases Practitioner's Desk Reference

Authors: Thomas R. Weirich, Natalie Tatiana Churyk, Thomas C. Pearson

1st Edition

1118334426, 978-1118334423

More Books

Students also viewed these Databases questions

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago

Question

Discuss the key ambient conditions and their effects on customers.

Answered: 1 week ago