Wesklake_Research_Hospital_Group_Project_Template1.docx

WestLake Research hospital

Course: ISOL536 – Security Architecture and Design Dr. Charles DeSassure, Adjunct Professor

Graduate Computer Science Program

University of the Cumberlands

Type the Group Number Type the current date

Westlake Research Hospital Project using MS Access

Page 12 of 12

OVERVIEW

Provide that overview of the problem. You may include some information from the instructions. Provide information about some of the issues your group will address. Note: Delete all instructions before submitting your final report. Only one member needs to submit the final report.

ROLE AND RESPONSIBILITIES

Name/Role/Responsibilities

Member Picture

Type team member name

Role on this Project

Insert a quality head phot of yourself. Adjust the photo so it can appear professionally. All group members must be represented. Add additional rows if required, and delete empty rows. <Delete these instructions>

SYSTEM REQUIREMENTS (Tables)

Include the name of all table tables that will exist within your system. Provide a brief overview of each table, two or three lines will be fine. Include only the table information on this page. Use MS Access <Delete these instructions>.

No

Table Name

Purpose

SYSTEM REQUIREMENTS (Relationships)

Indicate which table will have relationships to what type and explain why <Delete these instructions>

No

Table Name

Which Field

Index Field/Key

SYSTEM REQUIREMENTS (Relationships)

Insert a screen capture of your relationship page from MS Access.

SYSTEM REQUIREMENTS (Reports)

Indicate the type of reports that will be generated by the system. Five different types of reports are required using MS Access. Provide the purpose of each report <Delete these instructions>

No

Report Name

Purpose

SECURE SYSTEM REQUIREMENTS

List FIVE requirement to help made this system secure? Funding is not an issue. Think outside of the box. <Delete these instructions>

No

Requirement

Purpose

1

2

3

4

5

MS ACCESS SYSTEM DESIGN – THREAT MODELING

Now that your team has the system design completed, a team member will need to create a Threat Modeling Design (drawing) of the system. Use only the symbols that we have used in this class. Embed the system design into this report on this page. <Delete these instructions>. MS ACCESS SYSTEM DESIGN

Now that your team has the system design and complete, a team member needs to create each TABLE, each RELATIONSHIP, and each REPORT within MS Access. Input five records within each table. <Delete these instructions>. Nothing should be on this page except the TITLE and the statement below.

MS Access file uploaded to Blackboard.

SYSTEM PROTECTION

<Using MS Access Protection/System>. Password protect the file.

Include a password for MS Access file on this page before uploading to the professor. Test and test the system to ensure that the password is working. If not, the professor will not be able to review the group MS Access file.

RECOMMENDATIONS

Provide THREE recommendations on how the group may enhance this system in the future.