INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

DATABASE ORGANIZATION

PRINCIPLES AND TECHNIQUES OF DATABASE DESIGN

  •  meaning
  • database design cycle

RELATIONAL DATABASE SYSTEM

  •  meaning of rational database system
  •  characteristics
  • relational algebra
  •  relational calculus

ENTITY RELATIONSHIP

  •  meaning of entity relationship
  •  connotations of entity relationship
  •  drawing ERDs

NORMALIZATION

  •  meaning and importance of normalization
  •  normalization rules
  •  performing normalization

QUERYING A DATABASE

  •  meaning of a database query
  •  features of SQL
  •  categories of SQL statements
  •  design SQL statements
  •  design SQL Queries
  •  use of SQL statements to interrogate a database

FUNCTION OF DATABASE MANAGEMENT SYSTEM


VISUAL PROGRAMMING IN Visual Basic

Course Outline

1.       INTRODUCTION TO VISUAL PROGRAMMING LANGUAGES à Example of Visual programming languages (Visual basic, Visual C++, Delphi), Hardware and software considerations for visual programming

2.       VISUAL ENVIRONMENT à Description of Visual Environment event driven environment, Description of Integrated development environment, Visual objects (types of controls, form window, properties window immediate window, code window, others) and Creating visual environment.

3.       PROGRAM STRUCTURE à Format of a visual program, Data types, Data operators (arithmetic, logical, comparison), Variable declaration

4.       PROGRAM WRITING à Program writing terminologies (Build, compile, debug, execute), practical work

5.       CONTROL STRUCTURES à Definition of control structures, Types of Control structure (sequence, selection and iteration/repetition) Implementation of control structures

6.       DATA STRUCTURES à Description of data structures, Types of data structures (1D and 2D arrays), Sort techniques (bubble and shell), Search techniques (binary search).

7.       ERROR HANDLING à Types of errors (syntax, run time, semantics & logical), Error handling techniques (writing error handlers, on error go to, on error resume, error object), debugging tools

8.       SUB-PROGRAMS à Description of Sub-programs, Types of Sub-programs (private sub-programs & public sub-programs), Scope of variables (local variables & global variables), Writing sub-programs

9.       LINKING TO DATABASES àDatabase controls (Data Control, MS Data bound Controls and Active Data Object (ADO)) Reports data report, Applying database control and Creating data report

10.   EMERGING TRENDS IN VISUAL PROGRAMMING àEmerging trends in visual programming, Challenges of emerging trends in Visual programming, coping with challenges of emerging trends in visual programming