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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!