Database and Database Manipulation Language
Not what you're looking for?
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.
Purchase this Solution
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.
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, ...
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C# variables and classes
This quiz contains questions about C# classes and variables.