1. Retrieve order details for orderNumber 10330, 10338, and 10194 by running SELECT queries with WHERE clauses against the orders table.
2. Then, reference the Module Four Lab ERD to assist in identifying relationships. A version with alternative text is available: Module Four Lab ERD With Alternative Text.
3. Now, identify what type of cardinality this represents in the entity relationship model.

    

4+ productlines * productLine textDescription htmlDescription image employees * employeeNumber lastName: firstName extension email officeCode. reports To job Title offices officeCode city phone addressLine1 addressLine2 state country postalCode territory MySQL Sample Database Diagram HH He 10 products productCode productName productLine productScale productVendor product Description quantityInStock buyPrice MSRP customers * customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postal Code country salesRepEmployeeNumber creditLimit HH |++ 4+ Ot et orderdetails orderNumber * productCode quantityOrdered priceEach orderLineNumber orders * orderNumber orderDate required Date shippedDate status comments customerNumber payments customerNumber *checkNumber payment Date amount