Database Management Systems(Bsc(Cs)II-IV) Syllabus

DSC–3D              Database Management Systems               BS406

Theory	4 Hours/Week	4 credits
Practical	2 Hours/Week	1 credit

Unit –  I

Introduction to Databases: Introduction, Traditional File-Based Systems, Database Approach, Roles in the Database Environment, Advantages and Disadvantages of DBMSs, The Three-Level ANSI-SPARC Architecture, Database Languages, Data Models, Functions of a DBMS, Components of a DBMS.

Relational Model: Introduction, Terminology, Integrity Constraints, Views.

The Relational Algebra: Unary Operations, Set Operations, Join Operations, Division Operation, Aggregation and Grouping Operations.

Unit –  II

SQL: Introduction, Data Manipulation–Simple Queries, Sorting Results, Using the SQL Aggregate Functions, Grouping Results, Sub-queries, ANY and ALL, Multi-table Queries, EXISTS and NOT EXIST, Combining Result Tables, Database Updates.

SQL: The ISO SQL Data Types, Integrity Enhancement Feature–Domain Constraints, Entity Integrity, Referential Integrity, General Constraints, Data Definition–Creating a Database, Creating a Table, Changing a Table Definition, Removing a Table, Creating an Index, Removing an Index, Views–Creating a View, Removing a View, View Resolution, Restrictions on Views, View Updatability, WITH CHECK OPTION, Advantages and Disadvantages of Views, View Materialization, Transactions, Discretionary Access  Control–Granting  Privileges to Other Users, Revoking Privileges from Users.

Advanced SQL: The SQL Programming Language–Declarations, Assignments, Control Statements, Exceptions, Cursors, Subprograms, Stored Procedures, Functions, and Packages, Triggers, Recursion.

Unit –  III

Entity–Relationship Modeling: Entity Types, Relationship Types, Attributes, Keys, Strong and Weak Entity Types, Attributes on Relationships, Structural Constraints, Problems with ER Models–Fan Traps,  Chasm Traps.

Enhanced Entity–Relationship Modeling: Specialization/Generalization, Aggregation, Composition. Functional–Dependencies: Anomalies, Partial Functional Dependency, Transitive Functional Dependency, Multi Valued Dependency, Join Dependency.

Normalization: The Purpose of Normalization, How Normalization Supports Database Design, Data Redundancy and Update Anomalies, Functional Dependencies in brief, The Process of Normalization,1NF, 2NF, 3NF, BCNF. The Database Design Methodology for Relational Databases (Appendix–D).

Unit –  IV

Transaction Management: Transaction Support–Properties of Transactions, Database Architecture, Concurrency Control–The Need for Concurrency Control, Serializability and Recoverability, Locking Methods, Deadlock, Time Stamping Methods, Multi-version Timestamp Ordering, Optimistic Techniques, Granularity of Data Items, Database Recovery–The Need for Recovery, Transactions and Recovery, Recovery Facilities, Recovery Techniques, Nested Transaction Model.

Security: Database Security–Threats, Computer-Based Controls–Authorization, Access Controls,  Views, Backup and Recovery, Integrity, Encryption, RAID.


Text

Thomas M. Connolly, Carolyn E. Begg, Database Systems–A Practical Approach to Design, Implementation, and Management (6e)

References   Sharon Allen, Evan Terry, Beginning Relational Data  Modeling

Jeffrey A. Hoffer, V. Ramesh, Heikki Topi, Modern Database Management 
Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems 
Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database   Systems

Abraham  Silberschatz, Henry  F. Korth, S. Sudarshan,  Database System  Concepts

C Coronel, S Morris, Peter Rob, Database Systems: Design, Implementation, and Management

                                            

                                           For more info visit    Degreecsa.blogspot.in