Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A hospital has a database system to page physicians. The CIO of the hospital noticed that there has been a series of inexplicable, suspicious activities
A hospital has a database system to page physicians. The CIO of the hospital noticed that there has been a series of inexplicable, suspicious activities on the application and production databases. The CIO wants to know who accessed those databases, who modified data, and who changed the data structure. The CIO also want have an audit trail for all those activities but he isn't interested in a historical data change trail. As a database consultant, you are hired to design and implement a DBMS to meet the CIO's requirement. Phase 1 The application database schema is attached as bellows. Alert Schedule PK Alert n First Name Last Name Moble Number Pager Alert Times Alert Status Alter Count Response FK1 Physician ID A senior database expert designed an auditing model for this case and kindly shares it with you. App_Audit_User PK UserID App Audit tables PK IableID Table Name User name App Audit_Action FK1 Table ID FK2 User ID FK3 Action Type ID Aud Start Date Aud_Expiration_Date HO- Aud Ins DTTM Aud_Upd_DTTM Aud_Upd_User App Audit_Data PK | Audit Data App_Audit_Action_Type PK Action ypeID Aud Ins DTTM Aud_Upd_DTTM App Upd_User FK1 Audit Action ID Action_Type Desc Note: 1) You are NOT required to strictly follow this model. You may modify it or create your own auditing model. You are fine as long as your solution satisfies the user requirement. 2). App Audit tables - stores the tables information to be audited. 3). App_Audit User - stores the user information to be audited
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started