DAD 220 Lab 4

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by MajorNightingalePerson1051

Report
Cardinality and Targeted Data DAD-220-T3775 Professor Marcia Rogowsky Shaun Saini 01/25/22
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.
The type of cardinality used in the ERD document would be multiple attributes. The reason for this is because there is one order with multiple order details. The order details show products from that specific order. 3. Delete records from the payments table where the customer number equals 103. Before Delete.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help