4. List the last name, first name, and city of every owner who has more than one boat stored at the marina. 5. List the last name, first name, and city of every owner with a boat located in a slip whose rental fee is greater than $2,500. 6. List the boat name and boat type of all boats that are stored at the Alexamara East marina. 7. List the last name and first name of the owner and the boat name of all boats that have a completed or open service request. 8. List the boat name and boat type of all boats that have two or more completed or open service requests. 9. List the boat name and boat type of all boats that have a completed or open service request for a fiberglass or canvas-related service. 10. List the boat name and the last and first names of the owners for all boats that have engine repair service requests. Review Questions: 1-28 even 2. What is a relational database? 4. How is the term attribute used in the relational model? What is a more common name for atttribute? 6. What does it mean to qualify a field name? How would you qualify the Street field in the Customer table? 8. How do you include a field in an Access query? 10. How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria? 12. In which row of the Access design grid do you include functions? What functions can you use in Access queries? 14. When sorting data on more than one field in an Access query, which field is the major sort key? Which field is the minor sort key? What effect do these keys have on the order in which the rows are displayed? 16. When do you use an update query? 18. When do you use a make-table query? 20. Describe the purpose of the SELECT command in relational algebra. 22. Describe the purpose of the JOIN command in relational algebra. 24. Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions? 26. Describe the purpose of the SUBTRACT command in relational algebra. 28. Describe the results of the division process in relational algebra. Premiere Products Exercises QBE: Exercises 1-16 ..Premiere Products Exercises: QBE In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the Premiere Products database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take ..In this exercise you will make a copy of the Premiere Products database to complete the exercises. Use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercise using a computer. 1. List the number and name of all customers. 2. List the complete Part table. 3. List the number and name of all customers represented by sales rep 35. 4. List the number and name of all customers that are represented by sales rep 35 and that have a credit limit of $10,000. 5. List the number and name of all customers that are represented by sales rep 35 or that have a credit limit of $10,000. 6. For each order, list the order number, order date, number of the customer that placed the order, and name of the customer that placed the order. 7. List the number and name of all customers represented by Juan Perez. 8. How many customers have a credit limit of $10,000? 9. Find the total of the balances for all customers represented by sales rep 35. 10. Give the part number, description, and on-hand value (OnHand * Price) for each part in item class HW. 11. List all columns and all records in the Part table. Sort the results by part description. 12. List all columns and all records in the Part table. Sort the results b…
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |