KTU 2024 Scheme · Semester 3 · Program Core (PBL) — Information Technology
Database Management System (PBITT304) Syllabus
Official KTU 2024 Scheme syllabus for Database Management System, Semester 3, Program Core (PBL) — Information Technology (Information Technology).
Course Code
PBITT304
Credits
4
Teaching Hours
3:0:0:1 (L:T:P:R)
CIE Marks
60
ESE Marks
40
Exam Duration
2 Hrs 30 Min
Prerequisites
UCEST105: Algorithmic Thinking with Python
Semester
Semester 3
Course Objective
To understand the elementary concepts of a database management system, and to design and implement a database project based on these concepts.
Module-wise Syllabus
Module 1
9 contact hoursIntroduction: overview of a database project and its scope and objectives; importance of database management systems in real-world applications. Database design: conceptual design - create an Entity-Relationship Diagram (ERD) to model the entities, relationships and attributes of the project; logical design - translate the ERD into a relational schema. Database creation: implement a sample schema in a DBMS of your choice (e.g., MySQL, PostgreSQL, SQLite). Tables and relationships: define tables with appropriate attributes (columns) and establish relationships (foreign keys) between tables.
Module 2
9 contact hoursNormalization: ensure the schema is normalized to minimize redundancy and dependency issues. SQL queries: develop a set of SQL queries to demonstrate CRUD operations (create, read, update, delete), complex joins, aggregations and any specialized queries required by the project. Timeline: create a timeline or project plan with milestones to ensure timely completion.
Module 3
9 contact hoursConstraints: entity integrity, referential integrity, domain constraints. Transaction management: definition of transactions and transaction properties (ACID), implementation of transaction processing logic. Concurrency control: techniques to manage concurrent access (e.g., locking, time stamping). Backup and recovery: strategies for database backup and recovery in case of failures.
Module 4
9 contact hoursTesting and validation: execute queries to validate the correctness of the schema and constraints. Integration with applications: develop simple applications (e.g., using Python) to interact with the database. Documentation: prepare comprehensive documentation covering project objectives, database schema, constraints, transactions and implementation details. Suggested project topics: e-commerce database platform, registered vehicle database management, library database management system, student database management, pharmacy database management system, restaurant database management, payroll database management system, insurance products database management, hospital management system, bank transactions management system.
Course Outcomes
- CO1Develop a relational database schema for a given project, utilizing Entity-Relationship Diagrams (ERDs) and translating them into a relational schema.
- CO2Normalize a database schema and develop complex SQL queries to manipulate and retrieve data efficiently.
- CO3Implement and manage database constraints, transactions, concurrency control mechanisms and backup/recovery strategies to ensure data integrity and system reliability.
- CO4Develop a database application and prepare detailed documentation.
Assessment Pattern (CIE: 60 marks, ESE: 40 marks)
Continuous Internal Evaluation (CIE)
| Attendance | 5 |
| Project | 30 |
| Internal Examination 1 (Written) | 12.5 |
| Internal Examination 2 (Written) | 12.5 |
End Semester Examination (ESE)
Total 40 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
- Database Systems: Models, Languages, Design and Application Programming — Ramez Elmasri, Shamkant B. Navathe (Pearson Education, 7th edition, 2016)
- Database System Concepts — Abraham Silberschatz, Henry F. Korth, S. Sudarshan (McGraw Hill, 7th edition, 2019)
Reference Books
- An Introduction to Database Systems — C. J. Date, S. Swamynathan, A. Kannan (Pearson Education, 8th edition, 2006)
- Database Management Systems — G. K. Gupta (Tata McGraw Hill, 2011)
Frequently Asked Questions
How many credits is KTU Database Management System (PBITT304)?
4 credits, with 3:0:0:1 (L:T:P:R) teaching hours per week, under the KTU 2024 Scheme.
How many modules are in the PBITT304 syllabus?
4 modules, 36 total contact hours.
What is the CIE and ESE mark split for this course?
CIE (Continuous Internal Evaluation): 60 marks. ESE (End Semester Examination): 40 marks, 2 Hrs 30 Min. Total: 100 marks.
What are the recommended textbooks for PBITT304?
Database Systems: Models, Languages, Design and Application Programming (Ramez Elmasri, Shamkant B. Navathe); Database System Concepts (Abraham Silberschatz, Henry F. Korth, S. Sudarshan).
Is this syllabus specific to one branch, or common to others too?
This Semester 3 course is listed under Program Core (PBL) — Information Technology at KTU under the 2024 Scheme — check the course header above for which branches it's common to.
Need help with KTU Database Management System?
Learnizo offers live, 1-on-1 online tuition for KTU IT subjects — matched to your exact module and semester.