IGNOU BCSL 91 SOLVED ASSIGNMENT

Included:

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 and be sent to your email.

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.