Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Coursework Details: 1. In this assignment, you are required to design, implement, and document a database system for the KPJ Hospital Management System. 2. Create the following queries using Data Manipulation Language (DML) - Each student must be able to explain the queries and justify the approach taken. Student 1 List the details of nurses allocated at orthopedic ward. Identify the total number of nurses and the sum of their salaries. 1. 2. 3. List the details of patients whose stays at the hospital has exceeded the expected duration of stays at the ward, ordered by patient's name. Student 2 1. List the details of patients that were referred to the out-patient clinic. 2. List the number of currently available beds that are allocated in the neurology ward. List the next-of-kin's details of all patients whose marital status is single, ordered by patient's name 3. Student 3 1. List the details of patients that were allocated at the cardiology ward. 2. Identify the total number patients allocated at each ward, categorised by gender. 3. List the total number of patients who had an appointment with Dr Helen Cho. Student 4 1. List the name of each Head Nurse at each ward, ordered by ward name. 2. List the details of patients currently located in the respiratory ward. 3. List the details of patients in the dialysis ward whose stays at the hospital has not exceeded the expected duration of stays at the ward.

Coursework Details: 1. In this assignment, you are required to design, implement, and document a database system for the KPJ Hospital Management System. 2. Create the following queries using Data Manipulation Language (DML) - Each student must be able to explain the queries and justify the approach taken. Student 1 List the details of nurses allocated at orthopedic ward. Identify the total number of nurses and the sum of their salaries. 1. 2. 3. List the details of patients whose stays at the hospital has exceeded the expected duration of stays at the ward, ordered by patient's name. Student 2 1. List the details of patients that were referred to the out-patient clinic. 2. List the number of currently available beds that are allocated in the neurology ward. List the next-of-kin's details of all patients whose marital status is single, ordered by patient's name 3. Student 3 1. List the details of patients that were allocated at the cardiology ward. 2. Identify the total number patients allocated at each ward, categorised by gender. 3. List the total number of patients who had an appointment with Dr Helen Cho. Student 4 1. List the name of each Head Nurse at each ward, ordered by ward name. 2. List the details of patients currently located in the respiratory ward. 3. List the details of patients in the dialysis ward whose stays at the hospital has not exceeded the expected duration of stays at the ward.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Y3

Coursework Details: 1. In this assignment, you are required to design, implement, and document a database system for the KPJ Hospital Management System. 2. Create the following queries using Data Manipulation Language (DML)- Each student must be able to explain the queries and justify the approach taken. Student 1 List the details of nurses allocated at orthopedic ward. Identify the total number of nurses and the sum of their salaries. List the details of patients whose stays at the hospital has exceeded the expected duration of stays at the ward, ordered by patient's name. 1. 2. 3. Student 2 List the details of patients that were referred to the out-patient clinic. List the number of currently available beds that are allocated in the neurology ward. List the next-of-kin's details of all patients whose marital status is single, ordered by patient's name 1. 2. 3. Student 3 1. List the details of patients that were allocated at the cardiology ward. 2. Identify the total number patients allocated at each ward, categorised by gender. 3. List the total number of patients who had an appointment with Dr Helen Cho. Student 4 1. List the name of each Head Nurse at each ward, ordered by ward name. 2. List the details of patients currently located in the respiratory ward. 3. List the details of patients in the dialysis ward whose stays at the hospital has not exceeded the expected duration of stays at the ward.
Transcribed Image Text:Coursework Details: 1. In this assignment, you are required to design, implement, and document a database system for the KPJ Hospital Management System. 2. Create the following queries using Data Manipulation Language (DML)- Each student must be able to explain the queries and justify the approach taken. Student 1 List the details of nurses allocated at orthopedic ward. Identify the total number of nurses and the sum of their salaries. List the details of patients whose stays at the hospital has exceeded the expected duration of stays at the ward, ordered by patient's name. 1. 2. 3. Student 2 List the details of patients that were referred to the out-patient clinic. List the number of currently available beds that are allocated in the neurology ward. List the next-of-kin's details of all patients whose marital status is single, ordered by patient's name 1. 2. 3. Student 3 1. List the details of patients that were allocated at the cardiology ward. 2. Identify the total number patients allocated at each ward, categorised by gender. 3. List the total number of patients who had an appointment with Dr Helen Cho. Student 4 1. List the name of each Head Nurse at each ward, ordered by ward name. 2. List the details of patients currently located in the respiratory ward. 3. List the details of patients in the dialysis ward whose stays at the hospital has not exceeded the expected duration of stays at the ward.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS