Functional Dependency & Normalization The table below lists customer/car 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 a given date.carRegmakemodelcustNocustNamehireDateoutletNooutletLocM565 0GDTeslaModel SC100Smith, J5/14/2018101San FranciscoM565 0GDTeslaModel SC201Helena, P5/15/2016101San FranciscoN734 TPRNissanSunnyC100Smith, J5/16/2016101San FranciscoM134 BRPTeslaModel SC313Blatt, O5/14/2018102Los AngelesM134 BRPTeslaModel SC100Smith, J5/20/2018102Los AngelesM611 0PQNissanSunnyC295Alice, T5/20/2018102Los Angeles Fig: Table 1Identify the functional dependencies represented by the data shown in the table above. State any assumptions you make about the data. Using the functional dependencies identified in part (a), describe, and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.

Functional dependencies are a concept in database management that define the relationships between…

Answered: Functional Dependency & Normalization…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Functional Dependency & Normalization

The table below lists customer/car 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 a given date.

carReg	make	model	custNo	custName	hireDate	outletNo	outletLoc
M565 0GD	Tesla	Model S	C100	Smith, J	5/14/2018	101	San Francisco
M565 0GD	Tesla	Model S	C201	Helena, P	5/15/2016	101	San Francisco
N734 TPR	Nissan	Sunny	C100	Smith, J	5/16/2016	101	San Francisco
M134 BRP	Tesla	Model S	C313	Blatt, O	5/14/2018	102	Los Angeles
M134 BRP	Tesla	Model S	C100	Smith, J	5/20/2018	102	Los Angeles
M611 0PQ	Nissan	Sunny	C295	Alice, T	5/20/2018	102	Los Angeles

Fig: Table 1

Identify the functional dependencies represented by the data shown in the table above. State any assumptions you make about the data.

Using the functional dependencies identified in part (a), describe, and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions