Question: Library Database assignment Library Database A small library hired you to build its database. You have to create a new Access Database with the following
Library Database assignment Library Database A small library hired you to build its database. You have to create a new Access Database with the following entities and attributes: Customer: last name, first name, phone number, email, street, city, state, Zip code Book: title, last name, first name, ISBN, cost, date purchased, edition, copyright year, description Enter at least 10 instances on each entity. (10 Customers, 10 Books, 10 Checkouts, and details for each checkout with a different number of details (books) for each checkout Save your database as: Lastname Firstname_Book Library Include the files: Lastname Firstname_Receipt.pdf (report for a single checkout) Lastname Firstname Checkout pdf (report of all checkouts by date Lastname Firstname Customer Chechout.pdf (report of checkouts by customer) . Lastname_Firstname Customer_report.pdf (report of all customers) Lastname_Firstname_books_report.pdf (report of all books)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
