B. Sc Computer Science & BCA
SEMESTER :3
DATABASE MANAGEMENT
SYSTEM
CS3CRT06: Database Management Systems (Core)
Unit I
Introduction Characteristics of the Database Approach - Database users DBA, Database Designers End users -Advantages of using the DBMS Approach - Data models, Schemas, and Instances - Three-Schema Architecture and Data Independence DBMS Languages: DDL, DML - The Database System Environment: DBMS Component Modules.
Unit II.
Relational Model: Entity Relationship Modeling Introduction -Entity Types Entity Sets Attributes and Keys -Relationship Types Relationship Sets, Roles, and Structural Constraints - Weak Entity Types - Notation for ER diagrams - Sample ER diagrams Relational Model concepts: Domains Attributes, Tuples, and Relations Characteristics of Relations -Relational Model Constraints and Relational Database Schemas Domain Constraints, Key Constraints Relational Database Schemas, Entity Integrity Referential Integrity and Foreign Keys
Unit III
SQL Data Types - Data Definition commands: CREATE ALTER DROP- Adding constraints in SQL -Basic SQL Queries: INSERT SELECT DELETE UPDATE- Substring comparison using LIKEoperator BETWEEN operator - Ordering of rows - SQL set operations UNION, EXCEPT INTERSECT- Complex Queries: Comparison involving NULL and Three-valued logic Nested queries, EXISTS andUNIQUE functions, Renaming of attributes and Joining of tables, Aggregate functions Grouping -Managing Views.
Unit IV
Normalization and Indexing Structures for Files Normalization Informal Design Guidelines for Relational Schemas-Functional Dependencies - Normal forms: First Normal Form Second Normal Form Third Normal Form - General Definitions of Second and Third Normal Forms -Boyce-Godd Normal Form. Indexing Structures for files -Types of Single-Level Ordered Indexes: Primary Indexes, Clustering Indexes, and Secondary Indexes
Unit V:
Transaction Processing and Database Security Transaction Processing Introduction to Transaction Processing - Transaction and System Concepts -Desirable properties of Transactions Database Security and Authorization Types of Security Control measures Database Security and DBA - Access Control, User Accounts, and Database Audits -Access Control based on Granting and Revoking Privileges
Books of study
1 Ramez Elmasri and Shamkant BBavathe - DATABASE SYSTEMS, Sixth Edition, Pearson
Education
References
1. GJ Date- An Introduction to Database Systems, Eighth edition, Pearson Education 2003
2. Reghu Ramakrishnan and Johannes Gehrke Database Management Systems, Third edition
Mc Graw Hill International Edition
3. Dipin Desai, An Introduction to Database Systems, First Edition Galgoria Publications
No comments:
Post a Comment