Introduction to Database Man. Lab 1 TER SUMMARY 1. Premiere Products is an organization whose requirements include the following objects: a sales reps b. customers c orders d. parts c order lines 2. The database for Henry's Books contains information about the follow- ing objects: a branches b. publishers c. books d. authors e inventory REVIEW QUESTIONS (Premiere Products) Answer each of the following questions using the Premiere Products data as shown in Figure 2.2. No computer work is involved. In later chapters, you will use a database management system to answer questions. I. Find the names of all the customers who have a credit limit of at least $1500. 2. Give the order numbers of those orders placed by customer 124 on September 5, 1998. 3. Give the part number, description, and on-hand value (units on hand price) for each part in item class AP. 4. Find the number and name of all customers whose last name is Nelson 5. How many customers have a credit limit of $1000? 6. Find the total of the balances for all the customers represented by sales rep 12. 7. For each order, list the order number, order date, customer number and customer name. 8. For each order placed on September 5, 1998, list the order number order date, customer number, and customer name. 9. Find the number and name of all sales reps who represent any customer with a credit limit of $1000. 10. For each order. list the order number, order date, customer number, customer name, along with the number and name of the sales rep who represents the customer. SLSREP ZIP CODE 49219 0912.50 TSRTCITY 193 Mei Wam102 Raymond Ada Miguel 419 Harper Lansing 2150.00 MI 9234 CUSTOMER SUSREP CREDIT NUMBER CITY STATE ZIP CODE BALANCE Ob Lansing SHIR75 591.50 SOS 75 1770.75 51000 SISCO S1000 $750 34 48.391 914 Chen Del V Lansing 49224 49441 16 Elm S1817.50 598.75 a 88 = = = $1500 Tom AI Sally Mary The Mare Dan Neleon Dish Galvee Martin Harper MI MI MI MI MI 808 R 512 Pine 419 Chip 4944411 4 9219 511460 3 1046.75 $1000 S1000 Grant ORDER LINE ORDER ORDER CUSTOMER SNOVBER NUMBER ORDERED NUMBER AX12 U T04 12489 Sv NUMBER 12489 12491 12491 124 1 311 125 256 QUOTED PRICE $21.95 $149.99 $399.99 $279.99 $22.95 $12.95 $24.95 $149.99 $325.99 CBOS CXII AZ52 BA74 12495 12498 12504 905:58 12498 12500 12504 BTOU C281 2 PART PARE PARTE NIVERS ION RETUUNI UNITS ON HAND LITEN CLASS SS NUMBER WAREHOUSE NUMBER 104 20 UNIT PRICE $24.95 $12.95 $29.95 HW SGT SG HW 2 95 $24.95 AP AXI2 AZ52 BA74 BH22 BTO B266 CA14 CBO CXII Czsl Iron Dartboard Basketball Cornpopper Gas Grill Washer Griddle Bike Blender Treadmill 52 78 AP HW SG 3 3 $149.99 $399.99 $39.99 $299.99 $22.95 5349.95 112 HW 3 SG2 Figure 2.2 Sample data for Premiere Products
