Part 1: Design Documentation and DatabasesAnalyze the linkages between and among the information technology components and entities, and create an REA data model for the ACME Health Center....

Part 1: Design Documentation and Databases

Analyze the linkages between and among the information technology components and entities, and create an REA data model for the ACME Health Center. Identify:

• R: Resources the organization acquires and uses that have economic value to the organization.


• E: Events (business activities) in which the organization engages about which management wants to collect information.


• A: Agents, the people and organizations that participate in the events.

Task:

• Draw an E-R diagram to describe the patient invoice and payment process.


• Describe the details of your diagram with a narrative.

Part 2: Database

Last week, you created some initial tables in your ACME Health Center database. The PatientList table will allow you to track key patient information, and will make adding, deleting, displaying, or changing patient information easy and efficient. This table needs a primary key that will uniquely identify each row in the table. You cannot use a patient’s name as the primary key because some patients may have the same name. Therefore, each record in the table needs a unique patient number to identify each patient.

After the PatientList table is set up, the Form Wizard in Microsoft Access can be used to create a form that enables the user to easily enter new patient information or modify existing patient information. After the Form Wizard creates the form, you may go to the Design view to make modifications. For example, you can right-click on a form text box and change it to a combo box. Then, right-click on the combo box, select Properties, and change the RowSourceType property to Value List. Clicking on the RowSource property allows you to enter a list of values for the combo box.

Another important feature that you can add to your forms or tables is the Validation Rule property, which provides a useful internal control feature. In the Design view for a form, right-clicking on a field and selecting properties reveals the list of options for that field. Under the Data tab, you will see the Validation Rule option.

Tasks:

This week, complete the following tasks:

1. In your ACME Health Center database, you will use the Form Wizard in Microsoft Access to create forms for your various tables (select the Create tab and then click More Forms).

1. Create a Patient form using thePatientListtable and the Form Wizard.


2. Make a form for theProcedureListtable.In the ProcedureList form, modify the Operating Room Type, Device Level, and Anesthesia Level boxes to be combo boxes with integer ranges of 1 to 3, 1 to 4, and 1 to 4, respectively. (See this week’s lecture for instructions.) Use the Validation Rule property to prevent the user from entering invalid values in these boxes.


3. Create a form for theMedicalDevicestable.

2. Using the Patient form you created in part 1, enter your details into the database as a patient. Explain what controls and checks would be needed for the Patient form to ensure accurate and reliable data in the database.


3. The managers of ACME Health Center want to use past data to assign a price to a procedure. Therefore, complete the following tasks using ProcedureList.xls:

1. Add an additional column for calculating the cost of a procedure using the following formula:

Cost = $200 × OperatingRoomType + $10 × PreOpMinutes + $50 × ProcedureMinutes + $20 × PostOpMinutes + $50 × Number of Nurses +$80 × DeviceLevel + $90 × Anesthesia level

1. Also, add a markup of 40 percent to the cost of a procedure. In other words, the cost of a procedure would be as follows:


2. Cost = Cost + Cost × .40

Note: Do not add a column for the cost of a procedure to the ProcedureList table in your database.

Submission Guidelines:


Part 1

• Your supplemental materials for this week include


• Create the drawing and narrative in a 2- to 3-page Microsoft Word document.