IGNOU CMAD BCSL 91 Laboratory Course (Introduction to Databases, Introduction to Android, and Programming using Python) Solved Assignment ENGLISH

Please make sure your assignment questions match your current IGNOU session

BCSL 091 (January 2026 - July 2026) - ENGLISH

Course Code : BCSL-091
Course Title : Laboratory Course
Assignment Number : CMAD/L-091/Assignment/2026
Maximum Marks : 25
Last Date of Submission : 30th April, 2026 (for January session)
 31st October 2026 (for July session)

This Assignment carries questions from the course BCS-092 for 5 marks, and from the course BCS-093 and BCS-094 for 10 marks each, respectively. In all the questions given in this assignment which carries 25 marks. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Include the screen layouts also along with your assignment responses.

Section-1: Database portion of Lab (BCS-092)

Question1: (2+3 Marks)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.

b) 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.

 

Section-2: Introduction to Android (BCS-093)
 Question 2: Develop an ADDRESS BOOK mobile app. It enables you to store addresses as well as list
all of them. Make assumptions, wherever necessary (10 Marks)

Section-3: Programming using Python (BCS-094)

Question 3: 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.

(Note: Make suitable assumptions where ever necessary)

BCSL 091 (January 2025 - July 2025) - ENGLISH

Course Code : BCSL-091

Course Title : Programming using Python

Assignment Number : CMAD/L-094/Assignment/2025

Maximum Marks : 25

Last Dates for Submission : 30th April, 2025 (for January session)

30th October, 2025 (for July session)

This Assignment carries practical questions from the course BCS-092 for 5 marks, and from the courses BCS-093 and BCS-094 for 10 marks each, respectively. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Include the screen layouts also along with your assignment responses wherever necessary

Section-1: Database portion of Lab

Question 1:

Consider the following relational schema:

Employee (Eid, Ename, DeptCode, DateofAppointment) Eid is the employeeID, which is a unique identifier assigned by the Organisation when the employee joins (Primary Key), Ename is the employee name, DeptCode identifies the department of the employee (Foreign Key), DateofAppointment is the date when the employee joined the organisation.

Department (DeptCode, DeptName, DeptLocation)- DeptCode is the code allotted to a department and is the Primary Key, DeptName is the department's name, and DeptLocation is the city where the department office is located.

(a) Create the tables using SQL from the schema above; you must include the primary key, foreign keys and constraints in your implementation. Enter a few sets of meaningful data in each table.

(b) Write and run SQL statements for the following queries:

(i) List the name of the employees appointed before 1 January 2024.

(ii) List the name of all the departments located in "Delhi".

(iii) Find the name of all the employees and the name of the department in which he/she works.

(iv) List the employee ID of all those employees who work in Delhi.

(v) Find the total number of employees in each department.

(vi) Find the total number of departments.

Note: Make suitable assumptions, if any

Section-2: Introduction to Android (BCS-093)

Question 2:

Develop a QUIZ mobile app. The App should display questions one after another with multiple options (each option is possible answer). You need to select the correct option. After 10 questions, it will display the correct score. Make assumptions, wherever necessary.

Section-3: Programming using Python (BCS-094)

Question 3:

Develop a GUIll (details given below) by Using wxPythonandTkinter, compare the code complexity of both and give your observations.

Use suitable components like text box, combo box, list, Radio Button, Check Box, Buttons, etc. to develop the GUI

Details of GUI: the GUI should accept the personal details of an Employee like Employee Name, DOB, Residential Address, Email, Mobile, Blood Group (A+, B+, O+, A-, B-, O-, etc.), Nature of Job (Permanent, Temporary, contractual, daily wage etc.), Diabetic (Yes, NO), Health Summary etc.

Make suitable assumptions wherever necessary

Q: How will I receive the PDF?
A: Immediately after payment, the download link will appear.

Q: Is this hand-written or typed?
A: This is a professional typed computer PDF. You can use it as a reference for your handwritten submission.