Data Base Management System (DBMS)

Course Code: MIT207

Course Title: Data Base Management System(DBMS) (4 Credits)




Course Contents


Unit-1: Database Management System Concepts: Significance of Database, Database System Applications, Data Independence; Data Modelling for a Database-Entities and their attributes; Relationships and types; Advantages and Disadvantages of Database Management System, DBMS Vs RDBMS.


Unit-2: Database System Architecture: Three Level Architecture: External Level, Conceptual Level, Internal Level; Mapping; MySQL Architecture; SQL Server 2000 Architecture; Oracle Architecture, Database Management System Facilities , Database Management System Structure, Distributed Processing.


Unit-3: Database Models and Implementation: Data Models and types of data Models- Relational Data Model, Hierarchical Model, Network Data Model, Object-Relational Model, Object-Oriented Model; Entity-Relationship Model-Modelling using E-R Diagrams; Notations used in E-R Model, Relationships and Relationship Types; Associative Database Model.


Unit-4: File Organization for Conventional DBMS: Storage Devices and its Characteristics- Magnetic Disks, Physical Characteristics of Disks ,Performance Measures of Disks, Optimization of Disk-Block Access; File Organization-Fixed-Length Records, Variable-Length Records; Organization of records in files; Sequential file Organization, Indexed Sequential Access Method (ISAM), Virtual Storage Access Method (VSAM).


Unit-5: An Introduction to RDBMS: An informal look at the relational model; Relational Database Management System, RDBMS Properties; Overview of Relational Query Optimization; System Catalog in a Relational DBMS-Information Stored in the System Catalog, How Catalogs are Stored.


Unit-6: SQL – 1: Introduction to SQL, Categories of SQL Commands, Data Definition, Data Manipulation Statements-SELECT - The Basic Form, Sub queries, Functions, GROUP BY Feature, Updating the Database; Data Definition Facilities.


Unit-7: SQL – 2: Views; Embedded SQL *- Declaring Variables and Exceptions, Embedding SQL Statements; Transaction Processing- Consistency and Isolation, Atomicity and Durability.


Unit-8: Relational Algebra: Basic Operations; Union; Difference (-); Intersection(Ç); Cartesian Product (x); Additional Relational Algebraic Operations-Projection (p), Selection (s), JOIN (¥); Division (¸).


Unit-9: Relational Calculus: Tuple Relational Calculus-Semantics of TRC Queries, Examples of TRC Queries; Domain Relational Calculus; Relational Algebra Vs Relational Calculus.


Unit-10: Normalization: Functional Dependency, Anomalies in a Database, Properties of Normalized Relations, First Normal Form, Second Normal Form ,Third Normal Form, Boyce-Codd Normal Form (BCNF), Fourth and Fifth Normal Forms.


Unit-11: Query Processing and Optimization: Query interpretation; Equivalence of expressions; Algorithm for executing query operations; Heuristics of Query Optimization, Semantic Query Optimization, Converting Query Tree to Query Evaluation Plan, Cost Estimates in Query Optimization, Join Strategies for Parallel Processing.


Unit-12: Distributed Databases: Structure of Distributed Database; Tradeoffs in Distributing the Database-Advantages of Data Distribution, Disadvantages of Data Distribution; Design of Distributed Databases; Data Replication, Data Fragmentation.


Unit-13: Object Oriented DBMS: Next Generation Database System, New Database Application; Object Oriented Database Management System, Features of Object Oriented System, Advantages of Object Oriented Database Management System, Deficiencies of Relational Database Management System, Difference between Relational Database Management System and Object Oriented Database Management System, Alternative Object Oriented Database Strategies.


Unit-14: Object Relational Mapping: Significance of Mapping , Mapping Basics, Mapping a Class Inheritance Tree, Mapping Object Relationships, Modelling with Join Tables, Open Source Object Relational Mapping Software.