Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Normalization of the table using UNF, 1NF, 2NF, and 3NF, thank you. Assignment #2 - Normalization: Lending Musical Instruments Consider the following single-table database from

image text in transcribedimage text in transcribed

Normalization of the table using UNF, 1NF, 2NF, and 3NF, thank you.

Assignment #2 - Normalization: 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 is shown, spanning several school years. A blank value of DateReturned indicates that an instrument is still on loan. Instrument Tag Year Made Child ID Instrument Type Code VLN Instrument Type Name Violin 23482 2002 C873 23419 1998 VLN Violin C329 24239 44001 2010 1987 VLA FLT Viola Flute C843 C877 47291 1999 CLR Clarinet C901 67899 2005 ASX C321 67230 2010 ASX C447 9/20/2014 11/1/2014 Alto Saxophone Alto Saxophone Tenor Saxophone Trumpet 69233 1992 C447 55091 2001 TSX TPT TBN C221 Child Name Date Loaned Returned Chavez, 9/12/2014 6/12/2015 Marta Choudury 9/13/2014 6/12/2015 Ali Davis, Ramir 9/10/2014 6/10/2015 Johnson, 9/13/2014 6/15/2015 William Turner, 9/13/2014 6/6/2015 Elena Adderly. 9/20/2014 6/18/2015 James Mobley, Darren Mobley, 11/2/2014 6/18/2015 Darren Morgan, 9/18/2014 | 6/17/2015 Tajika Hampton, 9/18/2014 6/17/2015 John Chen, 9/18/2014 6/16/2015 Martha Choudury 9/8/2015 Ali Davis, Ramir. 9/8/2015 Rittenour, 9/8/2015 Madeline Chavez, 9/8/2015 Marta Johnson, 9/10/2015 William 9/10/2015 Elena Sharma, 9/12/2015 Rajika 58902 2011 Trombone C322 58771 2012 TBN Trombone 0987 23419 1998 VLN Violin C329 24239 23102 2010 2004 VLA VLN Viola Violin C843 C702 25778 1988 CLO Cello C873 44001 1987 FLT Flute C877 47888 2006 CLR Clarinet C901 Turner, 47291 1999 CLR Clarinet C171 Redesign this database so that it is in third normal form, write a database design outline in logical form. DO NOT INTRODUCE ADDITIONAL FIELDS! UNF: INF: 2NF: 3NF: Assignment #2 - Normalization: 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 is shown, spanning several school years. A blank value of DateReturned indicates that an instrument is still on loan. Instrument Tag Year Made Child ID Instrument Type Code VLN Instrument Type Name Violin 23482 2002 C873 23419 1998 VLN Violin C329 24239 44001 2010 1987 VLA FLT Viola Flute C843 C877 47291 1999 CLR Clarinet C901 67899 2005 ASX C321 67230 2010 ASX C447 9/20/2014 11/1/2014 Alto Saxophone Alto Saxophone Tenor Saxophone Trumpet 69233 1992 C447 55091 2001 TSX TPT TBN C221 Child Name Date Loaned Returned Chavez, 9/12/2014 6/12/2015 Marta Choudury 9/13/2014 6/12/2015 Ali Davis, Ramir 9/10/2014 6/10/2015 Johnson, 9/13/2014 6/15/2015 William Turner, 9/13/2014 6/6/2015 Elena Adderly. 9/20/2014 6/18/2015 James Mobley, Darren Mobley, 11/2/2014 6/18/2015 Darren Morgan, 9/18/2014 | 6/17/2015 Tajika Hampton, 9/18/2014 6/17/2015 John Chen, 9/18/2014 6/16/2015 Martha Choudury 9/8/2015 Ali Davis, Ramir. 9/8/2015 Rittenour, 9/8/2015 Madeline Chavez, 9/8/2015 Marta Johnson, 9/10/2015 William 9/10/2015 Elena Sharma, 9/12/2015 Rajika 58902 2011 Trombone C322 58771 2012 TBN Trombone 0987 23419 1998 VLN Violin C329 24239 23102 2010 2004 VLA VLN Viola Violin C843 C702 25778 1988 CLO Cello C873 44001 1987 FLT Flute C877 47888 2006 CLR Clarinet C901 Turner, 47291 1999 CLR Clarinet C171 Redesign this database so that it is in third normal form, write a database design outline in logical form. DO NOT INTRODUCE ADDITIONAL FIELDS! UNF: INF: 2NF: 3NF

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

Big Data 29th British National Conference On Databases Bncod 2013 Oxford Uk July 2013 Proceedings Lncs 7968

Authors: Dan Olteanu ,Georg Gottlob ,Christian Schallhart

2013th Edition

3642394663, 978-3642394669

More Books

Students also viewed these Databases questions

Question

Identify and control your anxieties

Answered: 1 week ago

Question

Understanding and Addressing Anxiety

Answered: 1 week ago