1. What does the acronym SDLC mean, and what does an SDLC portray? a. Discuss the distinction between top-down and bottom-up approaches in database design. 2. What factors are important in a DBMS software selection? a. What three levels of backup may be used in database recovery management? Briefly describe what each of those three backup levels does. 3. Explain the difference between a distributed database and distributed processing. a. Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist for the technical and other aspects involved in the selection process. 4. List the main types of threat that could affect a database system, and for each describe the controls that you would use to counteract each of them. a. Explain the following in terms of providing security for a database: (b) access controls; - giying a selgetive access foger person in a (d) backup and recovery; To koep a copy of data of an eliflerent 5. How would you identify entity and relationship topes from a u specification? a. Discuss why you would want to validate a conceptual data model and describe two approaches to validating a conceptual model. 6. Describe how the following data mining operations are applied and provide typical examples for each: (a) predictive modeling, (b) database segmentation, (c) link analysis, (d) deviation detection. 7. Describe the approaches for securing DBMSs on the a. Identify the benefits of using replication in a dis ted system 1. What does the acronym SDLC mean, and what does an SDLC portray? a. Discuss the distinction between top-down and bottom-up approaches in database design. 2. What factors are important in a DBMS software selection? a. What three levels of backup may be used in database recovery management? Briefly describe what each of those three backup levels does. 3. Explain the difference between a distributed database and distributed processing. a. Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist for the technical and other aspects involved in the selection process. 4. List the main types of threat that could affect a database system, and for each describe the controls that you would use to counteract each of them. a. Explain the following in terms of providing security for a database: (b) access controls; - giying a selgetive access foger person in a (d) backup and recovery; To koep a copy of data of an eliflerent 5. How would you identify entity and relationship topes from a u specification? a. Discuss why you would want to validate a conceptual data model and describe two approaches to validating a conceptual model. 6. Describe how the following data mining operations are applied and provide typical examples for each: (a) predictive modeling, (b) database segmentation, (c) link analysis, (d) deviation detection. 7. Describe the approaches for securing DBMSs on the a. Identify the benefits of using replication in a dis ted system
