Questions from Database Management

Q: Suggest an application for each type of file organization. Explain your

Suggest an application for each type of file organization. Explain your answer.

Q: Parallel query processing, as described in this chapter, means that

Parallel query processing, as described in this chapter, means that the same query is run on multiple processors and that each processor accesses in parallel a different subset of the database. Anothe...

Q: Consider the following assumptions: • A music company offers three

Consider the following assumptions: • A music company offers three types of music genres: Jazz, Hip-hop, and Metal (subtypes of the Genre supertype). An “Artist” instances “Records” of these Genres. •...

Q: Create an index on the CustomerID column of the Customer_T

Create an index on the CustomerID column of the Customer_T and Order_T table in Figure 4-4. Data from Figure 4-4:

Q: Consider the composite usage map in Figure 8-1. After

Consider the composite usage map in Figure 8-1. After a period of time, the assumptions for this usage map have changed, as follows: • There is an average of 60 supplies (rather than...

Q: Consider the EER diagram for Pine Valley Furniture shown in Figure 3

Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 8-15 looks at a portion of that EER diagram. Let’s make a few assumptions about the average usage of t...

Q: Refer to Figure 4-5. For each of the following

Refer to Figure 4-5. For each of the following reports (with sample data), indicate any indexes that you feel would help the report run faster as well as the type of index: a. State, by products (user...

Q: Fill in the two authorization tables for Pine Valley Furniture Company below

Fill in the two authorization tables for Pine Valley Furniture Company below based on the following assumptions (enter Y for yes or N for no): • Salespersons, managers, and carpenter...

Q: For each of the situations described, decide which technique for data

For each of the situations described, decide which technique for data field design listed below would be most appropriate and how it could be applied. • Code lookup table • Default value • Range con...

Q: A number of situations have been listed below. For each one

A number of situations have been listed below. For each one, identify the need, if any, to create an index. Justify your answer. If there is indeed a need, suggest a way for the index to be created. a...