PLEASE COMPLETE QUICKLY

3. As a Database Administrator, part of your job is to design the database. Among the techniques in database design we normalization and data modeling. Examine the following tables and business rules Business Rules: Authors, ISBN and Borrower ID uniquely identify the author, book and borrower respectively. A book may have many copies with different condition. The country is where the author currently resides. Authors Authors Country Title ISBN Coronald USA Database Systems 068 Morris Modem DB Management 916 DBA in three easy lesso 112 Connolly and USA Database Systems 183 Beer Date England Introduction to DB Systems DB for beginners 207 321 Page 4 of 5 L Hoffe USA Modern DB Management DB Management 916 204 Borrowed Name Borrower ID ISBN Copy# Condition Muzaffar B1 207 204 2 3 Good Poor Daniel B2 068 2 Excellent Natasha B3 112 204 2 1 Poor Good Erina B6 207 188 1 3 Good Good Emir B7 188 2 Excellent a) Normalise the two related tables to Third Normal Form based on the UNF above, listing any further business rules as applicable. State any assumptions made. (6 marks) b) Based on your Third Normal Form (3NF) tables, develop a Crow's Foot Entity Relationship Diagram (ERD). (9 marks)