Top banner

Tuesday, December 29, 2009

Data base concepts and Systems

Introduction- Purpose of Database Systems, Views of data, Data Models, Database
language, Transaction Management, Storage Management, Database Administrator,
Database Users, Overall System Structure, Different types of Database Systems 

E-R  Model:  Basic  Concepts,  Design  Issues,  Mapping  Constraints,  Keys,  E-R
Diagram,  Weak  Entity  set,  Extended  E-R  features,  Design  Of  an  E-R  Database
Schema, Reduction of an E-R schema to Tables 

Relational  Model:  Structure  of  Relational  Database,  The  Relational  Algebra,  The
tuple relational calculus, The Domain Relational Calculus, Views 

SQL-  Background,  Basic  Structure,  SET  operations,  Aggregate  functions,  Null
Values,  Nested  Sub  queries,  Derived  Relations,  Views,  Modification  of  Database,
Joined Relations, DDL, Other SQL features 

Transaction-   Transaction   Concepts,   State,   Implementations   of   Atomicity   and
durability,    Concurrent    Executions,    Serializability,    Recoverability,    Transaction
Definition in SQL. 
Concurrency  Control-  Lock  based  protocol,  Timestamp  based  protocol,  Validation
based  protocol,  Multiple  Granularity,  Multi  version  Schemes,  Deadlock  Handing,
Insert and Delete operations, Concurrency in index structure 
Relational Database Design- Pitfalls in Relational-Database Design, Decomposition,
Normalization Using Functional Dependencies, and Normalization Using Multi valued
Dependencies, Normalization Using Join Dependencies, Domain-Key Normal Form
and Alternative Approaches to Database Design
Other  Relevant  Advance  Topics  and  Applications-  Object  Oriented  Database,
Decision-Support Systems, Data Analysis, Data Mining, Data Warehousing, Spatial
and   Geographic   Databases,   Multimedia   Databases,   Mobility   and   Personal
Databases,  Information-Retrieval  Systems,  Distributed  Information  Systems,  The
World Wide Web
ORACLE 8.0 Database: SQL, PL/SQL, Developer 2000(Oracle Forms and Reports)

No comments:

Post a Comment