+61480015851
WISY104: Business Information Systems - Data Insertion - Database Application Assignment Help
Download Solution
Order New Solution
Internal Code: C_AI_DBBJ_BH
Table Name: PATIENT
Task: 2
DATA INSERTION
Populate the tables with values given below. Data is CASE-SENSITIVE.
DOCTOR TABLE:
TASK 3: RELATIONSHIP CREATION Create relationships among the FOUR tables such as DOCTOR, PATIENT, NURSE and CONSULTATION. Enforce referential integrity for each relationship created.
TASK 4: SIMPLE QUERIES
Task 4.1 Display all details of patients. Sort the result by patients’ name in descending order. Save the result as “Query1”.
Task 4.2 Display consultation details (CONSULTATIONID, PATIENTID and DOCTORID) booked in June, 2018. Save the result as “Query2”.
Task 4.3 Display doctors’ designation with their name if the doctor’s name has ‘AH’ somewhere in it. Do not show DOCTORID in answer. Sort the results by designation in ascending order. Save the result as “Query3”.
Task 4.4 Display all details of the registered nurses. Save the result as “Query4”.
Task 4.5 Display all details of consultations. Display consultation rooms ‘A’ and ‘C’ where the doctors ‘D1’ and ‘D2’ provided the consultation. Sort the result in ascending order by consultation fee. Save the result as “Query5”.
PATIENT NAME
PATIENT ADDRESS
PATIENT DOB
TASK 5: ADVANCED QUERIES
Note: For both advanced queries, use EXPRESSION BUILDER and rename any NEW fields with the appropriate field names. NO partial marks will be given if the EXPRESSION BUILDER is not used.
Task 5.1 Calculate and display the total income for the doctor with DOCTORID as ‘D2’ with the following doctor’s attributes such as DOCTORID, DOCTORNAME and DOCTORDESIGNATION. Save the result as “ADVANCED_Q”.
Task 5.2 Write an UPDATE query to increase the consultation fees of all doctors by 3%. Execute the query once to update the consultations fees. Save the result as “UPDATE_FEE_BY3”.
TASK 6: FORM CREATION
Database Application Assignment Help
Task: 1 TABLE CREATION Create the following TWO tables with the specified fields and general properties. Identify appropriate primary keys. Table Name: DOCTOR
Table Name: PATIENT
Task: 2
DATA INSERTION
Populate the tables with values given below. Data is CASE-SENSITIVE.
DOCTOR TABLE:
TASK 3: RELATIONSHIP CREATION Create relationships among the FOUR tables such as DOCTOR, PATIENT, NURSE and CONSULTATION. Enforce referential integrity for each relationship created.
TASK 4: SIMPLE QUERIES
Task 4.1 Display all details of patients. Sort the result by patients’ name in descending order. Save the result as “Query1”.
Task 4.2 Display consultation details (CONSULTATIONID, PATIENTID and DOCTORID) booked in June, 2018. Save the result as “Query2”.
Task 4.3 Display doctors’ designation with their name if the doctor’s name has ‘AH’ somewhere in it. Do not show DOCTORID in answer. Sort the results by designation in ascending order. Save the result as “Query3”.
Task 4.4 Display all details of the registered nurses. Save the result as “Query4”.
Task 4.5 Display all details of consultations. Display consultation rooms ‘A’ and ‘C’ where the doctors ‘D1’ and ‘D2’ provided the consultation. Sort the result in ascending order by consultation fee. Save the result as “Query5”.
PATIENT NAME
PATIENT ADDRESS
PATIENT DOB
TASK 5: ADVANCED QUERIES
Note: For both advanced queries, use EXPRESSION BUILDER and rename any NEW fields with the appropriate field names. NO partial marks will be given if the EXPRESSION BUILDER is not used.
Task 5.1 Calculate and display the total income for the doctor with DOCTORID as ‘D2’ with the following doctor’s attributes such as DOCTORID, DOCTORNAME and DOCTORDESIGNATION. Save the result as “ADVANCED_Q”.
Task 5.2 Write an UPDATE query to increase the consultation fees of all doctors by 3%. Execute the query once to update the consultations fees. Save the result as “UPDATE_FEE_BY3”.
TASK 6: FORM CREATION
- Using “Form Wizard”, create a form for PATIENT table.
- Select “Tabular” layout.
- You can use any colours and formatting you like, as well as any design elements.
- Lock the “PATIENTID” field.
- Save this form as “PATIENT”.
- Using “Report Wizard”, create a report for the fields: CONSULTATION ID, PATIENT NAME, DOCTOR NAME, CONSULTATION DATE, CONSULTATION ROOM and FEE.
- View must be based on “CONSULTATION” table.
- Group data by “DOCTOR NAME”.
- Sort data by “CONSULTATION ID” in descending order.
- Select “Block” layout and “Landscape” orientation.
- Save this report as “CONSULTATION SUMMARY REPORT”.
- Create a navigation form with “Horizontal Tab”.
- Set First Tab as “PATIENT” Form created in Task 6.
- Set Second Tab as “CONSULTATION SUMMARY REPORT” created in Task 7.
- Create a button to link to “Query3”.
- Save this form as “NAVIGATION FORM”.
This WISY104: Business Information Systems Assignment has been solved by our Database Application experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.