Write and execute SQL statements for the following queries:
i) List the names of doctors who joined before January 1st, 2026.
ii) List the names of all patients in alphabetical order.
iii)Find the name of every patient along with the name of their assigned doctor.
iv)List the ID of all doctors who have been assigned to more than five patients.
v) Find the total number of patients assigned to each doctor.
vi) Find the total number of doctors in the hospital.
Note: Make suitable assumptions, if any.
____ ________ _________ ______ _________ ___ __________ _________ ___ _____.
_____ ___ ________ __________ ____ _________ ________ ________.
_______ __________ ____ _____ _______ ___ ____ _________ ____ ________ _________.
____ _______ ________ ________ ____ ____ _____ ____ ___.
_____ ______ _____ __________ _____ _______ ___ _______ ___ ___ ____ ________.
____ __________ _______ _____ ___ _______ ____ _________ _______ ________ ________.
____ __________ ____ ______ ___ ____.
____ ________ _______ __________ ______ _________ _________ ________ ________ _________.
_______ ________ ________ ____ _________ ________ __________ ______.
__________ _____ ______ _____ _________.
______ ________ _______ _____ ___ __________ __________ __________ _______ _________ ______.
_________ _________ ______ _____ _____ __________ ____.
__________ _____ ____ ____ _________ _________ _________ __________.
_______ _____ ____ ________ _____ _________ _____ __________.
___ _______ _____ ______ _______ _________ ____ ___ _____.
____ ___ _________ _______ ____ _____ _________ ____ _____.
________ ___ ______ _____ __________.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required
Write and execute SQL statements for the following queries:
i) List the names of doctors who joined before January 1st, 2026.
ii) List the names of all patients in alphabetical order.
iii)Find the name of every patient along with the name of their assigned doctor.
iv)List the ID of all doctors who have been assigned to more than five patients.
v) Find the total number of patients assigned to each doctor.
vi) Find the total number of doctors in the hospital.
Note: Make suitable assumptions, if any.
Develop a GUI (details given below)by Using Tkinter and wxPython, compare the code complexity of both and give your observation. (10 Marks)
Details of GUI : the GUI for Truth table should accept two bits (0 or 1) as input and produce the Output as per the Logical operation to be chosen by pressing the button of that particular logical operation i.e. AND, OR, NOT,NAND, NOR, XOR. You may use other suitable components like text box, combo box, list, Radio Button, Check Box, Buttons etc. to implement the GUI.
Consider the following Relational Schema for a Hospital:
- Doctor (ID, DoctorName, Speciality, JoinDate)
Where ID is the unique identifier for the doctor (Primary Key), and Speciality indicates the doctor's area of expertise.
- Patient (PID, PatientName, Phone, ID)
Where PID is the unique identifier for the patient (Primary Key), and ID links the patient to their primary care doctor (Foreign Key).
a) Write the SQL statements to create these tables. You must include definitions for Primary Keys, Foreign Keys, and necessary constraints. Insert a few rows of meaningful data into each table.
Develop an ADDRESS BOOK mobile app. It enables you to store addresses as well as list all of them. Make assumptions, wherever necessary