B.Sc(Computer Science): III Year
THEORY PAPER – III
Database Management Systems
Unit-1 :
Database Systems Introduction and Fundamentals. 18 hrs
Database Systems: Introducing the database and DBMS, Why the database is important,Historical Roots: Files and File Systems, Problems with File System Data Management, DatabaseSystems.
Data Models: The importance of Data models, Data Model Basic Building Blocks, Business Rules, The evaluation of Data Models, Degree of Data Abstraction.
The Relational Database Model: A logical view of Data, Keys, Integrity Rules, Relational Set Operators, The Data Dictionary and the system catalog, Relationships with in the Relational Database, Data Redundancy revisited, Indexes, Codd’s relational database rules.
(Chapters:1: 1.2 to 1.6,2,3)
Unit-2 :
Data Modeling and Normalization 18 hrs
Entity Relationship Model: The ER Model, Developing ER Diagram, Database Design Challenges: Conflicting Goals.
Advanced Data Modeling: The Extended Entity Relationship Model, Entity clustering, Entity integrity: Selecting Primary keys, Design Cases: Learning Flexible Database Design.
Normalization of database tables: Database Tables and Normalization, The need for Normalization, The Normalization Process, Improving the design, Surrogate Key Considerations, High level Normal Forms, Normalization and database design, denormalization.
(Chapters: 4,6,5)
Unit-3 :
Interaction with Databases and Construction of Information System 18 hrs
Introduction to SQL: Data Definition Commands, Data Manipulation Commands, Select queries, Advanced Data Definition Commands, Advanced Select queries, Virtual Tables, Joining atabase Tables.
Advanced SQL: Relational Set Operators, SQL Join Operators, Subqueries and correlated queries, SQL Functions, Oracle Sequences, Updatable Views, and Procedural SQL.
Database Design: The Information System, The Systems Development Life Cycle, The Database Life Cycle, Database Design Strategies, Centralized Vs Decentralized design.
Unit-4 :
Transaction Management in DBMS Environment. 18 hrs
Transaction Management and Concurrency Control: What is transaction, Concurrency control, Concurrency control with locking Methods, Concurrency control with time stamping methods, concurrency control with optimistic methods, database recovery management.
Distributed Database Management Systems: The evolution of Distributed Database Management Systems, DDBMS advantages and Disadvantages, Distribution Processing and Distribution Databases, Characteristics of Distributed database management systems, DDBMS Components, Levels of Data and Process distribution, Distributed database Transparency Features, Distributed Transparency, Transaction Transparency, Performance Transparency and Query Optimization, Distributed Database Design, Client Server VS DDBMS.
(Chapters: 10, 12)
Unit-5 :
Data Warehouse Concepts and Database Administration. 18 hrs
The Data Warehouse: The need for data analysis, Decision support systems, The data warehouse, nline analytical processing, Star schemas, Data mining, SQL extension for OLAP.
Database Administration: Data as a Corporate asset, The need for and role of databases in an organization, The evolution of the database administration function, The database environment’s Human Component, Database administration Tools, The DBA at work: Using Oracle for Database Administration.
(Chapter: 13:13.1 to 3.5,13.7,13.8,15:15.1,15.2,15.4,15.5,15.6,15.8)
Prescribed Text Book:
1. Peter Rob, Carlos Coronel, Database Systems Design, Implementation and Management, Seventh Edition, Thomson (2007)
Reference Books:
1. Elimasri / Navathe, Fundamentals of Database Systems, Fifth Edition, Pearson Addison Wesley (2007).
2. Raman A Mata – Toledo/Panline K Cushman, Database Management Systems, Schaum’s Outlibe series, Tata McGraw Hill (2007).
3. C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eight Edition, earson Education (2006).
4. Michel Kifer, Arthur Bernstein, Philip M. Lewis, Prabin K. Pani Graphi, Database Systems: An application oriented Approach, second edition, pearson education (2008).
5. Atul Kahate, Introduction to Database Management Systems, Pearson Education (2006).
No comments:
Post a Comment