To use the concepts in Information System implementation.
Unit 1- Introduction:
Introduction to Database Management System, Examples, Characteristics of the Database Approach, Advantage of using a Database Approach, Database System concepts and Architecture, Data Models, Schemes and Instances, DBMS Architecture and Data Independence, Database Languages and Interfaces, Database System Environment, Classification of Database Management Systems.
Unit 2- ER Models, Relational Models:
Database Modeling using the ER Model, Using High-Level conceptual Data Models for Database design, An example Database Application, Entity types, Entity Sets, Attributes and keys, Relationships, Relationship types, roles and Structural Constraints, Week Entity types, Refining the ER Design for the Company Database, ER Diagrams, naming conventions and design Issues, the Relational Data Model, Relational constraints, the Relational Algebra: Relational Model Concepts, Relational concepts and Relational Database Schemes, Update Operation and Dealing with Constraints Violations, Relational Database Design, Using ER-to-Relational Mapping.
Unit 3- Database Designing:
Functional Dependencies and Normalization for Relational Database, Informal Design Guidelines for Schemes, Functional Dependencies, Normal Forms based on Primary keys, General Definitions of Second and Third Normal forms, Boyce- Codd Normal form, Relational Database Design Algorithms and Further Dependencies, Algorithms for Relational Database Schema Design, Multivalued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form,
Inclusion Dependencies, Other Dependencies and Normal Forms.
Unit 4- SQL-The Relational Database Standard:
Data definition, Constraints and Schema changes in SQL 2, Basic Quires in SQL, More Complex SQL Quires, Insert, Delete and Update Statements in SQL, views(Virtual Tables) in SQL, Specifying general constraints as Assertion features of SQL. Integrity constrains, Triggers,
Unit 5- Transaction Processing:
Transaction Processing Concepts, Introduction to Transaction Processing, Transaction and System Concept, Desirable properties of Transactions, Scheduling and Recoverability, Serializability of Scheduling, Transaction Support in SQL, Concurrency control techniques, Concurrency techniques for concurrency control, concurrency control based on timestamp based protocol, validation based protocol, deadlock handling, Database Recovery Techniques based on Immediate Update, Failure classification, Shadow Paging, Log based recovery, failure with loss of Nonvolatile Storage.
Text Books: 1. Abraham Silberschatz and Henry Korth, Sudarshan : Database System Concepts, 4th Edition, ISBN : 0-07-120413-X, Tata McGraw-Hill. 2. Elmasri and Navathe : Fundamentals of Data base Systems ( 3rd Ed.), Addison-Wesley, 1999.
Term Work: The term work shall consist of at least 10 experiments/ assignments based on the syllabus above. Assessment of term work should be done which will consider the points below and the marks should be awarded accordingly.
Continuous lab assessment
Actually performing practicals in the laboratory during the semester