5

1. Where 2. From 3. Select 4. Order 5. Join 6. Isolate a. Isolate columns (attributes) in a table. b. Isolate records in a table. c. Select the table(s) to be used in the query. 5. (8 ponts) How do users retrieve data stored in a database? A) by viewing the appropriate data tables B) by executing a query C) by performing a search D) by specifying the primary keys 6. (15 points) Which two records in the following partial order table vic rules. Indicate which record violated a rule and name the rule that way Partial Order Table Order # Customer # Date 2000 101 1-Jun 2001 105 1-Jun 2002 1-Jun 2004 104 1-Jun 2005 106 1-Jun 2005 102 1-Jun Partial Custo Customer # 100 101 102 103 104 106 107