You will need to determine which approaches you will use in each given database security scenario, and then compare the different approaches against one another. Layers / Approaches (See Database Security lecture for more details) to utilize in this assignment: -Access Control -Integrity Controls -Auditing -Backups - Authentication -Application Security -Encryption.

Scenario 1 Company name: Walsh Healthcare Company profile: Walsh Healthcare provides healthcare insurance to residents of the state of Michigan. Walsh Healthcare is based in Troy, Michigan. Walsh Healthcare has 1000 employees that are spread across multiple disciplines – sales; marketing; human resources; underwriting; accounting; logistics; and information technology. Scenario details: Mary Walsh is the Chief Information Officer (CIO). She is concerned with securing customer information according to HIPAA (Health Insurance Portability and Accountability Act of 1996) legislation. Walsh wants to ensure compliance to the HIPAA legislation rules. Walsh needs to identify the database security tools that will help her to attain compliance with HIPAA. 

Assignment Steps 1) Pick 3 of the layers / approaches (listed above) that you will use for this scenario. List these out. 

2) Explain how each of the three layers/approaches will individually be utilized to resolve the HIPAA compliance issue. (1 paragraph each) 

3) Compare the three layers/approaches against each other and explain how they will be able to help resolve the HIPAA compliance issue with respect to database security in protecting the data, database management system (DBMS) against possible attacks from hackers (3 paragraphs).

Scenario 2 Company name: Walsh College Company profile: Walsh College provides bachelors and master’s degree programs. Walsh College is based in Troy, Michigan. Walsh Healthcare has 250 employees that are spread across multiple disciplines – advising; accounting; marketing; academic departments; online learning; and information technology. Scenario details: Juan Gabriel is the Chief Information Officer (CIO). He is concerned with securing student information according to FERPA (Family Educational Rights and Privacy Act) legislation. Gabriel wants to ensure compliance to the FERPA legislation rules. Gabriel needs to identify the database security tools that will help him to attain compliance with FERPA. 

Assignment Steps 

1) Pick 3 of the layers / approaches (listed above) that you will use for this scenario. List these out. [these layers must differ from previous choices] 

2) Explain how each of the three layers / approaches will individually be utilized to resolve the FERPA compliance issue. (1 paragraph each) 

3) Compare the three layers/approaches against each other and explain how they will be able to help resolve the FERPA compliance issue with respect to database security in protecting the data, database management system (DBMS) against possible attacks from hackers (3 paragraphs).