 Computer
Science |
 |
Syllabus
2004 - 2005
B.Sc. III - Computer Science
Database Management System and RDBMS (Paper
II)
Database System Architecture of database system, Benefits of database approach, Application of database, Characteristics of database system, trade - off.
Unit 2 :
Database development process : Key concepts, all types of
dependency, concepts of data model, ER model, Hierarchical model, Network
model, Object oriented model ,normalization of database, normal form(steps
of normalization)
Unit 3 :
Relational algebra ( selection, projection, union,
intersection, Cartesian product, join) Structured Query Language (SQL),
Data Definition Language (DDL),Data Manipulation Language (DML), Data
Control Language (DCL), Transaction Control Language (TCL), PL/SQL, Role
of DBA (Database Administrator).
Unit 4 :
Concepts of RDBMS, characteristics of RDBMS, Codd's 12 rule. introduction
to oracle tools, security.
Unit 5 :
Different type of database and application, decentralized
database, centralized database, application of centralize database,
distributed database, application of distributed database.