Characteristics of Database approach, Actors on the Scene, Workers behind the scene, Advantages of using DBMS approach, A Brief History of Database Applications, Data models, schemas and instances, Three-schema architecture and data independence, Database languages and interfaces, the database system environment, Centralized and client-server architectures, Classification of Database Management systems.
Structure of Relational Databases, Database Schema, Keys, Relational Query Languages, Relational Operations. Entity-Relationship Model: Conceptual Database using high level conceptual data models for Database Design, A Sample Database Application, Entity types, Entity sets Attributes and Keys Relationship types, Relationship Sets Functional Dependencies, Normal Forms based on Primary
SQL data definition and data types, specifying constraints in SQL, basic retrieval queries in SQL, Insert, update and delete statements in SQL, aggregate functions in SQL, group by and having clauses.
Introduction to triggers in SQL, views in SQL, schema change statements in SQL, stored procedures and functions.
Introduction to transaction processing,
transaction and system concepts, desirable properties of transactions, transaction support in SQL.
Concurrency control techniques:
two-phase locking techniques, concurrency control based on timestamp ordering, multiversion concurrency control techniques, validation concurrency control techniques.
Recovery techniques:
recovery concepts, recovery in multidatabase systems, database backup and recovery from catastrophic failures.
Question Paper Pattern:
• The Question paper will have TEN questions
• Each full question will be for 20 marks
• There will be 02 full questions (with maximum of four sub questions) from each module.
• Each full question will have sub questions covering all the topics under a module.
• The students will have to answer FIVE full questions, selecting one full question from each module.
Text Books
1. Elmasri and Navathe: Fundamentals of Database Systems, 5th Edition, Addison -Wesley, 2011.
2. Silberschatz, Korth and Sudharshan Data base System Concepts, 6th Edition, Tata McGraw Hill, 2011.
References
1. C.J. Date, A. Kannan, S. Swamynatham: An Introduction to Database Systems, 8th Edition, Pearson education, 2009.
2. Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems, 3rd Edition, McGraw-Hill, 2003.
Course Outcomes:
At the end of the course students will be able to 1.
CO1: Apply the basic concepts of database management in designing the database for the given problem.
CO2: Design entity-relationship diagrams to the given problem to develop database application with appropriate fields and validations.
CO3: Implement a database schema for the given problem domain.
CO4: Formulate and execute SQL queries to the given problem.
CO5: Apply normalization techniques to improve the database design to the given problem.