Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

1. List the characteristics of monopolistic competition.

Answered: 1 week ago