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 Database Design: DESIGNING FIELDS, CODING AND COMPRESSION TECHNIQUES
|
|
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:
|
