[Insert a screenshot of this data before you delete it here.]
c.
Delete the records from the Payments table for customer number 103.
d.
Run a SELECT statement against the table to show that customer number 103 is no longer there.
[Insert a screenshot showing that you have successfully deleted these records here.]
4.
Retrieve customer records for sales representative Barry Jones and
identify
if the relationships
are one-to-one or one-to-many
.
a.
Remember: SELECT, FROM, INNER JOIN, and WHERE.
b.
Use Barry’s employeeNumber, 1504, and perform a join between the customer salesRepEmployeeNumber to retrieve these records.
i.
Identify whether these entities demonstrate one-to-one or many-to-many relationships.
[Insert a screenshot and your response here.]
5.
Retrieve records
for customers who reside in Massachusetts and identify
their sales rep and the relationship of entities
. Identify if these entities demonstrate one-to-one or many-to-many relationships.
a.
Remember: SELECT, FROM, INNER JOIN, and WHERE.
b.
Use employee.firstName and employee.lastName in your command.
c.
Identify whether these entities demonstrate one-to-one or many-to-many relationships.
[Insert a screenshot and your response here.]
6.
Add one customer record
with your last name using an INSERT statement. You may use the name of a celebrity or fictional character if you don’t use your own name.
a.
You may use the name of a celebrity or fictional character if you don’t use your own name. Think of this as your signature.
b.
Complete these actions to get to the right place to enter this information: (1) Show databases, (2) use classicmodels, (3) show tables, (4) describe customers;
i.
You should now see all of the fields that you’ll need to fill in to complete this step.
ii.
Reference your Module Two lab or resources on how to populate these fields if you need to.
iii.
Populate the following fields:
customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2
