SA-21/06, C-11, Asapur, Varanasi, UP support@kamaldnp.com +91 8318013442
BTEUP Syllabus

Database Management System (Lab) — BTEUP Information Technology 3rd Semester Syllabus 2026-27

KAMALDNP Raj Kamal
November 18, 2026
9 Min Read
Database Management System (Lab) — BTEUP Information Technology 3rd Semester Syllabus 2026-27

Database Management System (Lab) — What This Subject Is About

Six experiments and four case studies — that is the whole lab, and the case studies are the point of it. Database Management System (Lab) is the practical companion to DBMS (subject 3.2): you install a database, design an ER model, build tables, and then run real SQL on four scenarios — a library, an employee database, a bookstore and student grades. There is no theory paper: your marks come from practical work, 60 internal and 40 external.

The lab has 4 practical periods a week and 2 credits. The first six experiments teach the skills one at a time — installation, ER modelling, creating tables, handling records, retrieving data — and the four case studies combine those skills on a bigger scenario. The lab only makes sense alongside the theory: read the unit first, then practise it in SQL.

Subject 3.6 (Practical) • Total 100 Marks • 2 Credits • L 0 – P 4 • 3rd Semester — Information Technology • Session 2026–27

DBMS Lab syllabus — 6 experiments and 4 SQL case studies, BTEUP IT 3rd semester 2026-27
Real databases, real queries — in the DBMS Lab you build tables and answer questions with SQL.

What You Will Do

List of Experiments — 6 Experiments

S.No.Name of Experiment
1Install and configure a database system (MySQL through XAMPP Server, MySQL, PostgreSQL, or SQLite).
2Design an ER Model for a Library Management System.
3Study of the different properties present in an ER Model.
4Creating Database: creating a database; creating a table; specifying relational data types; specifying constraints; creating indexes.
5Table and Record Handling: INSERT statement; using SELECT and INSERT together; DELETE, UPDATE, TRUNCATE statements; DROP, ALTER statements.
6Retrieving Data From a Database — the SELECT statement: using the WHERE clause; using logical operators in the WHERE clause; using IN, BETWEEN, LIKE, ORDER BY, GROUP BY and HAVING clauses; using aggregate functions; combining tables using JOINS.

Case Studies — 4 Case Studies

Case Study 1: SQL — Library Management System

Scenario: An institute manages a library with columns BookID, Title, Author_Name, Year_of_publication, Publisher_name, Subject, MemberID (you may add other fields also).

Tasks: (1) Retrieve the names of all books with a specific author “A”. (2) Retrieve the names of books of a particular subject “X”. (3) Decrease the book count by 1 from the table for BookID = “101”. (4) Add a new member in the database.

Case Study 2: SQL — Employee Database

Scenario: An organization maintains an employee database with columns EmployeeID, FirstName, LastName, Department, Salary, JoiningDate.

Tasks: (1) Retrieve the names of all employees in the “Sales” department. (2) Find all employees who joined after January 1, 2020. (3) Update the salary of employee EmployeeID = 102 by 10%. (4) Delete an employee record where EmployeeID = 105.

Case Study 3: SQL — Bookstore Inventory

Scenario: A bookstore stores information about books in columns BookID, Title, Author, Price, Genre, StockCount.

Tasks: (1) List all books in the “Science Fiction” genre. (2) Find all books priced greater than 200. (3) Increase stock count by 5 for all books authored by “John Doe”. (4) Remove a book from inventory with BookID = 201.

Case Study 4: SQL — Student Grades Database

Scenario: A school database stores students' grades with columns StudentID, FirstName, LastName, Subject, Grade.

Tasks: (1) Retrieve the names of all students with an “A” grade in the subject “Math”. (2) Find the average grade of all students in the “English” subject. (3) Update the grade for StudentID = 103 in “History” to “B+”. (4) Delete all records for students who have failed in “Science” (Grade: “F”).

Complete Syllabus

The full examination scheme, the course outcomes and the reference books from the official syllabus. The experiments are in the “What You Will Do” section above.

Examination Scheme

CodePaperTypeL – PCreditsInternalExternalTotal
3.6Database Management System (Lab)Practical0 – 42Practical 60Practical 40 (3 hrs)100
Database Management System (Lab) Total26040100

Course Outcomes

  • CO1: Installation of database system.
  • CO2: Creating an database.
  • CO3: Record handling in a database.
  • CO4: Retrieving data from a database.
  • CO5: Handle various operations of a database through case studies.

Reference Books

The official syllabus lists no reference books for this laboratory. Use the reference books of the matching theory subject, Database Management System (subject 3.2).

How to Prepare for Database Management System (Lab)

Install MySQL early and keep it working. Experiment 1 is installation and configuration — MySQL through XAMPP, or PostgreSQL, or SQLite. Do it in the first weeks, and check that you can create a database and a table before the second experiment. A broken installation discovered in the last week cannot be fixed in a day.

Draw the ER model on paper before you build its tables. Experiment 2 asks for an ER model of a library management system. Draw it first — entities, attributes, relationships, keys — and only then create the tables from it. A wrong model makes every later query harder; a right model makes the case studies straightforward.

Practise every statement on your own tables. CREATE, INSERT, SELECT with WHERE, GROUP BY and HAVING, UPDATE, DELETE, JOIN — run each one yourself, on tables you made, before the case studies. A query you have run and fixed is worth ten you have only read.

Do the case studies in full, not in part. Each case study has four tasks, and they build on each other: retrieve, filter, update, delete. Do all four tasks of each case study, in order, and save the queries. The external practical tests the same skills on scenarios like these.

Keep the record complete and up to date. Write up each experiment and case study in the week you do it: the aim, the ER diagram or table design, the queries, and the output. The 60 internal marks rest on your practical work through the semester, and a record written in the last week is obvious to any examiner.

Practical Exam Tips

  • Write SQL exactly. One wrong keyword or one missing comma breaks a query. Write the query, then read it back slowly as if you were the database running it.
  • Test every query before you write it in the record. A query in your record should be one you have run and seen working — not one you hope works.
  • Know the difference between WHERE and HAVING. WHERE filters rows before grouping; HAVING filters groups after grouping. The viva asks this, and the case studies need it.
  • Keep your queries organised. One file per case study, with the four queries in order and a comment on what each one does. In a 3-hour practical examination, the student who can find their queries finishes; the student who cannot, does not.
  • Save your work as you go. Save after every change that works. A power cut or a crash in the last half hour should cost you minutes, not the whole examination.

Frequently Asked Questions

How many marks is DBMS (Lab) worth in the 3rd semester?
100 marks in total and 2 credits: internal assessment 60 marks (practical) and external practical examination 40 marks in 3 hours. There is no theory paper.

How is the lab related to the DBMS theory subject?
It is the practical companion to subject 3.2 Database Management System. The experiments follow the theory units: installation (Unit 1), ER modelling (Unit 2), creating tables (Unit 3), record handling and retrieval (Units 4 and 5), and the four case studies combine all of it in SQL.

What are the four case studies in the DBMS Lab?
Case Study 1: Library Management System. Case Study 2: Employee Database. Case Study 3: Bookstore Inventory. Case Study 4: Student Grades Database. Each has a scenario with columns and four SQL tasks; the full details are in the “What You Will Do” section above and in the free syllabus PDF below.

Which database system should I use for the lab?
The syllabus allows MySQL through XAMPP Server, MySQL, PostgreSQL, or SQLite. Use whichever your polytechnic teaches — the SQL in the case studies works the same way in all of them.

Which books should I refer to for the DBMS Lab?
The official syllabus lists no reference books for the laboratory. Use the reference books of the matching theory subject, Database Management System (subject 3.2) — including Fundamentals of Database Systems by Elmasri and Navathe.

How can I download the DBMS Lab syllabus PDF?
The PDF is free to download — use the download link in the Download section below. It is prepared by KAMALDNP from the official BTEUP syllabus.

Related Syllabus Posts

Notes, Question Bank & Practice Sets

There are no Short Notes, Question Bank or Practice Sets for this subject — it is a practical subject with no theory paper, so that kind of study material does not apply. The complete syllabus PDF below is free, and it is everything you need to know what to practise.

Download the Database Management System (Lab) Syllabus PDF

Download the complete Database Management System (Lab) syllabus PDF below — prepared by KAMALDNP, with the full topic list, examination scheme and reference books.

Download the Database Management System (Lab) Syllabus PDF

Source: BTEUP IRDT Kanpur NEP-2020 curriculum for Diploma in Information Technology, effective session 2026-27 (urise.up.gov.in). Topic lists follow the official syllabus; short explanations are the author's own plain-English summaries, not syllabus text. Please confirm with your own polytechnic for any local changes.

Comments (0)

Share your question or experience about this syllabus. Your comment will appear after review.

No comments yet — be the first to share your thoughts!

🤖 KAMALDNP AI Assistant

Ask about courses, website & more

Hi! I'm KAMALDNP AI Assistant. Ask me about our courses, website features, or anything else! 😊
Please wait 5s...
🤖 KAMALDNP Assistant ✕

Request human callback:

🔐 Login Required
✕

Please log in to download. You will stay on this page after logging in!

New here? Register now →