Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_ PILOT, and CHAR_COPILOT attributes for charters flown by both employee 105 and employee 109.

JOIN TABLES One row in the PAT_ENC table represents one patient encounter. One row in the ORDER MED table represents one medication order. One patient encounter can have many medication orders but one medication order can only have one patient encounter. In other words, the cardinality of this PAT_ENC to ORDER_MED relationship is one-to- many. You start a query with PAT_ENC. You then add ORDER_MED using an inner join. What is true about the granularity of the result set before and after adding the ORDER_MED table? SELECT ONE OF THE FOLLOWING A. The granularity stays at one row per patient encounter. B. The granularity stays at one row per medication order. C. The granularity changes from one row per patient encounter to one row per medication order on an encounter. D. The granularity changes from one row per medication order to one row per patient encounter.

Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator.   Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000.     List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron.       Down below are the tables ORDER_LINE ORLN_ORDER_NUMBER               ORLN_PART_NUMBER ORLN_NUMBER_ORDERED          ORLN_QUOTED_PRICE   ORDER_TABLE ORDR_ORDER_NUMBER               ORDR_ORDER_DATE               ORDR_CUSTOMER_NUMBER   CUSTOMER CUST_NUMBER CUST_LAST         CUST_FIRST        CUST_STREET     CUST_CITY          CUST_STATE        CUST_ZIP_CODE               CUST_BALANCE CUST_CREDIT_LIMIT       CUST_SALES_REP_NUM               PART PART_NUMBER  PART_DESCRIPTION         UNITS_ON_HAND…

2. Create a SELECT statement that returns the ORDER_NUM and PROD_ID for all records in the ORDERITEMS table. Using inner joins include the vendor name, product name and customer name for each item.