Extra Normalization Practice Problems for Final Exam

Rutgers Business School: Undergraduate -- New Brunswick Management Information Systems (33:136:370) Instructor: J. Eckstein

Extra Normalization Practice Problems for Final Exam

Lending Musical Instruments

Consider the following single-table database from an organization that lends musical instruments to schoolchildren. Only an illustrative subset of the rows are shown, spanning several school years. A blank value of DateReturned indicates that an instrument is still on loan.

Inst

Instrument

Type

Tag

YearMade Code InstTypeName

23482

2002

VLN Violin

23419

1998

VLN Violin

24239

2010

VLA Viola

44001

1987

FLT Flute

47291

1999

CLR Clarinet

67899

2005

ASX Alto Saxophone

67230

2010

ASX Alto Saxophone

69233

1992

TSX Tenor Saxophone

55091

2001

TPT Trumpet

58902

2011

TBN Trombone

58771

2012

TBN Trombone

23419

1998

VLN Violin

24239

2010

VLA Viola

23102

2004

VNL Violin

25778

1988 CLO Cello

44001

1987

FLT Flute

47888

2006

CLR Clarinet

47291

1999

CLR Clarinet

67899

2005

ASX Alto Saxophone

69233

1992

TSX Tenor Saxophone

55091

2001

TPT Trumpet

58902

2011

TBN Trombone

58771

2012

TBN Trombone

ChildID C873 C329 C843 C877 C901 C321 C447 C447 C221 C322 C987 C329 C843 C702 C873 C877 C901 C171 C321 C447 C221 C987 C322

ChildName Chavez, Marta Choudury, Ali Davis, Ramir Johnson, William Turner, Elena Adderly, James Mobley, Darren Mobley, Darren Morgan, Tajika Hampton, John Chen, Martha Choudury, Ali Davis, Ramir Rittenour, Madeline Chavez, Marta Johnson, William Turner, Elena Sharma, Rajika Adderly, James Mobley, Darren Morgan, Tajika Chen, Martha Hampton, John

Date Loaned 9/12/2014 9/13/2014 9/10/2014 9/13/2014 9/13/2014 9/20/2014 9/20/2014 11/2/2014 9/18/2014 9/18/2014 9/18/2014 9/8/2015 9/8/2015 9/8/2015 9/8/2015 9/10/2015 9/10/2015 9/12/2015 9/6/2015 9/6/2015 9/8/2015 9/8/2015 9/8/2015

Date Returned 6/12/2015 6/12/2015 6/10/2015 6/15/2015 6/6/2015 6/18/2015 11/1/2014 6/18/2015 6/17/2015 6/17/2015 6/16/2015

Redesign this database so that it is in third normal form, and write a database design outline. Do not introduce additional fields.

Additional Normalization Practice Material

Page 1 of 2

Shuttle Bus Features

The following single-table databaser contains information on the product offerings from a firm that supplies small, van-like buses to various markets. The company takes chassis produced by major vehicle manufacturers and builds them into various finished, more specialized products. The table contains information on the products offered, which chassis each product is based on, and which features each finished product has.

Model Number Model Name SC102 Pupil Express SC102 Pupil Express SC110 Pupil Express Plus SC110 Pupil Express Plus SC110 Pupil Express Plus SC110 Pupil Express Plus RS100 Rental Express RS100 Rental Express

RS50 Rental Sprint RS50 Rental Sprint MT55 Maxi Taxi X5 MT55 Maxi Taxi X5 MT60 Maxi Taxi C6 MT60 Maxi Taxi C6 MT60 Maxi Taxi C6

Seat Chassis Capacity Code

27 FRDA1 27 FRDA1 23 FRDA1 23 FRDA1 23 FRDA1 23 FRDA1 20 FRDA1 20 FRDA1 14 DGSP 14 DGSP 3 DGSP 3 DGSP 3 GMUV 3 GMUV 3 GMUV

Chassis Manuf Ford Ford Ford Ford Ford Ford Ford Ford Dodge Dodge Dodge Dodge GMC GMC GMC

Chassis Model A-100 A-100 A-100 A-100 A-100 A-100 A-100 A-100 Sprinter Sprinter Sprinter Sprinter Utilivan Utilivan Utilivan

Feature Code SCBL RDO SCBL RDO WCLF WCTD RDO ILRK RDO ILRK WCLF WCTD WCLF WCTD RDO

Feature Name School bus lights Radio School bus lights Radio Wheelchair lift Wheelchair tie-down Radio Internal luggage rack Radio Internal luggage rack Wheelchair lift Wheelchair tie-down Wheelchair lift Wheelchair tie-down Radio

Design a relational database to keep this same information in third normal form; draw an entity-relationship diagram and write a database design outline. Do not introduce additional fields.

Additional Normalization Practice Material

Page 2 of 2

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download