Assignment-Normalization

docx

School

Harvard University *

*We aren’t endorsed by this school

Course

6969420123

Subject

Information Systems

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by zablonupwork

Assignment--Normalization Reading materials: Before you start your assignment, thoroughly read the Lecture Notes: Chapter 14 – Normalization.ppt, NormalizationExamples.ppt, and NormalizationTaskExamples.pdf. Problem: A company called FastCabs provides a taxi service to clients. The table shown in Figure 1 displays some details of client bookings for taxis. Assume that a taxi driver is assigned to a single taxi but a taxi can be assigned to one or more drivers. Figure 1: Table displaying sample data for FastCabs a) Identify the functional dependencies that exist between the columns of the table. b) Identify the primary key. c) Determine the Normal Form of the table based on the primary key you identified. d) Normalize the table to 3NF. You should give the explanation when you decompose a table.

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Assignment-Normalization

Related Documents