HealthyMe Medical Centre requested Miss Mimi to design a database system for its internal audit system. The internal audit system will be used by the internal auditors when performing the audit tasks and by management to monitor the results of internal audit for each department in HealthyMe Medical Centre. Below are details features given by Mrs. Nonie, the internal audit manager of HealthyMe Medical Centre.

• Each internal auditor will perform the audit tasks.
• The internal auditors can fill in the details of each audit tasks when performing the tasks.
• The system must calculate the audit marks of each department at the end of the audit tasks.
• An auditor assigned to the department only can prepare the department’s audit report.
• The system must report the tasks completed, the completed date when each task, who have been assigned to each task, and the results for each department audited.
• Only the senior management can view the audit report of each department.

REQUIRED:

1. Identify TWO (2) attributes (other than ID) for each of any FOUR (4) entities involved for the development of the internal audit system.

2. Draw an entity relationship (ER) diagram for the proposed internal audit system, which include:

(i) entities

(ii) relationships

(iii) cardinalities

3. Design an interface for any internal audit task that needs to be filled by internal auditor when performing the audit tasks. The form must consist of ONE (1) form header, FOUR (4) labels and text box, ONE (1) combo box, and FOUR (4) command buttons. (You may use any digital application platform to design the interface).

Answer rating: 100% (QA)

1 heres a response addressing Certainly Attributes for Entities Entity Internal Auditor Name ... View the full answer