problems, Organisation of Database, Components of Database ManagementSystems, Data Models, Database Architecture, Schema, Entity Relation model, dataflow diagram
File organization – Serial, Sequential, Indexed Sequential, Creation and Manipulation ofIndexed Sequential files, Hashing, Key to address transformation, overflow management in hashed files, B-Tree based files
Hierarchical Model, Network Model, Database Architecture, Data modelling,data definition, data dictionary, data manipulation, Database administration function, Data Security, back up andrecovery
Basic definition and terminology, Codd’s 12 rules for relational database management,Relational Algebra, Relational Calculus, Operations in Relational Model.
integrity constraints, functional dependencies, normalization, second and thirdnormal form, boyce – codd normal form, multivalued dependencies and fourth normal form, join dependencies and fifth normal form.
the database language, Simple queries in SQL, Products & Joins in SQL, Database modification in SQL,View definition, constraints, triggers in SQL
Transaction processing, Concurrency control, locking techniques, database back up andrecovery, database security issues, access control, authorization, Distributed databases
Oracle client, Oracle forms, Oracle reports, Oracle office, SQL +, Simple application usingOracle database.