KTU 2024 Scheme · Semester 4 · Common to CS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG
DBMS Lab (PCCSL408) Syllabus
Official KTU 2024 Scheme syllabus for DBMS Lab, Semester 4, Common to CS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG (Computer Science and Engineering).
Course Code
PCCSL408
Credits
2
Teaching Hours
0:0:3:0 (L:T:P:R)
CIE Marks
50
ESE Marks
50
Exam Duration
2 Hrs 30 Min
Prerequisites
None
Semester
Semester 4
Course Objective
To equip students with comprehensive skills in SQL, PL/SQL, and NoSQL databases, and to enable the learner to proficiently design, implement, and manage relational and non-relational databases.
Module-wise Syllabus
Module 1
Designing a database schema with an ER diagram from a problem description; creating the schema with DDL (tables, constraints, relationships, indices) and exporting/verifying the ER diagram; database initialization and bulk data import; SQL DML practice (insert, update, alter, delete, conditional queries); aggregate functions, ORDER BY, GROUP BY and HAVING; set operators, nested queries and joins; TCL commands (Rollback, Commit, Savepoint) and DCL commands for granting/revoking privileges; views and assertions; procedures, triggers and functions; packages and cursors; a front-end database application (5+ tables) for the problem designed earlier; basic CRUD operations and CQL queries on a Cassandra table; a simple MongoDB application with Python (designed to convey the difference of NoSQL from SQL databases).
Course Outcomes
- CO1Develop database schema for a given real world problem-domain using standard design and modeling approaches.
- CO2Construct queries using SQL for database creation, interaction, modification, and updation.
- CO3Plan and implement triggers and cursors, procedures, functions, and control structures using PL/SQL.
- CO4Perform CRUD operations in NoSQL databases.
- CO5Design database applications using front-end tools and back-end DBMS.
Assessment Pattern (CIE: 50 marks, ESE: 50 marks)
Continuous Internal Evaluation (CIE)
| Attendance | 5 |
| Preparation / Pre-Lab Work, Viva, Timely Record Completion (Continuous Assessment) | 25 |
| Internal Examination | 20 |
End Semester Examination (ESE)
Total 50 marks, 2 Hrs 30 Min. See the official KTU syllabus document for the exact Part A / Part B question pattern for this course.
Textbooks & Reference Books
Textbooks
- Fundamentals of Database Systems — Elmasri, Navathe (Pearson, 7th edition, 2017)
- Professional NoSQL — Shashank Tiwari (Wiley, 1st edition, 2011)
Reference Books
- Database System Concepts — Abraham Silberschatz, Henry F. Korth, S. Sudarshan (McGraw Hill, 7th edition, 2017)
- NoSQL for Dummies — Adam Fowler (John Wiley & Sons, 1st edition, 2015)
- NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data) — Olivier Pivert (Ed.) (Wiley, 1st edition, 2018)
- Making Sense of NoSQL: A Guide for Managers and the Rest of Us — Dan McCreary and Ann Kelly (Manning, 1st edition, 2014)
Frequently Asked Questions
How many credits is KTU DBMS Lab (PCCSL408)?
2 credits, with 0:0:3:0 (L:T:P:R) teaching hours per week, under the KTU 2024 Scheme.
How many modules are in the PCCSL408 syllabus?
1 modules.
What is the CIE and ESE mark split for this course?
CIE (Continuous Internal Evaluation): 50 marks. ESE (End Semester Examination): 50 marks, 2 Hrs 30 Min. Total: 100 marks.
What are the recommended textbooks for PCCSL408?
Fundamentals of Database Systems (Elmasri, Navathe); Professional NoSQL (Shashank Tiwari).
Is this syllabus specific to one branch, or common to others too?
This Semester 4 course is listed under Common to CS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG at KTU under the 2024 Scheme — check the course header above for which branches it's common to.
Need help with KTU DBMS Lab?
Learnizo offers live, 1-on-1 online tuition for KTU CSE subjects — matched to your exact module and semester.
Explore BTech CSE Tuition