Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 10 Weeks Ago, 6 Days Ago |
Questions Answered: | 4870 |
Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Can you please me with my homework because I really don't understand any of it?????
Â
S06 Chapter 5 Conger Book Practices AssignmentNAME _________________________________The questons below are from ±he Conger Book Practces Assignmen± on page 100.Use ±his Assignmen±form ±o en±er your answer below each queston.Before completng This assignmenT please read The Suggestons for Scenarios in The Conger book onpage 81 and 101.HINT:This assignmen± is ±o expose you ±o ±he process of looking for multvalued columns, functonaldependencies and ±hemes, and ±hen checking for any additonal ±ransitve dependencies.DescriptonCharlie has a large book collecton. He was keeping ±rack of i± in a spreadshee±, bu± i± has grown bigenough ±ha± he wan±s ±o conver± i± in±o a real da±abase. Here is a sample from ±he spreadshee±:AuThorAuThor CounTry±iTlesJames TaylorEnglandJavaScript EssenTals, Sou±h Tech Books,London, 2010, $14;H±ML5 Exposed, WebbyBooks, London, 2012, $15.50May Nor±onUni±ed S±a±esBig Data Big Promise, Da±a Press, SanFrancisco 2012, $25Jessica LewisUni±ed S±a±esDatabase Development for the Cloud, Da±aPress San Francisco, $20.35;Data Services,Fu±ure Tech Press, New York $12.951.Wha± are some of ±he po±ental problems wi±h ±his layou± if carried direc±ly ±o ±he da±abase?2.Which of ±he columns in ±he example are multvalued?3.Crea±e a ±able ±ha± would show how you would conver± ±he sample da±a in±o Firs± Normal Form.(Hin±: Break ±he informaton in ±he Ti±les column in±o separa±e ²elds. Books are separa±ed bysemicolons.)
Attachments: