Problem
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.