Syllabus Bsc III Year PIII Dbms

Syllabus for B.Sc. - Computer Science

1
B.Sc(Computer Science): III Year
THEORY PAPER – III
Database Management Systems

Unit-1 :     Database Systems Introduction and Fundamentals. 

                Database Systems: Introducing the database and DBMS, Why the database is important Historical Roots: Files and File Systems, Problems with File System                          Data  Management, Database Systems.
                 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

                   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 

                 Introduction to SQL: Data Definition Commands, Data Manipulation Commands, Select queries, Advanced Data Definition Commands, Advanced Select                             queries, Virtual Tables, Joining Database 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.

(Chapters: 7,8(8.1 to 8.7),9)

Unit-4 : Transaction Management in DBMS Environment. 

                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.
                 The Data Warehouse: The need for data analysis, Decision support systems, The data warehouse, Online 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 , Pearson 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).