Unit I
Introduction to DBMS: Database System Vs File system, Database systems applications, Purpose of database systems – Data models. Relational models: Structure of relational databases – database schema keys – schema diagrams.
| Course Name | Database Management |
| Course Code | 24ASD512 |
| Program | M.Sc. in Applied Statistics and Data Analytics |
| Semester | 2 |
| Credits | 4 |
| Campus | Coimbatore , Kochi |
Introduction to DBMS: Database System Vs File system, Database systems applications, Purpose of database systems – Data models. Relational models: Structure of relational databases – database schema keys – schema diagrams.
Relational Query Languages – fundamental relational algebra operations – additional relational algebra operations. Introduction to SQL – Background – SQL data definition –structure of SQL queries – set operations – null values – aggregate functions – modifications to the database.
Database design – overview of the design process – the entity-relationship model – constraints – entity-relationship diagrams – reduction to relation schemas – Entity-relationship design issues – weak entity sets – extended E-R features.
Intermediate SQL: Nested subqueries – Join expression – Views – Transactions – integrity constraints – authorization. Advanced SQL – functions and procedures – triggers.
Relational database design – features of good relational designs – atomic domains and normal forms – 1NF, 2NF, 3NF, 4NF and BCNF – decomposition using functional dependencies – functional dependency theory – Transaction Management – ACID properties of Transactions – Concurrency control.
Course Outcomes:
CO1: Understand the basics database systems, relational models and database schema
CO2: Gain knowledge about various database design processes and entity relationship
models
CO3: To understand the intermediate SQL and advanced SQL queries
CO4: To understand the normal forms, database decomposition and functional
dependencies
CO5: To understand Transaction management and concurrency control in DBMS
CO-PO Mapping:
|
PO1 |
PO2 |
PO3 |
PO4 |
PO5 |
PO5 |
PO6 |
PO7 |
PO8 |
PO9 |
PO10 |
PO11 |
PO12 |
|
|
CO1 |
2 |
2 |
2 |
2 |
2 |
2 |
1 |
2 |
1 |
||||
|
CO2 |
2 |
2 |
2 |
2 |
2 |
2 |
1 |
2 |
1 |
||||
|
CO3 |
2 |
2 |
2 |
2 |
2 |
2 |
1 |
2 |
1 |
||||
|
CO4 |
2 |
2 |
1 |
2 |
2 |
1 |
1 |
1 |
1 |
||||
|
CO5 |
1 |
2 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
Text Book / Reference Books:
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.