407808 Library Management DB Design

Hello, I need a database design ( Schema, ERD and 3rd Normal Tables ) for a Library system, using MS Access 2007, I attached the details about this, thank you. ---- -Please DO NOT use any query builder for SQL Statements, -Please Use only MS Access 2007 -For the above model, produce a relational schema (i.e. transforming the conceptual data model into a logical relational schema) on one A4 page – DO NOT show the mapping steps. Your Relational Schema should show: • All entity and relationship types that are potential for a relational table. • For each potential table identify the primary key and any necessary foreign keys and all other attributes. • Show the links between the tables (e.g. a table-relationship diagram produced by MS Access) or, for each table, describe any links to other tables in SQL statement(s) -Normalization check: You need to check your produced Relational Schema above for 3rd NF. If it satisfies 3NF criteria then you ONLY need to include the statement “The Relational Schema satisfies 3NF criteria”. If your schema does not satisfy the criteria of 3NF then you need to reproduce your schema in 3NF. You DO NOT need to show the steps (i.e. process) of Normalization.