Tuesday 26 July 2011

Topic Related to DBMS






Advantages of DBMS Approach
Various view of data
Data Indpendence
Schema
Sub-Schema
Primary concept of data models
Database Languages
Transaction Management
Database administrator and users,
Data Dictionary
Overall System Architecture
ER-Model- Basic Concepts
Design Issues
Mapping Constraint
Keys
ER-Diagram
Weak and Strong entity sets
Specialitiozation and generalization
Aggregation
Inheritance
Designof ER-Schema
Reduction of ER schema of tables
Domains
Relaions
kind of Relation
Relational Database
Various Types of Keys in DBMS
Candidate Key
Primary Key
Alternate Key
Foreign Key
Relational algebra with extended operations
Modification of Database
Idea of Relational Calculus
Basic Structure of SQL
Set Operation
Aggregate Function
Null Values
Nested Subqueries
Derived Relation
Views
Join Relation
DDL in SQL
Functional Dependency
Normalization
Trivial and Non-Trivial Dependency
Closure set of Dependency
Closure set of Attributes
Irreducible set of dependency
Non loss decomposition
FD Diagram
First Second and Third Normal Forms
Dependency Preservation
BCNF
Multivalued Dependency and Fourth normal form
Join Dependency and fifth normal Form
General Idea for Database Integrity
Integrity Rules
Domain Rules
Attribute Rules
Relation Rules
Database Rules
Assertions
Triggers
Integrity and SQL
Basic Concept of Transaction, Concurrency and Recovery
ACID Property
Transaction States
Implementation of Atomicity and Durability
Concurrent Execution
Basic Idea of Serializability
Basic Idea of Concurrency Control
Basic Idea of Deadlock
Failure Classification
Storage Structure Types
Stable Storage Implementation
Data Access
Recovery and Atomicity
Log-based Recovery
Deferred Database Modification
Immediate Database Modification
Checkpoints
Distributed Database
Distributed Database Storage
Data Replication
Data Fragmentation
Horizontal-Vertical and Mixed Fragmentation
Object Oriented Database Model
Object Stucture
Object Class
Inheritance
Multiple Inheritance
Object Identity
Data Warehousing Terminology
Data mining and its Overview
Database on www
Multimedia Database
Conventional DBMS
Multimedia Data Format
Video Servers
Physical Storage of Data
Magnetic Disks Performance and Optimization
RAID
File Organisation
Organisation of records in files
Concept of Indexing
Ordered Indices
B-tree and B+ tree Organisation
Data structure Diagram
DBTG Model
Tree structure Diagram
Implementation Techniques
==============================================

Buy me a Cup of Coffee







MONIKA YADAV (MCA),
Software Engineer,
AeroSoft Corp., Indore

ROHIT KESHRIYA (MCA),
Software Engineer,
AeroSoft Corp., Indore

For guest faculty Contact us on following E-mail ID:

monikay.aerosoft@gmail.com
monikay.aerosoft@rediffmail.com
monikay.aerosoft@yahoo.com
monikay.aerosoft@hotmail.com
rohit.aerosoft@gmail.com
rohit.aerosoft@rediffmail.com
rohit.aerosoft@yahoo.com
rohit.aerosoft@hotmail.com

Note: We have been used search engines for gathering content.















Your Ad Here

















free counters

No comments:

Post a Comment