Home >> Computer Science >> Database Management

Database Management Systems

Table of Contents
Introduction to Databases and Traditional File Processing Systems
Advantages, Cost, Importance, Levels, Users of Database Systems
Database Architecture: Level, Schema, Model, Conceptual or Logical View:
Internal or Physical View of Schema, Data Independence, Funct ions of DBMS
Database Development Process, Tools, Data Flow Diagrams, Types of DFD
Data Flow Diagram, Data Dictionary, Database Design, Data Model
Entity-Relationship Data Model, Classification of entity types, Attributes
Attributes, The Keys
Relationships:Types of Relationships in databases
Dependencies, Enhancements in E-R Data Model. Super-type and Subtypes
Inheritance Is, Super types and Subtypes, Constraints, Completeness Constraint, Disjointness Constraint, Subtype Discriminator
Steps in the Study of system
Conceptual, Logical Database Design, Relationships and Cardinalities in between Entities
Relational Data Model, Mathematical Relations, Database Relations
Database and Math Relations, Degree of a Relation
Mapping Relationships, Binary, Unary Relationship, Data Manipulation Languages, Relational Algebra
The Project Operator
Types of Joins: Theta Join, Equi–Join, Natural Join, Outer Join, Semi Join
Functional Dependency, Inference Rules, Normal Forms
Second, Third Normal Form, Boyce - Codd Normal Form, Higher Normal Forms
Normalization Summary, Example, Physical Database Design
Physical Record and De-normalization, Partitioning
Vertical Partitioning, Replication, MS SQL Server
Rules of SQL Format, Data Types in SQL Server
Categories of SQL Commands,
Alter Table Statement
Select Statement, Attribute Allias
Data Manipulation Language
ORDER BY Clause, Functions in SQL, GROUP BY Clause, HAVING Clause, Cartesian Product
Inner Join, Outer Join, Semi Join, Self Join, Subquery,
Application Programs, User Interface, Forms, Tips for User Friendly Interface
Designing Input Form, Arranging Form, Adding Command Buttons
Data Storage Concepts, Physical Storage Media, Memory Hierarchy
File Organizations: Hashing Algorithm, Collision Handling
Hashing, Hash Functions, Hashed Access Characteristics, Mapping functions, Open addressing
Index Classification
Ordered, Dense, Sparse, Multi-Level Indices, Clustered, Non-clustered Indexes
Views, Data Independence, Security, Vertical and Horizontal Subset of a Table
Materialized View, Simple Views, Complex View, Dynamic Views
Updating Multiple Tables, Transaction Management
Transactions and Schedules, Concurrent Execution, Serializability, Lock-Based Concurrency Control, Deadlocks
Incremental Log with Deferred, Immediate Updates, Concurrency Control
Serial Execution, Serializability, Locking, Inconsistent Analysis
Locking Idea, DeadLock Handling, Deadlock Resolution, Timestamping rules

Related Documents: