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.