Questions from Database Systems


Q: Identify the foreign keys. Data from FIGURE Q3.

Identify the foreign keys. Data from FIGURE Q3.18 The Ch03_Theater Database Tables:

See Answer

Q: Define each of the following terms:

Define each of the following terms:

See Answer

Q: What is data redundancy, and which characteristics of the file system

What is data redundancy, and which characteristics of the file system can lead to it?

See Answer

Q: What is data independence, and why is it lacking in file

What is data independence, and why is it lacking in file systems?

See Answer

Q: Given the file structure shown in Figure P1.1, what

Given the file structure shown in Figure P1.1, what data redundancies do you detect? How could those redundancies lead to anomalies?

See Answer

Q: Identify and discuss the serious data redundancy problems exhibited by the file

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5.

See Answer

Q: Why is an object said to have greater semantic content than an

Why is an object said to have greater semantic content than an entity?

See Answer

Q: Looking at the EMP_NAME and EMP_PHONE contents in

Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend?

See Answer

Q: Identify the various data sources in the file you examined in Problem

Identify the various data sources in the file you examined in Problem 5. Data from problem 5:

See Answer

Q: Given your answer to Problem 7, what new files should you

Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

See Answer