IGNOU BCSL 091 SOLVED ASSIGNMENT

Ques 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.

Ques 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.

Ques 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.

Ques 4.

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.

Ques 5.

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.

Ques 6.

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.

Ques 7.

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.

Ques 8.

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.

Ques 9.

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.

Ques 10.

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.

Ques 11.

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.

Ques 12.

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.

• Latest IGNOU Solved Assignment
• IGNOU BCSL-091 2025 Solved Assignment
• IGNOU 2025 Solved Assignment
• IGNOU CMAD Certificate in Mobile Application Development 2025 Solved Assignment
• IGNOU BCSL-091 Programming using Python 2025 Solved Assignment

Looking for IGNOU BCSL-091 Solved Assignment 2025. You are on the Right Website. We provide Help book of Solved Assignment of CMAD BCSL-091 - Programming using Pythonof year 2025 of very low price.
If you want this Help Book of IGNOU BCSL-091 2025 Simply Call Us @ 9199852182 / 9852900088 or you can whatsApp Us @ 9199852182
 

IGNOU CMAD Assignments Jan - July 2025 - IGNOU University has uploaded its current session Assignment of the CMAD Programme for the session year 2025. Students of the CMAD Programme can now download Assignment questions from this page. Candidates have to compulsory download those assignments to get a permit of attending the Term End Exam of the IGNOU CMAD Programme.

Download a PDF soft copy of IGNOU BCSL-091 Programming using Python CMAD Latest Solved Assignment for Session January 2025 - December 2025 in English Language.

If you are searching out Ignou CMAD  BCSL-091 solved assignment? So this platform is the high-quality platform for Ignou CMAD  BCSL-091 solved assignment. Solved Assignment Soft Copy & Hard Copy. We will try to solve all the problems related to your Assignment. All the questions were answered as per the guidelines. The goal of IGNOU Solution is democratizing higher education by taking education to the doorsteps of the learners and providing access to high quality material. Get the solved assignment for BCSL-091 Programming using Python course offered by IGNOU for the year 2025.Are you a student of high IGNOU looking for high quality and accurate IGNOU BCSL-091 Solved Assignment 2025 English Medium? 

Students who are searching for IGNOU Certificate in Mobile Application Development (CMAD) Solved Assignments 2025 at low cost. We provide all Solved Assignments, Project reports for Masters & Bachelor students for IGNOU. Get better grades with our assignments! ensuring that our IGNOU Certificate in Mobile Application Development Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU CMAD Courses that you can download and look at. All assignments provided here have been solved.IGNOU BCSL-091 SOLVED ASSIGNMENT 2025. Title Name BCSL-091 English Solved Assignment 2025. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU CERTIFICATE PROGRAMMES Solved Assignment 2023-24 Session. IGNOU Solved Assignment and In this post, we will provide you with all solved assignments.

If you’ve arrived at this page, you’re looking for a free PDF download of the IGNOU CMAD Solved Assignment 2025. CMAD is for Certificate in Mobile Application Development.

IGNOU solved assignments are a set of questions or tasks that students must complete and submit to their respective study centers. The solved assignments are provided by IGNOU Academy and must be completed by the students themselves.