Database Reference
In-Depth Information
49. What is a visibility symbol in UML?
50. What is multiplicity?
51. What is generalization?
52. What are the 14 rules against which you can measure object-oriented systems?
Premiere Products Exercises
For the following exercises, you will answer problems and questions from management at Premiere Products. You
do not use the Premiere Products database for any of these exercises.
1. Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customers
of rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named
CustomerRep65. (Include all fields from the Customer table in each fragment.) In addition, you need to fragment
the Orders table so that orders are distributed and stored with the customers that placed the orders. For
example, fragment OrdersRep20 consists of those orders placed by customers of rep 20. Write the SQL-type
statements to create these fragments.
2. Create a class diagram for the Premiere Products database, as shown in Chapter 1, Figure 1-5. If you need to
make any assumptions in preparing the diagram, document those assumptions.
3. A user queries the Part table in the Premiere Products database over the company intranet. Assume the Part
table contains 5,000 rows, each row is 1,000 bits long, the access delay is 2.5 seconds, the transmission rate is
50,000 bits per second, and only 20 of the 5,000 rows in the Part table satisfy the query conditions. Calculate
the total communication time required for this query based on retrieving all table rows one row at a time, then
calculate the total communication time required based on retrieving the 20 rows that satisfy the query conditions
in a single message.
313
Henry Books Case
Ray Henry asks you to research improvements he might make to his database processing. To help him, he would
like you to complete the following exercises. You do not use the Henry Books database for any of these exercises.
1. Use computer magazines or the Internet to investigate one of these DBMSs: DB2, SQL Server, MySQL, Oracle,
or Sybase. Then prepare a report that explains how that DBMS handles two of the following distributed data-
base functions: deadlock, fragmentation, replication, the data dictionary or log, and distributed queries.
2. Create a class diagram for the Henry Books database, as shown in Chapter 1, Figures 1-15 through 1-18. If you
need to make any assumptions in preparing the diagram, document those assumptions.
Alexamara Marina Group Case
For the following exercises, you will answer problems and questions from the Alexamara Marina Group staff. You do
not use the Alexamara database for any of these exercises.
1. Use computer magazines, books, or the Internet to investigate one of the following Web services: Application
Programming Interface (API); Common Gateway Interface (CGI); Simple Object Access Protocol (SOAP);
Universal Description, Discovery, and Integration (UDDI); or Web Services Description Language (WSDI). Then,
prepare a report that defines the Web service and explains its purpose and features.
2. Create a class diagram for the Alexamara database, as shown in Chapter 1, Figures 1-20 through 1-24. If you
need to make any assumptions in preparing the diagram, document those assumptions.
