Reference no: EM133508400
Discussion Post
Part I
Question 1. Describe what a database is?
Question 2. Discuss the main characteristics of the database approach and how it differs from traditional file systems. Discuss the differences between database systems and information retrieval.
Part II
Question: 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)
Part III
Question 1. Discuss some types of queries for which renaming of attributes is necessary to specify the query unambiguously.
Question 2. Discuss the various types of inner join operations. Why is theta join required?
Part IV
Question: 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).
Part V
Question: 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?
Part VI
Question 1. Discuss the different types of parameters that are used in cost functions. Where is this information kept?
Question 2. 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?
Part VII
Question 1. Discuss the UNDO and REDO techniques of recovery. What are the advantages and disadvantages of this technique?
Question 2. Discuss how disaster recovery from catastrophic failures is handled.
Part VIII
Question 1. Discuss each term: database authorization, access control, data encryption, privileged (system) account, database audits, and audit trail.
Question 2. Discuss the types of privilege. What is meant by revoking a privilege?