Syllabus For The Subject DATABASE MANAGEMENT ACCOUNTING

UNIT - 01

INTRODUCTION TO DATABASE - OPERATIONAL DATA - DATA INDEPENDENCE -

COMPONENTS - DBMS - DBA - DATA DICTIONARY - STORAGE STRUCTURES - B-TREES -

INDEXING - COMPRESSION - SYMBOLIC POINTER.

UNIT - 02

ORGANIZING DATA - RELATIONAL - HIERARCHICAL - NETWORK - OPERATORS -

SELECTION - PROJECTION - JOIN - RELATIONAL DATA STRUCTURES - DOMAINS AND

ATTRIBUTES - KEYS - CONSTRAINTS - EXTENSION - INTENSION.

UNIT - 03

SYSTEM-R ARCHITECTURE - SQL - INDEXES - DATA MANIPULATION - BUILT-INFUNCTIONS

- UPDATE - INSERTION - RELATIONS - EMBEDDED SQL - DYNAMIC STATEMENTS -

PREPARE - EXECUTE.

UNIT - 04

EXTERNAL LEVEL - VIEWS AND DATA INDEPENDENCE - INTERNAL LEVEL - QBE -

FUNCTIONS - UPDATE OPERATIONS - QBE DICTIONARY.

UNIT - 05

RELATIONAL ALGEBRA - UNION - INTERSECT - DIFFERENCE - CARTESIAN - RELATIONAL

CALCULAS - QUEL - NORMALIZATION - 1NF - 2NF - 3NF - BOYCE CODE NF - 4NF - 5NF.

DMCA.com Protection Status