Questions from Database Systems

Q: What does it mean to say that SQL operators are set-

What does it mean to say that SQL operators are set-oriented?

Q: The relational set operators UNION, INTERSECT, and MINUS work properly

The relational set operators UNION, INTERSECT, and MINUS work properly only if the relations are union-compatible. What does union-compatible mean, and how would you check for this condition?

Q: What is an information system? What is its purpose?

What is an information system? What is its purpose?

Q: What steps are required in the development of an ER diagram?

What steps are required in the development of an ER diagram? (Hint: See Table 9.3.)

Q: List and briefly explain the activities involved in the verification of an

List and briefly explain the activities involved in the verification of an ER model.

Q: What factors are important in a DBMS software selection?

What factors are important in a DBMS software selection?

Q: Create a query to produce the total purchase per invoice, generating

Create a query to produce the total purchase per invoice, generating the results shown in Figure P7.33. The Invoice Total is the sum of the product purchases in the LINE that corresponds to the INVOIC...

Q: List and briefly explain the four steps performed during the logical design

List and briefly explain the four steps performed during the logical design stage.

Q: List and briefly explain the three steps performed during the physical design

List and briefly explain the three steps performed during the physical design stage.

Q: What three levels of backup may be used in database recovery management

What three levels of backup may be used in database recovery management? Briefly describe what each of those three backup levels does.