GUI AND DATABASE MANAGEMENT

GUI AND DATABASE MANAGEMENT

1. Data base concepts and Systems
 Introduction – Purpose of Database Systems, Views of data, Data Models, Databas
language, Transaction Management, Storage Management, Database Administrato
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, Extended E-R features, Design of an E-R Database Schema,
Reduction of an E-R Schema to Tables

3. Relational Model

Structure of Relational Database, The Relational Algebra, Views SQL-
Background, Basic Structure, SET operations, Aggregate functions, Null Values,
Nested Sub queries, Derived Relations, Views, Modification of Database, joined
Relations, DDl, Other SOL features.

4. Transaction

Transaction Concepts, State, Implementations of Atomicity and durability,
Concurrent Executions, Seriability, Recoverability, Transaction Definition in SQL.

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


6. Recovery system

Failure classification, Recovery and Atomicity, Log based recovery, Shadow paging.

7.   Murphy’s Law of GUI Design, Features of GUI, Icons and graphics, Identifing visual
cues, clear communication, color selection, GUI standard, planning GUI Design Work.

8.   Visual programming

Sharing data and code

Working with Projects, Introduction to Basic language, Using inbuilt controls and
ActiveX controls, creating and using classes, Introduction to Collections, Using
and creating ActiveX Compliments, dynamic data exchange, object linking and
embedding

Creating visual software entities

Working with text, graphics, working with files, file management, serial
communication, multimedia control interfaces.

Programming for the Internet 
Using ActiveX controls on the web-the internet transfer control for HTTP, FTP

Database programming

Data base basics, Visual Basic’s database tools, Database designing and
programming. DAO, RDO, ODBC, ADO, OLE DB, Relational databases, the
Data Objects Models, form and fields validation, Client Server Programming,
COM-DCOM


Text Book

1. An Introduction to Database System, C.J. Pearson Education 
2. Database System and concepts, Henry F. Korth, Sliberschatz, Sudarshan,
McGraw Hill
3. GUI Design for dummies,IDG books.
4. Visual Basic 2005, How to program (3RD Edition) Deitel & Deitel, Pearson
Education
5. Microsoft SQL Server 2000 Bible, Wiley
6. BATER, MS SQL SERVER 2005 EXPRESS IN 24 HOURS, Pearson
Education


Reference:
1.  Beginning SQL Server 2000 for Visual Basic Developers Willis theraron
Shroff publishers and distributors 
2.  Fundamental of Database Systems, Elmasri & Navathe Pearson
Education.
3.  Database Management Systems  Mujumdar / A.K. Bhatacharya, Tata Mc.
Graw Hill.