Chapter 2 Lab -Dipping a toe in SQL
Purpose
The purpose of this lab is to get comfortable with SQL. Do the two debug assignments on Blackboard FIRST
Overall Description
You will create a small database in 2NF in APEX that captures the following information:
Customer information including which products the customer has bought. Their identifying information (ID, First Name, Last Name, Address, Phone Number, and three other pieces of information you may want to capture) and three other pieces of information.
Productinformation including which customers have bought the product, which department the product is from, how much it costs to buy, how much we sell it for, the productID. In addition to these fields, three extra pieces of information.
Please keep in mind it is up to you design how this information is stored and in which tables. What is listed above is NOT going to be your table schema...it's just pieces of information you need to capture. For example, you may need to add junction tables if the connections are many to many. The specs above give you the information that needs to be available. How you decide to store these in tables is completely up to you.
What to do
Use the slides and other information provided to you to create a small database in APEX by using SQL commands
Deliverable
- The script used to create your database in a .txt file uploaded to Blackboard
- A one-page report explaining your database design (including why it is in 2NF) single spaces calibiri font 11 or equivalent.