Question 1

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.

Accepted Answer

A Student Academic Records Management System (SARMS) is a crucial application within educational institutions for efficiently managing student data, course information, enrollment details, and academic performance. Utilizing a relational Database Management System (DBMS) provides a structured, consistent, and secure way to store, retrieve, and manipulate this vital information. This design and implementation will demonstrate fundamental DBMS concepts as outlined in BCSL-034, including table crea

Question 2

Create Database Schema:

Accepted Answer

Creating a database schema is a fundamental step in designing a relational database management system (RDBMS). It involves defining the structure of tables, including column names, their respective data types, and various integrity constraints. This process, as taught in the BCSL-034 DBMS Lab course, ensures data accuracy, consistency, and the establishment of logical relationships between different entities within the database. The SQL `CREATE TABLE` statement is the primary command used for th

Question 3

Relationships: A student can enroll in multiple courses. A course can have multiple students. Draw an ER-diagram for the system.

Accepted Answer

Creating a database schema is a fundamental step in designing a relational database management system (RDBMS). It involves defining the structure of tables, including column names, their respective data types, and various integrity constraints. This process, as taught in the BCSL-034 DBMS Lab course, ensures data accuracy, consistency, and the establishment of logical relationships between different entities within the database. The SQL `CREATE TABLE` statement is the primary command used for th

Question 4

Perform the following CRUD operations on your database: Insert new records into all tables. Read/display records from each table. Update existing records (e.g., grade, contact details). Delete a student or a course entry.

Accepted Answer

Creating a database schema is a fundamental step in designing a relational database management system (RDBMS). It involves defining the structure of tables, including column names, their respective data types, and various integrity constraints. This process, as taught in the BCSL-034 DBMS Lab course, ensures data accuracy, consistency, and the establishment of logical relationships between different entities within the database. The SQL `CREATE TABLE` statement is the primary command used for th

Question 5

Write and execute the following SQL queries:

Accepted Answer

Creating a database schema is a fundamental step in designing a relational database management system (RDBMS). It involves defining the structure of tables, including column names, their respective data types, and various integrity constraints. This process, as taught in the BCSL-034 DBMS Lab course, ensures data accuracy, consistency, and the establishment of logical relationships between different entities within the database. The SQL `CREATE TABLE` statement is the primary command used for th

BCSL-034 Solved Assignment — January 2026 / July 2025

DBMS Lab | IGNOU Bachelor of Computer Applications (BCA)

BCSL-034—January 2026 / July 2025

DBMS Lab

Questions & Answers

Download Study Materials

Related Courses

BCSL-034 Assignment Questions — January 2026

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

QQ1. Create Database Schema:

QQ1. Relationships: A student can enroll in multiple courses. A course can have multiple students. Draw an ER-diagram for the system.

QQ1. Perform the following CRUD operations on your database: Insert new records into all tables. Read/display records from each table. Update existing records (e.g., grade, contact details). Delete a student or a course entry.

QQ1. Write and execute the following SQL queries: