KTU 2024 Scheme · Semester 4 · Program Core (PBL) — Artificial Intelligence and Machine Learning
Database Systems (PBCMT404) Syllabus
Official KTU 2024 Scheme syllabus for Database Systems, Semester 4, Program Core (PBL) — Artificial Intelligence and Machine Learning (Artificial Intelligence and Machine Learning).
Course Code
PBCMT404
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
None
Semester
Semester 4
Course Objective
To equip students with a comprehensive understanding of fundamental DBMS concepts as well as the principles and applications of NoSQL databases, and to enable them to design, implement and manage both relational and NoSQL databases.
Module-wise Syllabus
Module 1
11 contact hoursIntroduction to databases: database system concepts and architecture - data models, schemas and instances, the three-schema architecture and data independence, database languages and interfaces, centralized and client/server architectures for DBMSs. Conceptual data modelling and database design: data modelling using the Entity-Relationship model - entity types, entity sets, attributes and keys, relationship types, relationship sets, roles and structural constraints, weak entity types, refining the ER design for the COMPANY database.
Module 2
11 contact hoursThe relational data model and SQL: the relational data model and relational database constraints, relational algebra and relational calculus, Structured Query Language (SQL) - data definition language, data manipulation language, assertions, triggers, views. Relational database design using ER-to-relational mapping.
Module 3
11 contact hoursDatabase design theory and normalization: functional dependencies - basic definition, normalization - first, second and third normal forms. Transaction management: transaction processing - introduction, problems and failures in transactions, desirable properties of transactions, characterizing schedules based on recoverability and serializability. Concurrency control with two-phase locking techniques. Database recovery management - deferred update, immediate update, shadow paging.
Module 4
11 contact hoursIntroduction to NoSQL concepts: types of NoSQL databases, CAP theorem, BASE properties, use cases and limitations of NoSQL. NoSQL architectural patterns: key-value stores, graph stores, column family stores and document stores.
Course Outcomes
- CO1Summarize and exemplify the fundamental nature and characteristics of database systems.
- CO2Model and design solutions for efficiently representing data using the relational model or a non-relational model.
- CO3Discuss and compare the aspects of concurrency control and recovery in database systems.
- CO4Construct and execute basic to advanced SQL queries to effectively retrieve, filter and manipulate data from relational databases.
- CO5Demonstrate a comprehensive understanding of NoSQL database concepts.
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
- Fundamentals of Database Systems — Ramez Elmasri, Shamkant Navathe (Pearson, 7th edition, 2017)
- Making Sense of NoSQL: A Guide for Managers and the Rest of Us — Dan McCreary, Ann Kelly (Manning, 1st edition, 2014)
Reference Books
- Database System Concepts — Abraham Silberschatz, Henry F. Korth, S. Sudarshan (McGraw Hill, 7th edition, 2011)
- Beginning Database Design Solutions — Rod Stephens (Wiley, 2nd edition, 2023)
- NoSQL Distilled — Pramod J. Sadalage, Martin Fowler (Addison-Wesley, 1st edition, 2012)
- NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data), Vol. 1 — Olivier Pivert (Wiley, 1st edition, 2018)
Frequently Asked Questions
How many credits is KTU Database Systems (PBCMT404)?
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 PBCMT404 syllabus?
4 modules, 44 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 PBCMT404?
Fundamentals of Database Systems (Ramez Elmasri, Shamkant Navathe); Making Sense of NoSQL: A Guide for Managers and the Rest of Us (Dan McCreary, Ann Kelly).
Is this syllabus specific to one branch, or common to others too?
This Semester 4 course is listed under Program Core (PBL) — Artificial Intelligence and Machine Learning at KTU under the 2024 Scheme — check the course header above for which branches it's common to.
Need help with KTU Database Systems?
Learnizo offers live, 1-on-1 online tuition for KTU AI&ML subjects — matched to your exact module and semester.