Short course name:

Database Management Systems 1

Module number:

COM 105

Course Syllabus:

Review of Database Management Concepts

Logical database concepts; relational database characteristics; Codd's rules for relationality; normalizing database tables

Generic database architectures; N-tier designs and web/enterprise schemes

Review of data model and data dictionary generation methods

Database security management - users, groups, roles, system and object privileges

DBMS as Enterprise-Resource Planning (ERP) tools


Database Objects and Constraints

Table constraints - primary key, foreign key, null, unique, default and check column constraints

Creating table joins - equi, outer, inner, self and cartesian joins; using table aliases in joins

Creating views that use joins

Using indexes - binary tree versus bit-map indexes; index type selection based on column cardinality

Synonyms - creating cross-schema (public) and private synonyms

Using sequences for auto-generating column data; creating numeric and alphanumeric sequences.


Database SQL command basics

SQL, DDL, DCL and DML characteristics

Syntaxes and usage of prime SQL verbs: Create, Alter, Drop, Select, insert, update, delete, grant and revoke

Grouped and ordered queries

Command line interface (CLI) and Graphical User Interface (GUI) SQL environments

Implicit and explicit SQL cursors


Developing Database Applications

Bound versus unbound forms as application front-ends

Form objects and controls, canvases, data and code blocks

Form object triggers; event-driven programming

Introducing PL/SQL and T-SQL embedded program constructs

Generating Master-Detail forms and reports

Using explicit SQL cursors for transactional programming

Creating packages

Using record and list (LOV) objects in forms

Exceptions/run-time error handling processes

Generating parameterised reports

Creating customized menus for applications

Coding reusable elements – procedures and functions

Coding web accessed applications – basic requirement