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.
__________ ____ ___ ___ ____ _________ _____ _________ _______ ______ ________.
_____ ___ _____ ___ __________ ______ _____ ______ ______ ______ __________.
___ ______ ___ _______ ___ ____ __________.
_______ ____ ___ _____ _________ ______ ______ ___ ______ ____ _________ ___.
________ ___ ________ ____ _____ ____ ___ _____ ___ ___.
__________ _______ _______ _______ ______ ____ ___ ______ ______ ______ __________.
___ ______ _______ _________ ______ _______ _______ _________ ___ ________ _____.
_______ ______ ______ ____ ___ ____ _______ ___ __________ __________ __________ _______.
______ ______ ________ ____ __________ ________ ________ __________ ______ ____.
_____ _______ _________ __________ ______ _____ _____.
____ ______ ____ ____ _____ _________ __________ _______.
____ ______ ________ ____ __________ ___ ________ _______ ___ ________.
___ ___ _____ __________ _________ __________ ___ ____ _______ _____.
_________ _______ _______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required
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.
Develop an ADDRESS BOOK mobile app. It enables you to store addresses as well as list all of them. Make assumptions, wherever necessary
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.
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.