Questions from Database Management

Q: Define each of the following terms: a. data

Define each of the following terms: a. data b. information c. metadata d. enterprise resource planning e. data warehouse f. constraint g. database h. entity i. database management system j. data lake...

Q: Suppose your university is offering some courses in business analytics: a

Suppose your university is offering some courses in business analytics: a six-month certificate course, a two-year regular program, and a three-year part-time program. You are required to design a Web...

Q: Table 4-4 shows a relation called GRADE REPORT for a

Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal f...

Q: Table 4-5 shows a shipping manifest. Your assignment is

Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? c. Dec...

Q: Transform the relational schema developed in Problem and Exercise 4-37

Transform the relational schema developed in Problem and Exercise 4-37 into an EER diagram. State any assumptions that you have made. Data from Problem and Exercise 4-37: Table 4-5 shows a shipping m...

Q: For your answers to the following Problems and Exercises from prior chapters

For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the rela...

Q: Transform Figure 2-15a, attribute version, to 3NF relations

Transform Figure 2-15a, attribute version, to 3NF relations. Transform Figure 2-15b, relationship version, to 3NF relations. Compare these two sets of 3NF relations with those in Figure 4-10. What obs...

Q: The Public Safety office at Millennium College maintains a list of parking

The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Att...

Q: The materials manager at Pine Valley Furniture Company maintains a list of

The materials manager at Pine Valley Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data re...

Q: Table 4-8 shows extracts from a customer’s flight booking confirmation

Table 4-8 shows extracts from a customer’s flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer id, their flight ori...