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.
The relational schema can be implemented using SQL by defining the Doctor table first, followed by the Patient table with proper key constraints to maintain referential integrity. The Doctor table includes a primary ______ ___ _______ _______ ___ _____ _______ _______ _______.
______ ____ _______ _____ ____ ______ _______ _____ __________.
___ ________ ________ _________ ___ _______ _________ ______ ____ ____ __________ ____.
_____ ____ ______ _______ _______ __________ ___.
________ ________ ________ ___ _______ _________.
____ _______ ______ _________ _____ _______ ___ ____ ____ ____ ___.
___ __________ ________ _______ ____ ___ _______ ________.
__________ _________ __________ _______ ____ ________ ________.
____ _________ ___ __________ _____ _____.
_______ ________ ______ _____ ____ _______ _____ _____ ______ _________.
___ ____ ___ __________ _______ ________.
________ __________ __________ _____ _______ _______ _______ _______ ________ _________.
________ _________ __________ ______ ________ __________ _________ ______ ____ _______ _____ _________.
_____ ____ _______ ________ _______ ____ ______ _____.
____ ______ ____ ____ __________ __________ _______.
________ ____ _____ ___ ____ _______.
________ _______ ________ _________ ___ _______ _____ ______ ________ _____ _____.
_______ ____ _________ _________ _______ _______ __________ _______.
__________ __________ _____ _________ _______ ___ ________.
___ ______ ____ __________ _________ _______ __________ ___.
Get Full Answer on WhatsApp
Develop an ADDRESS BOOK mobile app. It enables you to store addresses as well as list all of them. Make assumptions, wherever necessary
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.
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 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.