Database course, I need the answer for numbers six, seven and eight, please
Assignment 4: Database Implementation Introduction So far this semester, we have focused on database design tools such as entity-relationship diagrams to help us plan the structure of our database. This assignment asks students to complete this process by implementing a database design in MS Access. By the end of this assignment, students will have improved their ability to: .Reorganize a table to meet the standard of a relation (1NF); Reorganize data to meet the standard of well-formed relations (3NF); .Assign appropriate metadata and data types to attributes in the relational model; .Capture a database design with an entity-relationship diagram using Crow's foot notation; Implement a database design in the MS Access relational database management system. Instructions 1. 2. 3. 4. 5. Download assignment4.xlsx from the Blackboard course site. Review the data in the TABLE tab to understand the problem Copy the TABLE tab into a tab called RELATION. Reorganize the data in the RELATION tab to conform to the standard of a relation (1NF) Reorganize the data in the RELATION tab into a group of well-formed relations in which each tab represents a well-formed relation (3NF) After reorganizing the data into multiple well-formed relations, create an ERD representing your data model in MySQL Workbench. Your model should include: 6. Entities corresponding to your well-formed relations; Identifiers (primary keys) uniquely identifying each row in a table; Metadata appropriate to attributes describing the entity. MS Access data types should be used for this assignment when possible; Relationships that capture the cardinality between entities with properly defined foreign keys. Place a label on the ERD with your name, date and the course title and assignment 4 in the label. a. b. c. d. e. 7. Compare the model in your spreadsheet to that in your ERD. The two representations of your data should be as consistent as possible. Harmonize them if they are inconsistent. Implement your database design in MS Access including tables, properly defined attributes with well-chosen data types and other metadata, primary keys and foreign keys. Be sure to enforce referential integrity. 8. Library Library Phone Library Foundation Date Citizens' Library 0101(fax) 914-999-1010 (phone), 914-999 12-Jun-80 Book Title 3 ISBN 4 9780135862728 Moby Dick 5 9780135862728 Moby Dick Date Borrowed Date_Returned Book Inventory ID 1/1/2014 2/1/2014 1/14/2014 Ola Stone Ed Long 7 Public Library 123-456-7654 (phone 8 ISBN 9 9781908675309 The Scarlet Letter 10 9781907727214 The Awakening 11 9780135862728 Moby Dick 19-Jul-88 Book Title Date Borrowed Date Returned Book Inventory ID Ola Stone Ed Long Jim Slim 2/7/2014 2/1/2014 2/1/2014 2/5/2014 111-867-5309 (phone), 222-777 0998 (fax) Town Library 22-Mar-90 Book Title 14 ISBN 15 9781907727214 The Awakening 16 9781908675309 The Scarlet Letter 17 18 19 20 21 Date Borrowed Date Returned Book Inventory ID 2/1/2014 2/5/2014 2/10/2014 2/5/2014 Jim Slim Jim Slim 24 TABLE Assignment 4: Database Implementation Introduction So far this semester, we have focused on database design tools such as entity-relationship diagrams to help us plan the structure of our database. This assignment asks students to complete this process by implementing a database design in MS Access. By the end of this assignment, students will have improved their ability to: .Reorganize a table to meet the standard of a relation (1NF); Reorganize data to meet the standard of well-formed relations (3NF); .Assign appropriate metadata and data types to attributes in the relational model; .Capture a database design with an entity-relationship diagram using Crow's foot notation; Implement a database design in the MS Access relational database management system. Instructions 1. 2. 3. 4. 5. Download assignment4.xlsx from the Blackboard course site. Review the data in the TABLE tab to understand the problem Copy the TABLE tab into a tab called RELATION. Reorganize the data in the RELATION tab to conform to the standard of a relation (1NF) Reorganize the data in the RELATION tab into a group of well-formed relations in which each tab represents a well-formed relation (3NF) After reorganizing the data into multiple well-formed relations, create an ERD representing your data model in MySQL Workbench. Your model should include: 6. Entities corresponding to your well-formed relations; Identifiers (primary keys) uniquely identifying each row in a table; Metadata appropriate to attributes describing the entity. MS Access data types should be used for this assignment when possible; Relationships that capture the cardinality between entities with properly defined foreign keys. Place a label on the ERD with your name, date and the course title and assignment 4 in the label. a. b. c. d. e. 7. Compare the model in your spreadsheet to that in your ERD. The two representations of your data should be as consistent as possible. Harmonize them if they are inconsistent. Implement your database design in MS Access including tables, properly defined attributes with well-chosen data types and other metadata, primary keys and foreign keys. Be sure to enforce referential integrity. 8. Library Library Phone Library Foundation Date Citizens' Library 0101(fax) 914-999-1010 (phone), 914-999 12-Jun-80 Book Title 3 ISBN 4 9780135862728 Moby Dick 5 9780135862728 Moby Dick Date Borrowed Date_Returned Book Inventory ID 1/1/2014 2/1/2014 1/14/2014 Ola Stone Ed Long 7 Public Library 123-456-7654 (phone 8 ISBN 9 9781908675309 The Scarlet Letter 10 9781907727214 The Awakening 11 9780135862728 Moby Dick 19-Jul-88 Book Title Date Borrowed Date Returned Book Inventory ID Ola Stone Ed Long Jim Slim 2/7/2014 2/1/2014 2/1/2014 2/5/2014 111-867-5309 (phone), 222-777 0998 (fax) Town Library 22-Mar-90 Book Title 14 ISBN 15 9781907727214 The Awakening 16 9781908675309 The Scarlet Letter 17 18 19 20 21 Date Borrowed Date Returned Book Inventory ID 2/1/2014 2/5/2014 2/10/2014 2/5/2014 Jim Slim Jim Slim 24 TABLE
