SQL, DATA WAREHOUSE, AND DATA MARTS-Module 4 Case Database and Database Manipulation Language SQL AND DATA WAREHOUSE Name Course Instructor Date Part I Introduction A database store information in a central location for one department or specific area in an organization, making it easier to share such information. Since the databases have the ability to recall information, users can identify specific information that is required by the users. The use of queries in this case focuses on identifying the check out details for customers who have borrowed books and they are overdue. Populate data to the tables in your database Insert into ‘book’ values
Check out table
Retrieve names and phone number of customers who have overdue books as of a certain date. SELECT “SSN”, “Name”, “Phone”, “Email” FROM “Student contact”
Retrieve the contact details of library customers who live in certain city. SELECT “NAME”, “PHONE NUMBER”, “CITY” FROM “COMMUNITY LIBRARY” WHERE “City”= ‘San Diego’ Retrieve names and phone number of customers who have overdue books as of a certain date. Select “SSN”NAME”, “DATE DUE”, FROM CHECK OUT WHERE DATE DUE< ‘CURRENT DATE’ 6] Describe what you have learned in this assignment The SQL is a standardized language that allows querying and updating of database tables, and...