Access Millions of academic & study documents

Dad 220 cardinality and targeted data bansari patel

Content type
User Generated
School
SNHU
Showing Page:
1/7
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.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/7
2. Retrieve order details for orderNumber 10330, 10338, and 10194 and identify what type of
cardinality this represents in the entity relationship model.
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.]

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/7

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 7 pages?
Access Now
Unformatted Attachment Preview
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. 2. Retrieve order details for orderNumber 10330, 10338, and 10194 and identify what type of cardinality this represents in the entity relationship model. 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.] 4. Retrieve customer records for employee Rep Barry Jones and identify if the relationships are one-to-one or one-to-many. 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. 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. 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. Cardinality is the term used to d ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4