Cardinality and Targeted Data Template

DAD 220 Cardinality and Targeted Data Template

Replace the bracketed text in this template with your screenshots and responses to the Module Four Lab for submission, grading, and feedback. Screenshots should be sized to approximately one quarter of a page. Written responses should be in complete sentences. Rename this document by adding your last name to the file name before you submit.

1. Retrieve employee tuples and identify the number of employees in San Francisco and New York.
a. [Insert a screenshot of both tables (they should both fit in one screenshot) here.]

2. Retrieve order details for orderNumber 10330, 10338, and 10194 and identify what type of cardinality this represents in the entity relationship model.
a. [Insert your response here.]

3. Delete records from the payments table where the customer number equals 103.
a. [Insert a screenshot of this data before you delete it here.] b. [Insert a screenshot showing that you have successfully deleted these records here.]

4. Retrieve customer records for employee Rep Barry Jones and identify if the relationships are one-to-one or one-to-many.
a. [Insert your response here.]

5. Retrieve records for customers who reside in Massachusetts, then identify their sales rep and the relationship of entities. Identify if these entities demonstrate one-to-one or many-to-many relationships.
a. [Insert 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. [Insert a screenshot of your unique customer record here.]

7. Reflection
a. Define how cardinality is applied to the databases you’ve been working with and why different numbers of records returned from the different offices.
i. [Insert your response here.] b. Compare and contrast the different queries you ran and how cardinality applies to them.
i. [Insert your response here.] c. Describe two of the crucial benefits of cardinality in this type of database.
i. [Insert your response here.]