Database Reference
In-Depth Information
5. What is a database?
6. How do you create a one-to-many relationship in a database system?
7. What is an E-R diagram?
8. What is a DBMS?
9. What is database design?
10. What is a form?
11. How is it possible to get more information from the same amount of data by using a database approach as
opposed to a nondatabase approach?
12. What is meant by the sharing of data?
13. What is a DBA? What kinds of responsibilities does a DBA have in a database environment?
14. How does consistency result from controlling redundancy?
15. What is an integrity constraint? When does a database have integrity?
16. What is security? How does a DBMS provide security?
17. What is data independence? Why is it desirable?
18. How is file size a disadvantage in a database environment?
19. How can the complexity of a DBMS be a disadvantage?
20. Why can a failure in a database environment be more serious than an error in a nondatabase environment?
21. Why might recovery of data be more difficult in a database environment?
29
Premiere Products Exercises
Answer each of the following questions using the Premiere Products data shown in Figure 1-5. No computer work is
required.
1. List the names of all customers that have a credit limit less than $10,000.
2. List the descriptions of all parts in item class AP and located in warehouse number 3.
3. List the order numbers for orders placed by customer number 608 on October 23, 2013.
4. List the part number, part description, and on-hand value (OnHand * Price) for each part in item class SG.
5. List the name of each customer that placed an order for two different parts in the same order.
6. List the name of each customer that has a credit limit of $5,000 and is represented by Richard Hull.
7. Find the sum of the balances for all customers represented by Juan Perez.
8. For each order, list the order number, order date, customer number, and customer name.
9. For each order placed on October 21, 2013, list the order number, order date, customer number, and customer
name.
10. For each order placed on October 20, 2013, list the order number and customer name, along with the name of
the rep who represents the customer.
Henry Books Case
In later chapters, you will be asked to perform many tasks to help Ray Henry manage and manipulate his database.
To familiarize yourself with the database in preparation for those tasks, answer each of the following questions using
the Henry Books data shown in Figures 1-15 through 1-18. No computer work is required.
1. List the name of each publisher that's not located in New York.
2. List the title of each book published by Penguin USA.
3. List the title of each book that has the type MYS.
4. List the title of each book that has the type SFI and that is in paperback.
