DBMS

UNIT 1

Advantages and components of DBMS
Feasibility Studies
Class diagrams
Data types
Events
Normal forms
Integrity
Converting class diagrams to normalized tables
Data dictionary
     

UNIT 2

Query Basics
Computation with queries
Sub totals and Group by command
Queries with multiples
Sub queries
Joints
DDL and DML
Testing queries

UNIT 3

Effective designs of forms and reports
Form layout
Creating forms
Graphics
Objects
Reports
Procedural languages
Data on form
Program to retrieve and save data
Error handling

UNIT 4

Power of application structure
User inter face features
Transactions
Forms
Events
Custom reports
Distributing application
Table operations
Data storage methods
Storing data columns
Data clustering and partitioning

UNIT 5

DB administration
Development storages
Application types
Back up and Recovery
Security and Privacy
Distributed data bases
Client server data bases
Kleb as a click server system
Object
Object oriented data bases
Integrated applications