Lab 5 - Normalization Consider the library system shown in the following figure which is used to keep track of books and borrowers. Book_ Book Title - Det er hon her_State Publisher Phong 23 13001 M1300 MO 8 04/21/2000 1002 MIO M100 MO VA 23:25 S2000 2018 6412 Dute de Wh Rating M MIG M1105 M130 SOON 562230000 B2340 2020 5220 42200 11004 Advanced programming with Pearson 100 Art of Computer Program MO MO M10 "Library System" is a spreadsheet from a poorly organized database. You are a database consultant hired to review their data and create a new database. 1. Find out all form of dependency that exist on the initial table. (8 pts) 2. Normalize the given table to INF. Describe your approach. (2 pts) 3. Normalize the result of the previous step to 2NF. Describe your approach. (8 pts) 4. Normalize the result of the previous step to 3NF. Describe your approach. (Spts) 5. Give each new table a name and list the attributes in each table. 6. Your solution should show the step-by-step normalization. 7. Specify primary and foreign keys. (4 pts) 8. Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields. (Except a Surrogate Key if needed) 9. Upload your answers in a PDF file Lab 5 - Normalization Consider the library system shown in the following figure which is used to keep track of books and borrowers. Book_10 Book Title 31001 Algorithm 81003 Programming with java Publisher Name Member_10 M1100 Wisely M1101 M1105 M1101 Wisely M1102 M1104 M1101 Wise M1102 MI105 Pearson M1107 M1101 Pearson M1104 Member_Name John Bowser Sara Smith Anne Smithson Sara Smith Raphael Katinga Gerald Robertson Sara Smith Raphael Rating William Bowser Jason Will Sara Smith Gerald Robertson Borrow_Date Member Phone Publisher_State Publisher_Phone 02/04/2019 2233445566 12/05/2015 3456765432 MD 9998887776 04/28/2020 9876543212 02/06/2018 3456765432 09/24/2019 2222233334 VA 9976543215 05/03/2018 3887776665 05/01/2018 3456765432 4/28/2020 2222233334 MA 4567890000 OR/03/2020 9000077654 5/8/2013 4445556669 MD 3341212340 4/21/2020 3456765432 WA 3344500000 01/03/2020 8887776665 31003 Database delle 31004 Advanced programming with C+ 81005 Ant of Computer Programming "Library System" is a spreadsheet from a poorly organized database. "Library System" is a spreadsheet from a poorly organized database. You are a database consultant hired to review their data and create a new database. 1. Find out all form of dependency that exist on the initial table. (8 pts) 2. Normalize the given table to INF. Describe your approach. (2 pts) 3. Normalize the result of the previous step to 2NF. Describe your approach. (8 pts) 4. Normalize the result of the previous step to 3NF. Describe your approach. (8pts) 5. Give each new table a name and list the attributes in each table. 6. Your solution should show the step-by-step normalization. 7. Specify primary and foreign keys. (4 pts) 8. Do not include the data. The data is provided for your reference. You may have to reuse attributes, but do not create any additional fields. (Except a Surrogate Key if needed) 9. Upload your answers in a PDF file
