You are maintaining a small library for you and your friends to share so everyone can add books, and check in and out books for their own use. This small library has grown lately, and you would like to create a small database to manage it better. After careful consideration, you think that the database should store the following data (which is not presented in any particular order or structure). You may have additional data not specifically listed below. Book author(s) - there may be more than one per book Book title ISBN (International Standard Book Number) 13-digit number - unique book identifier Publisher The year when the book was published Number of pages Friend who donated the book to the library Original price paid for the book (by the friend) Where the book was bought When the book was bought Book category (fiction, non-fiction, reference) Book genre (horror, romance, adventure, etc.) Book's subject matter (what the book is about; dogs, technology, cars, etc.) Friend who borrowed the book When the book was checked out When the book was checked in For how long a book was borrowed by one of your friends Complete the following steps: 1. Build a list of business needs, rules and assumptions based upon the scenario and information provided. Include AT LEAST 10 items. 2. Create a relational schema (introduced in Chapter 4) for each entity following the rules of normalization. Show your progression through each normal form from 1st through 3rd, including an explanation of how you have met each normal form. 3. Create an ER Diagram. Define the relationships between the entities, including optionality and cardinality. Use Crow's Foot notation. Refer to Figure 4.35 in Chapter 4 for an example of what your diagram should look like. 4. For organizational purposes, create a data dictionary table (refer to Table 3.6 in Chapter 3). 5. Determine at least 5 indexes you will create and provide a justification.