Explore BrainMass

Database and Database Manipulation Language

In this case assignment, you will write the SQL statement to work on the community library database. Following are the tasks you are required to perform:

1. Populate data to the tables in your database
2. Retrieve the contact details of library customers
3. Retrieve the contact details of library customers who live in certain city
4. Update the residence information of a certain customer
5. Retrieve names and phone number of customers who have overdue books as of a certain date
6. Describe what you have learned in this assignment.
Write a paper (2-5 pages) that includes your SQL statements and screenshots of the queries in OpenOffice.

Solution Preview

Please find attached document and access database for this exercise.

1. Customer, Library_Card, and Customer_CheckOut tables populated

2. SELECT Customer.CustomerNo, Customer.FirstName, Customer.LastName, Customer.StreetNo, Customer.StreetName, Customer.City, Customer.State, Customer.ZipCode, ...

Solution Summary

This solution will help to understand how to insert, update, and retrieve information from database tables created in an Access database. The business model is a community library database where members take borrow and return library material. Information stored in the database helps the library manage all transactions that take place on a daily basis.