DAD 220 Cardinality and Targeted Data Mason Adam

docx

School

The University of Oklahoma *

*We aren’t endorsed by this school

Course

122

Subject

Business

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by BailiffIce6649

DAD 220 Cardinality and Targeted Data Template Replace the bracketed text in this template with your screenshots and responses. Then submit it 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. High Cardinality, one to zero Minima 3. Delete records from the payments table where the customer number equals 103.

a. 4. Retrieve customer records for sales representative Barry Jones and identify if the relationships are one-to-one or one-to-many . a. Relations are One to Many

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. Relations are One to Many 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. 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. Cardinality ensures the correct relations are enforced for information being tracked. The one-to-many relationships are the cause of differing number of records from different offices. b. Compare and contrast the different queries you ran and how cardinality applies to them. c. Because data in the tables aren't the same, Cardinality compares the data to that of the customers and employees by utilizing the matching information or relationships between the data (products, order numbers) in tables where the data would narrow the search, (salesRepEmployeeNumber, customerNumber, employeeNumber).

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

d. e. Describe two of the crucial benefits of cardinality in this type of database. i. Being able to input a command, narrowing what sales representatives have what customers, and compare data from various tables to maintain data integrity and availability ,

DAD 220 Cardinality and Targeted Data Mason Adam

Related Documents