IGNOU BCSL 34 SOLVED ASSIGNMENT

Included:

BCSL 34 2025 2026 - English

Course Code : BCSL-034

Title : DBMS Lab

Assignment Number :  BCA(III)/L-034/Assignment/2025-26

Maximum Marks :  50

Weightage : 25%

Last Date of Submission : 31st October, 2025(for July Session) 30th April, 2026(for January Session)

This assignment has only one question. Answer the question. This question carries 40 marks. Rest 10 marks are for viva voce. You may use illustrations and diagrams to enhance the explanation. Assumptions can be made wherever required. Please go through the guidelines regarding the assignments given in the programme guide for the format of presentation.

Q1. Design and implement a database system using any relational DBMS for a Student Academic Records Management System, demonstrating fundamental DBMS concepts such as table creation, relationships, CRUD operations, and SQL queries for data manipulation and retrieval.

Create Database Schema:

Create the following tables:

Students Table

• student_id (Primary Key, INT, Auto Increment)
• first_name (VARCHAR)
• last_name (VARCHAR)
• date_of_birth (DATE)
• email (VARCHAR, Unique)
• phone (VARCHAR)

Courses Table

• course_id (Primary Key, INT, Auto Increment)
• course_name (VARCHAR)
• credits (INT)
• semester (VARCHAR)

Enrollment Table

• enrollment_id (Primary Key, INT, Auto Increment)
• student_id (Foreign Key, INT)
• course_id (Foreign Key, INT)
• enrollment_date (DATE)
• grade(VARCHAR)

Relationships:

• A student can enroll in multiple courses.
• A course can have multiple students.

Draw an ER-diagram for the system.

Perform the following CRUD operations on your database:

• Insert new records into all tables.
• Read/display records from cach table.
• Update existing records (e.g., grade, contact details).
• Delete a student or a course entry.

SQL Queries

Write and execute the following SQL queries:

1. List all students with their enrollment details.

2. Retrieve all courses in which a specific student is enrolled.

3. Calculate the number of students enrolled in each course.

4. Find students who have secured grade 'A' in any course.

5. Retrieve the average grade (as alphabet, assuming A-4, B=3...) per course.

6. List all students who have not enrolled in any course.

7. Find courses that have the highest number of enrollments.

8. Retrieve student details sorted by last name.

9. Find all courses offered in a specific semester.

10. Retrieve total number of courses each student has enrolled in.

11. Display enrollment count per semester.

12. List students along with the number of courses they failed (assume F as fail).

13. Find the student who has scored the most A grades.

14. Display all students born before the year 2000.

15. Retrieve course-wise average grade for all enrolled students.

Documentation Checklist:

• Screenshot of table designs and data entry
• SQL query outputs (screenshots or printed result)
• ER-diagram (drawn using any tool or by hand)
• Short explanation of each query
• Summary of observations and learning

Note: You must perform the above said activities and also take prints of screenshots of the layouts, sample input and output along with the necessary documentation for this practical question. Assumptions can be made 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.

Details

• Latest IGNOU Solved Assignment
• IGNOU BCSL 34 2025 2026 Solved Assignment
• IGNOU 2025 2026 Solved Assignment
• IGNOU BCA Bachelor of Computer Applications 2025 2026 Solved Assignment
• IGNOU BCSL 34 DBMS Lab 2025 2026 Solved Assignment

Looking for IGNOU BCSL 34 Solved Assignment 2025 2026. You are on the Right Website. We provide Help book of Solved Assignment of BCA BCSL 34 - DBMS Labof year 2025 2026 of very low price.
If you want this Help Book of IGNOU BCSL 34 2025 2026 Simply Call Us @ 9199852182 / 9852900088 or you can whatsApp Us @ 9199852182
 

IGNOU BCA Assignments Jan - July 2026 - IGNOU University has uploaded its current session Assignment of the BCA Programme for the session year 2025 2026. Students of the BCA 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 BCA Programme.

Download a PDF soft copy of IGNOU BCSL 34 DBMS Lab BCA Latest Solved Assignment for Session January 2026 - December 2026 in English Language.

If you are searching out Ignou BCA  BCSL 34 solved assignment? So this platform is the high-quality platform for Ignou BCA  BCSL 34 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 34 DBMS Lab course offered by IGNOU for the year 2025 2026.Are you a student of high IGNOU looking for high quality and accurate IGNOU BCSL 34 Solved Assignment 2025 2026 English Medium? 

Students who are searching for IGNOU Bachelor of Computer Applications (BCA) Solved Assignments 2025 2026 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 Bachelor of Computer Applications Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU BCA Courses that you can download and look at. All assignments provided here have been solved.IGNOU BCSL 34 SOLVED ASSIGNMENT 2025 2026. Title Name BCSL 34 English Solved Assignment 2025 2026. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU  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 BCA Solved Assignment 2025 2026. BCA is for Bachelor of Computer Applications.

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.

Course Name	Bachelor of Computer Applications
Course Code	BCA
Programm	Courses
Language	English

 

 

 

IGNOU BCSL 34 Solved Assignment	ignou assignment 2025 2026,   2025 2026 BCSL 34
IGNOU BCSL 34 Assignment	ignou solved assignment BCSL 34
BCSL 34 Assignment 2025 2026	solved assignment BCSL 34
BCSL 34 Assignment 2025 2026	assignment of ignou BCSL 34
Download IGNOU BCSL 34 Solved Assignment 2025 2026	ignou assignments BCSL 34
Ignou result BCSL 34	Ignou Assignment Solution BCSL 34