Prerequisite: CSC 111, CSC 113, CSC 114
Definition of common related terms (database architecture. Condition for DBA). Database architecture. Condition for DBMS, Advantages and Disadvantages. Database environment (comparison of file & DB processing), unction of DBMS & DBA. Data dictionary details, scheme, subschema with examples. Functions of data definition language & data manipulation language. DB security, (Concurrent processing, lockouts, deadly/warm embrace, notification). DBM model & theory (DLI, DBTG, elational DB, properties of relations, functional dependence). Normal forms & normalization, Relational algebra & calculus models. Object databases polymorphism, data abstraction, advantages & disadvantages of object oriented database). Query languages design using SQL. Practical session: Assignment to create sequential, direct files using any of the following: ACCESS, ORACLE, FORTRAN, VB,BASIC, SQO.
This course shall be covered within 15 weeks of 3 hours per
week or 45 lecture hours in a semester. The overall assessment shall be on the basis of
continuous assessment (CA) and theoretical and practical exams.