Dbms Syllabus

Core 3: Database Management System 

Unit I
Introduction: Database-System Applications, Purpose of Database Systems, View of Data, Database Languages, Relational Databases, Database Design, Data Storage and Querying, Transaction Management, Database Architecture, Database Users and Administrators. Introduction to the Relational Model: Structure of Relational Databases, Database Schema, Keys, Schema Diagrams, Relational Query Languages, Relational Operations.

Unit II 
Database Design and the E-R Model: Overview of the Design Process, The Entity-Relationship Model, Constraints, Removing Redundant Attributes in Entity Sets, Entity-Relationship Diagrams, Reduction to Relational Schemas, Entity-Relationship Design Issues, Extended E-R Features, Alternative Notations for Modeling Data, Other Aspects of Database Design. Relational Database Design: Features of Good Relational Designs, Atomic Domains and First Normal Form, Decomposition Using Functional Dependencies, Functional-Dependency Theory, Decomposition Using Multivalued Dependencies, More Normal Forms, Database-Design Process.

Unit III
Database-System Architectures: Centralized and Client –Server Architectures, Server System Architectures, Parallel Systems, Distributed Systems, Network Types. Introduction to SQL: Overview of the SQL Query Language, SQL Data Definition, Basic Structure of SQL Queries, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Nested Subqueries, Modification of the Database.

Unit IV
Intermediate SQL: Join Expressions, Views, Transactions, Integrity Constraints, SQL Data Types and Schemas, Authorization. Advanced SQL: Accessing SQL From a Programming Language, Functions and Procedures, Triggers, Recursive Queries.

Text book: 
1. A. Silberschatz, H. Korth and S. Sudarshan, Database System Concepts, 6th Ed., Tata McGraw Hill, 2011

References:
1. J. Morrison, M. Morrison and R. Conrad, Guide to Oracle 10g, Thomson Learning, 2005.
 2. Loney and Koch, Oracle 10g: The Complete Reference, Tata McGraw Hill, 2006.
3. David Flanagan, Java Script, The Definitive Guide, O’Reilly Media, 2006.
4. Marty Hall, Larry Brown, and Yaakov Chaikin, Core Servlets and Java Server Pages: Core Technologies (Vol. II), 2nd Ed., Sun Microsystems Press, 2006.
5. S.K. Singh, Database Systems Concepts, Design and Applications, Pearson Education 2006.
6. Spoken Tutorial on “MySQL” as E-resource for Learning:- http://spokentutorial.org

                                                                  https://degreecsa.blogspot.in