SYLLABUS FOR DBMS & GUI

SYLLABUS FOR DATABASE MANAGEMENT SYSTEM and GRAPHICAL USER INTERFACE USING VISUAL BASIC 6.0

1. Data base concepts and, Systems


Introduction- Purpose of Database Systems, Views of data, Data Models, Database language, Transaction Management, Storage Management, Database Administrator, Database Users, Overall System Structure, Different types of Database Systems

2. E-R Model

BasIc Concepts, Design issues, Mapping Constraints , Keys, E-R Diagram, Weak Entity set, Extelided E-R features, Design Of an E-R Database Schema, Reduction of an E-R schema to Tables

3. Relational Model

Structure of Relationa! Database, The Relational Algebra, View's SOL Background, Basic Structure, SET operations, Aggregate functions, Null Values, Nested Sub queriE::s, Derived Relations Views. Modification of Database, Joined Relations, DOL, Other SOL features

4. Transaction

Transaction Concepts, Stdte, Impieinentations of Atolilicity and durability, Concurrent Executions, Serializability, Recoverabillty, Tracsact:on Definaton In SOL.

5. Concurrency Control Lock based protocol, Timestamp based protocol, Validation based protocol, Deadlock Handing, Insert and Delete operations, Concurrency in index structure

re classification, Recovery and Atomicity, Log based recovery, ShadowlFc1lU .


6.Recovery System

Failure classification , Recovery & atomicity, log based rec, Shadow paging

7 Graphical ,User Interface

MurphY 's Lavv of G U I Design, Features of G U I, Icons and graphics, identifying visual cues, clear communication, color selection, GUI standard, :);clnrling GUI Design \Alork.

8.Visual programming

Sharing Data and Code

. \'Jorking with Pr'ojects, introduction to Basic language, Using inbuilt controls ~-':ld AdveX controls, creating and using classes, Introduct:on to Collections, USing and creating ActiveX Components, dynamic data exchange, object !~:lking and embedding

Creating visual softvvo.;e entities

'I,'\/orking With text, graphics, working with files, file management, set ial :~ommunication, multimedia control interfaces,

Programming for the Internet

Using ,u,ctiveX controls on the web-the inlernet transfer control for HTTP, F'TP

D2tabase programming

~)ata basE:' basics, Visual Basic's database tools, Database designing and programming, DAO, RDO, ODBC,,ADO, OLE DB, Relat:onal databases, the Data Object ;v1ode!s, form and fields validation, Client Server Programming, COM-DCOM.