Week-2

Discuss the mechanism of attribute/relationship inheritance. Why is it useful? Discuss the two main types of constraints on specializations and generalizations. A minimum of 1 outside reference is required along with APA formatting. (LO1) (LO3)

Week-3

Discuss some types of queries for which renaming of attributes is necessary to specify the query unambiguously.

Discuss the various types of inner join operations. Why is theta join required?

Week-4

What is ODBC? How is it related to SQL/CLI? List the three main approaches to database programming. What are the advantages and disadvantages of each approach? A minimum of 1 outside reference is required, along with APA formatting. (LO2).

Week-5

What is the difference between primary and secondary storage? Discuss the mechanism used to read data from or write data to the disk. What is the difference between static and dynamic files? A minimum of 1 outside reference is required, along with APA formatting. (LO1) (LO3).

Week-6

Discuss the different types of parameters that are used in cost functions. Where is this information kept?

Discuss the cost components for a function used to estimate query execution cost. Which cost components are used most often as the basis for cost functions?

Week-7

Discuss the UNDO and REDO techniques of recovery. What are the advantages and disadvantages of this technique?

Discuss how disaster recovery from catastrophic failures is handled.

Week-8

Discuss each term: database authorization, access control, data encryption, privileged (system) account, database audits, and audit trail.

Discuss the types of privilege. What is meant by revoking a privilege?