| Course Name | Database Management System |
| Course Code | 25CSA112 |
| Program | B. Sc. in Physics, Mathematics & Computer Science (with Minor in Artificial Intelligence and Data Science) |
| Semester | 2 |
| Credits | 4 |
| Campus | Mysuru |
Basic SQL Commands DML- Select, insert, Delete DDL Commands-Create, Drop, Alter
Built in SQL functions- Set operations, Sub Queries-Joins-DCL – TCL- Views – Sequences – Index – Locks PL/SQL Basics – Exceptions – Cursors – Stored Functions – Triggers Programming with PL/SQL
Introduction to Data and Database. Significance of Database Management System, Various Types of DBMS. Data Independence – The Three Levels Of Architecture – The External Level – Conceptual Level – Internal Level – Client/Server Architecture- System Structure, Instance and schema,
Keys – CODD’s Rules, Design Issues -ER – Model –Attribute types- Weak Entity Sets – Extended ER Features –ER to Relational Mapping, Structure Of Relational Databases, Creation and Manipulation of Database using Basic SQL(DDL, DML,DCL,TCL )
Normalization –Anomalies- Functional Dependency: Armstrong’s axioms- closure of a relation and closure of attribute– Lossless decomposition-1NF, 2NF, 3NF, Boyce – Codd Normal Form
The Relational Algebra — Query Processing and Optimization: Evaluation of Relational algebra expressions-Query Equivalence-Transaction Processing: ACID properties, states of a transaction- Introduction to concurrency control- Deadlock-Recovery.
Course Outcomes
| Cos | Description |
| CO1 | Explain the basic concepts of DBMS and its types. Understand the concepts of data independence and three schema architecture. |
| CO2 | Explain the CODD’s rules and E-R Model and the structure of relational databases. |
| CO3 | Explain the concept of normalization and different types of normalization. Design normalized database objects and process the data in an optimized way. |
| CO4 | Explain the basics of query evaluation techniques and query optimization and also to get a clear picture about transaction processing. |
| CO5 | Demonstrate the conversion of queries into relational algebra and to construct query transactions having atomic, consistent, isolated and durable properties. |
TEXTBOOKS:
1) Silberschatz Korth. Sudarshan: Database System Concepts – 6thEdition Mcgraw-Hill International Edition
2) Ivan Bayross: Sql- PL/SQL The Programming Language of Oracle- 4rd Edition- Bpb Publications
REFERENCE:
1) C.J. Date: An Introduction To Database Systems – Eighth Edition – PearsonEducation Asia.
2) Kevin Loney – George Koch: Oracle 9i The Complete Reference Mcgraw-Hill International Edition.
3) “Fundamentals of Database Systems” by Elmasri and Navathe.
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.
