Explore BrainMass

Explore BrainMass

    Database and Database Manipulation Language

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com December 15, 2020, 9:55 pm ad1c9bdddf

    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.