Read the description below, then use it to answer the following questions. The table below represents a bookstore's data on their books and book suppliers. SID = Supplier ID, S_Name = Supplier Name BID = Book ID, B_Title Book Title, B_Price = Book Price AID = Author ID, A_Name = Author Name Note: 1, 5, 11 means three Book IDs. Similarly, Artificial Intelligence, SQL means two Book Titles. Functional Dependencies are: SID -> S_Name BID -> AID SID 10 14 BID>B_Title AID -> A_Name SID and BID B Price S_Nam BID B_Title e Walden 1, Information Systems, 27, 5, Databases, 25, 11 SQL 22 Borders 2, 11, Artificial Intelligence, SQL B_Price 26, 21 AID 2, 4, 16 3, 16 A_Name C. Laudon, T. Williams, A. Oppel S. King, A. Oppel B. Normalize the Tables (60%). The final set of tables should have meaningful names and identified primary keys and foreign keys. C. Convert the normalized tables to instance tables using the following format (40%). Ensure that all relationships are preserved when converting the normalized tables to instance tables. Column Name: Key Type: Null/Unique: FK Table: FK Column: Data Type: Max Length: