Questions from Database Systems

Q: What is a derived attribute? Give an example.

What is a derived attribute? Give an example.

Q: How is a relationship between entities indicated in an ERD? Give

How is a relationship between entities indicated in an ERD? Give an example, using the Crow’s Foot notation.

Q: Discuss two ways in which the 1:M relationship between COURSE

Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented.

Q: How is a composite entity represented in an ERD, and what

How is a composite entity represented in an ERD, and what is its function? Illustrate the Crow’s Foot model.

Q: What three (often conflicting) database requirements must be addressed in

What three (often conflicting) database requirements must be addressed in database design?

Q: Briefly, but precisely, explain the difference between single-valued

Briefly, but precisely, explain the difference between single-valued attributes and simple attributes. Give an example of each.

Q: What are multivalued attributes, and how can they be handled within

What are multivalued attributes, and how can they be handled within the database design?

Q: Write the ten cardinalities that are appropriate for this ERD.

Write the ten cardinalities that are appropriate for this ERD. FIGURE Q4.17

Q: Write the business rules reflected in this ERD.

Write the business rules reflected in this ERD.

Q: Create an ERD based on the Crow’s Foot model, using the

Create an ERD based on the Crow’s Foot model, using the following requirements: • An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by...