Course Code  : SAK3408
Credit            : 3 (2 hours lecture + 1 practical slot (2 hours))
Prerequisite  : SAK3100
Instructor      : En. Fahrul Hakim Ayob (Call me En. Hakim pls)
room              : A 1.29 Blok A FSKTM Building
phone             : Ext 6542 and 012-6157432
venue             : Dewan Kuliah Utama (DKU) FSKTM building
lecture time time  : 12 - 1 p.m.  (Monday and Wednesday)
practical time  (3 slots)     : Monday (8-10p.m.) | Tuesday (4-6p.m.) | Thursday (10a.m. -12p.m)

Objectives :

1. Modeling problem using model data concept.
2. Design and develop a database application.

Synopsis :

This course covers the development of applications using relational database technology. Each step of the development, which consists of design, queries, application and administrations, will be studied. Practical works will be given.

Sinopsis
(Kursus ini meliputi pembangunan aplikasi menggunakan teknologi pangkalan data hubungan. Setiap langkah dalam pembangunan yang terdiri daripada reka bentuk, pertanyaan, aplikasi dan pentadbiran akan dikaji. Kerja amali akan diberikan)

Contents :

1. Introduction
- Database Definition, Database Management System (DBMS)
- Advantages of Database Management
- Environment of Database System
- Components of Database Management System
- Brief History of Database Management System

2. Database Design
- Database Design Stages
- Entity-Relationship (ER) Model
- Transforming ER into Relation
- Normalization

3. Query Language
- Introduction to SQL
- Data Definition Language(DDL)
- CREATE DATABASE
– CREATE TABLE
– ALTER TABLE
– DROP TABLE
- Data Manipulation Language(DML)
- SELECT
- UPDATE
- DELETE
- INSERT

4. Applications
- Effective Design of Reports and Forms
- Human Factors Design
- Windows Interface Standard
- Windows Control
- User Interface
- Ensure Data Integrity
- User Interface features

- Forms
- Form Layout
- Tabular form
- Single-row or Columnar form
- Sub form
- Switchboard form

- Reports
- Basic Report Types
- Tabular and Label Reports
- Groups or Subtotals
- Graphs

5. Programming Environment
- Data on Forms
- Data Controls
- Control Properties
- Internal Forms Commands

- Using Program to Retrieve and save data in the database
- Building SQL Statement with Code
- SQL Cursor Programming
 

6. Databases and Internet
- Client/Server Database
- Techniques for Connecting to a database server
- Web Application Deployment
 

7. Database Administration
- Database Administration
- Database Tasks by Development Stages
- Backup and Recovery
- Security and Privacy

Practical (Amali):

1. Create database and tables
2. SQL Query
3. Creating forms and data manipulation
4. Develop an application and transaction
5. Creating Reports
6. Database Application on Web
7. Security

Assessment :

 Test 1   : 10%
 Test 2   : 10%  -
 Practical (Amali/Project)   : 40% (maybe 50%)
 Final       : 40%  (30%)

Text Book :

1. Post, G.V. 1999, Database Management Systems: Designing and Building Business Application, McGraw Hill.

References :

2. Hoffer, J.A, Prescott, M.B, McFadden, F.R, 2002,  Modern Database Management. 6th Edition, Prentice Hall.
3. Connolly, T., 2002, Database Systems: A Practical Approach to Design, Implementation, and Management.
 

Nota: downloadable notes
 

chapter 1
chapter 2	chapter 2
chapter 3
chapter 4
chapter 5
chapter 6
chapter 7
chapter 8