Professional Electives
Other Branches
| Course Name | Principles of Database Management Systems |
| Course Code | 23CSE436 |
| Program | B. Tech. in Computer Science and Engineering (CSE) |
| Credits | 3 |
| Campus | Amritapuri ,Coimbatore,Bengaluru, Amaravati, Chennai |
Other Branches
Introduction:History of database systems – Purpose of Database systems – File Systems Vs Database systems – Database architecture – Different Data models of Database.Relational Data Model: Structure of relational databases – Database schema – Formal Relational Query Languages. Database Design: Overview of the design process – The E-R Models – Constraints – Removing Redundant Attributes in Entity Sets – E-R Diagrams – Reduction to Relational Schemas.
Relational Database Design: Different Normal forms: 1NF, 2NF, 3NF, BCNF and Higher Normal Forms, Decomposition using Functional Dependencies – Functional Dependency Theory – Multi-valued dependency – SQL: Introduction to SQL – Intermediate SQL.
Transactions: Transaction concept – A simple transaction model – Transaction atomicity and durability – Serializability – Recoverable schedules, Casecadeless schedules. Concurrency control: Lock-based protocols – Locks, granting of locks, The two-phase locking protocol, Graph-based protocols. Deadlock handling: Deadlock prevention, Deadlock detection and recovery.
Course Objectives
Course Outcomes
CO1: Understanding the purpose and architecture of DBMS.
CO2: Design of relational databases and writing SQL and PL/SQL statements to query relational databases.
CO3: Design and build ER models and Relational Schema for sample databases.
CO4: Design and build a normalized database management system for real world databases.
CO5: Understand the principles of transaction processing and concurrency control.
CO-PO Mapping
|
PO/PSO |
PO1 |
PO2 |
PO3 |
PO4 |
PO5 |
PO6 |
PO7 |
PO8 |
PO9 |
PO10 |
PO11 |
PO12 |
PSO1 |
PSO2 |
|
CO |
||||||||||||||
|
CO1 |
1 |
2 |
– |
3 |
3 |
– |
– |
– |
– |
– |
– |
– |
3 |
2 |
|
CO2 |
2 |
3 |
3 |
2 |
3 |
– |
– |
– |
1 |
1 |
– |
– |
3 |
2 |
|
CO3 |
2 |
3 |
3 |
2 |
3 |
– |
– |
– |
1 |
1 |
– |
– |
3 |
2 |
|
CO4 |
2 |
3 |
3 |
2 |
– |
– |
– |
– |
3 |
3 |
– |
– |
3 |
2 |
|
CO5 |
1 |
1 |
2 |
1 |
2 |
– |
– |
– |
– |
– |
– |
– |
3 |
2 |
Evaluation Pattern: 70:30
|
Assessment |
Internal |
End Semester |
|
MidTerm Exam |
20 |
|
|
Continuous Assessment – Theory (*CAT) |
10 |
|
|
Continuous Assessment – Lab (*CAL) |
40 |
|
|
**End Semester |
30 (50 Marks; 2 hours exam) |
*CAT – Can be Quizzes, Assignments, and Reports
*CAL – Can be Lab Assessments, Project, and Report
**End Semester can be theory examination/ lab-based examination/ project presentation
Textbook(s)
Silberschatz A, Korth H F, SudharshanS. “Database System Concepts”, Sixth Edition, TMH publishing company limited; 2011.
Reference(s)
?or?evi?-Kajan S. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, “Database system: The complete book”. Prentice Hall; 2nd edition 2008
Elmasri R, Navathe SB. “Fundamentals of Database systems”; 7h Edition Pearson; 2006.
Ramakrishnan R, Gehrke J. “Database management systems”. 3rd Edition McGraw Hill; 2007.
DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.