Questions from Database Systems

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.9. (The file is meant to be used as a teacher class assignment schedule. One of the many pr...

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

Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?

Q: Using your school’s student information system, print your class schedule.

Using your school’s student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name...

Q: Convert the ERD from Problem 10 into the corresponding UML class diagram

Convert the ERD from Problem 10 into the corresponding UML class diagram.

Q: Describe the relationships (identify the business rules) depicted in the

Describe the relationships (identify the business rules) depicted in the Crow’s Foot ERD shown in Figure P2.13.

Q: Create a Crow’s Foot ERD to include the following business rules for

Create a Crow’s Foot ERD to include the following business rules for the ProdCo company: a. Each sales representative write many invoices. b. Each invoice is written by one sales representative. c. Ea...

Q: Write the business rules that are reflected in the ERD shown in

Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, reme...

Q: What is the difference between an object and a class in the

What is the difference between an object and a class in the object-oriented data model (OODM)?

Q: Create a Crow’s Foot ERD for each of the following descriptions.

Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.) a. Each of the MegaCo Corporation’s divisions...

Q: Write the business rules that are reflected in the ERD shown in

Write the business rules that are reflected in the ERD shown in Figure P2.17.