Assignment #3
(80 points)
- Read Chapter #3 "Structured Query Language".
- Answer 25 Review Questions at the end of the chapter.
Your answers must include the page number(s) of where the topic is
introduced in the textbook. To provide you an example, I have
answered the first question in the link above.
- Create a database and query the database as
shown in the video Structured Query Language
(CC).
Pages 222-251 provide details and screen captures on how to use
the "Query Design" command button.
Your database must contain two tables "CUSTOMER" and "CONTACT" that have been created
and populated with data. (MS Excel data).
A 1:N relationship should be created
between the CUSTOMER and the CONTACT table.
Enter your first and last name as one of the customers.
You will then query your database to retrieve:
all customers, all customers from Oklahoma, all customers from Tulsa,
all contacts via a phone, and all contacts created since January 1, 2024.
Copy the SQL code generated by MS Access and paste these statements at the
end of your "Chapter3 Review Questions" into the following areas.
Save your database as "assignment3.aacdb".
- SQL code to retrieve All Customers in the “CUSTOMER” table.
- SQL code to retrieve all customers from “Oklahoma” in the “CUSTOMER” table.
- SQL code to retrieve all customers from “Tulsa” in the “CUSTOMER” table.
- SQL code created to retrieve all “phone” contacts using a “JOIN” operation with the “CUSTOMER” and “CONTACT” table.
- SQL code created to retrieve all contacts created since January 1, 2024 using a “JOIN” operation with the “CUSTOMER” and “CONTACT” table.
- Upload both files to YOUR-CLASS-WEBSITE.
Help
|