Answered step by step
Verified Expert Solution
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
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: 3NFStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started