Scribd
Upload
22 views6 pages

Database Normalization Exercises Guide

The document contains exercises related to database normalization, specifically focusing on splitting tables into third normal form (3NF) relations. It includes examples from various contexts such as events in venues, computer sales data, library systems, student grades, and customer purchases. Each exercise requires identifying primary and foreign keys while transforming unnormalized data into normalized relational database tables.

Uploaded by

shinnthukhant.mst
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views6 pages

Database Normalization Exercises Guide

The document contains exercises related to database normalization, specifically focusing on splitting tables into third normal form (3NF) relations. It includes examples from various contexts such as events in venues, computer sales data, library systems, student grades, and customer purchases. Each exercise requires identifying primary and foreign keys while transforming unnormalized data into normalized relational database tables.

Uploaded by

shinnthukhant.mst
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1

2
3

Exercises:

1) The table below is associated with events in various venues in a town.

Split the above table into FOUR (4) third normal form relations. You do not have to show data or the steps that
you took to normalise the table.

VenueCode
VenueName

VenueCode*
Event*

Event
EventTypeCode*

EventTypeCode
EventTypeDesc
4

UNF 1NF 2NF 3NF


Venue Code 1 VenueCode VenueCode VenueCode
VenueName 1 VenueName VenueName VenueName
Event 2
EventTypeCode 2 VenueCode* VenueCode* VenueCode*
EventTypeDesc 2 Event Event* Event*
EventTypeCode
EventTypeDesc Event Event
EventTypeCode EventTypeCode*
EventTypeDesc
EventTypeCode
EventTypeDesc

2) The following set of data is from a manual record of a computer sales shop.

Normalise this set of data to transform it into a set of third normal form relations. You should show each of the
steps in the normalisation.
5

3) The following unnormalised table holds data for a library system.

Identify THREE (3) normalized relational database tables that should be derived from the above
unnormalized table. Specify the primary keys and foreign keys for the normalized tables you have
identified.

UNF 1NF 2NF Final Answer


BorrowerID 1 BorrowerID BorrowerID Borrower
BorrowerName 1 BorrowerName BorrowerName BorrowerID (PK)
TitledBorrowed 2
DateofReturn 2 BorrowerID*
TitledBorrowed BorrowerID* RentingRecord (Or)
DateofReturn TitledBorrowed* Record
DateofReturn BorrowerID(PK)(FK)
TitledBorrowed(PK)(FK
)

TitledBorrowed BookInfo
TitledBorrowed (PK)
6

4) The following unnormalised table holds data for students, the modules they have taken and the
grades achieved on those modules.

Show how this table could be split into THREE (3) normalised relational database tables.
5) The table below is associated with customers and the products they have purchased.

Split the table into FOUR (4) third normal form (3NF) relations. You do not have to show data or the
steps that you took to normalise the table.

You might also like