Based on the ER above — Each record in SALES must have one related record in INVENTORY

Given the following is a relation with no known repeating groups: PROJECT-TEAMS(pCode, pName, pStart, pEnd, empID, eFName, eLName, jobTitle, empClass, consultRate, projPosition, projHour, projStart, projEnd, projRate) Dependencies: pCode –> pName, pStart, pEnd empID –> eFName, eLName, jobTitle, empClass, consultRate pCode, empID –> projPosition, projHour, projStart, projEnd, projRate jobTitle, empClass –> consultRate NOTE:  Primary keys must be solid underline. Since dashed underline cannot be drawn — foreign keys must be clearly designated with (FK) next to attribute.     Copy-paste below part into your answer and fill in your answer following each question A) Provide 1NF solutions below using relational notation. B) Provide 2NF solution below using relational notation.                                                                                                         C) Provide 3NF solution below using relational notation.                                                                                                         

  Complete the following SQL to show records of shoppingCarts that were not Ordered.   Hint:  after appropriate join between shoppingCart and Order, use a WHERE condition to identify the the shoppingCarts with no related records from Order  Copy-paste the following SQL and complete it for your answer SELECT S.* FROM shoppingCart S 

  Based on the ER above — it is known that not every Visitor is known to be either a Guest or a Customer.  Which of the following best describes the relationship?

  CustID Cust Type City PostalCode SalesOrderNum ProductID OrderQty LineTotal ProductName ProductLine ProductListPrice 697 S Tooele 84074 SO50270 863 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women’s Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women’s Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women’s Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women’s Mountain Shorts, S A 69.99 697 S Tooele 84074 SO51783 869 36 1133.838 Women’s Mountain Shorts, L A 69.99 302 S Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 125 S Stamford 06901 SO46610 863 35 598.3425 Full-Finger Gloves, L M 37.99 315 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L M 37.99   Column Name Explanation Column Name Explanation CustID id used for each customer — always 3 digits OrderQty quantity of product ordered Cust Type single letter code for differentiating types of customer LineTotal total charge for product ordered City city of shipping address for order (shortest is 5 letters and longest is 15 letter) ProductName name of product PostalCode zip code of shipping address for order — always 5 digits ProductLine single letter code for differentiating types of products SalesOrderNum unique number for each order – always 2 letters and 5 digits ProductListPrice list price of product ProductID id of each product — always 3 digits       The themes for which data is going to be stores are identified are: CUSTOMER, ORDER,  PRODUCT and PRODUCT ORDERED Select ALL columns that belong to the theme: CUSTOMER.  Note: More than one choices is correct.  Incorrect choices will be marked negatively 

   Based on the ER above — SERVREC entity has _____________ foreign key(s)

For a relation SUPPLIES below, there are no repeating groups and you are provided with the dependency information.  Which of the following statements are correct: SUPPLIES(SupNum, SupName, SupAdd, SupCity, SupZip, SupSt, ItemNum, ItemName, UnitPrice, QtyInStock, DiscountQty, Discount$) SupNum –> SupName, SupAdd, SupCity, SupZip, SupSt ItemNum –> ItemName, QtyInStock  SupNum, ItemNum –> UnitPrice, DiscountQty, Discount$ SupZip –> SupCity, SupSt

Write a SQL query to show all columns from AIRPLANES and PLANE INVENTORY Requirements: Must show all airplanes and only related records from plane inventory, for which the model begins with 7 and containts X; variant include ext; minseats is at least 30 and maxseats is at least 50 but no more than 100.

  The table PRODUCT includes ProductName and ProductNumber, which are sometimes repeated.  Write SQL query to show all the ProductName and ProductNumber such that no two records in the results shown are identical. 

  A result table needs to be produced to include: ID of customer, Sales Order Number and Order Date Write SQL query to show the result table that includes ID for all customers whether or not they have placed an order.  NOTE: ID for all customers is available as CustID in CUSTOMER table. Sales Order Number and Order Date are similarly named in SALES_ORDERS table