Group A
Introduction. Database concepts, ar chitecture, physical data orga nization, entity relationship,
data models-network, hierarchical and relational.
Relational model. Storage organization, relational algebra, relatio nal calculus, query
languages, functional dependencies, decom position of relational schemes, query
optimisation.
Group B
Database Management System (DBMS): Typical DBMS based on relational model, DDL,
creating, editing, sear ching, sorting, relational operat ions, formatted report, etc.
Features of a commercially avai lable RDBMS as case study (ORACLE).
Data administration. Processing system life cycle, security and integrity, office automation
system.