Course Title : Database Application Development
Course Code : SSK3408
Credit : 4(3+1)
Contact Hours : 1 x 3 hours of lecture per week
1 x 3 hours of practical per week
Semester : Semester I 2020/2021
Prerequisite : SSK3101
Instructor : Dr. Siti Nurulain Binti Mohd Rum
Objectives :
At the end of this course, students are able to:
1. design database. (C5)
2. develop database application. (P4)
3. work as a team in implementing a mini project. (A3, TS)
Synopsis :
This course covers the database design and development of application using relational database technology. Each step of the development, which consists of database design, queries, and application, will be studied. Current Database Management System software will be used. Practical works will be given as individual and in groups.
(Kursus ini meliputi reka bentuk pangkalan data dan pembangunan aplikasi menggunakan teknologi pangkalan data hubungan. Setiap langkah dalam pembangunan, yang terdiri daripada reka bentuk pangkalan, pertanyaan, dan aplikasi akan dikaji. Perisian Sistem Pangkalan Data terkini akan digunakan. Kerja amali akan diberikan secara individu dan berkumpulan).
Course Contents:
Topic
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,3,4
Database Design
Database Design Phases
Entity-Relationship (ER) Model
Transforming ERD into Relations
Normalization (1NF, 2NF, 3NF)
5,6
Structured Query Language
Introduction to Structured Query Language (SQL)
Data Definition Language
CREATE DATABASE
CREATE TABLE
ALTER TABLE
DROP TABLE
Data Manipulation Language
Insert
Update
Delete
Select
TEST 1 (Week 5 or 6)
7
Structured Query Language
§ SQL Operators
o AND, OR, =, != or <>, LIKE, IN, BETWEEN
§ Advanced Queries – Calculation
o COUNT
o SUM
o AVG
o MAX
o MIN
§ Join Table
o JOIN – INNER JOIN
o SUBQUERIES
8
Transaction
§ Concurrent and multi-user access
§ ACID (Atomicity, Consistency, Isolation, Durability)
§ Batch Processing
9,10,11
Web-based Database Application Development
Web Application
HTML/CSS
Javascript
Java Server Page (JSP)
Connection to database
Transaction control
TEST 2 (Week 10 or 11)
12
Database Integrity
Stored Procedures
Data Triggers
13,14
Database Application Development Using Framework
Object-Relational database
Persistence for objects
Object-relational mapping framework
Spring MVC
Practical:
Lab. Activities
Lab 1
Introduction to Oracle and SQL Developer
Lab 2
SQL- Data Definition Language (Create, Alter, Drop, etc.)
Lab 3
SQL- Data Manipulation Language (Insert, Delete, Update, Select)
Lab 4
SQL- Advanced Select Statements
Lab 5
SQL- Advanced Select Statements
Lab 6
SQL - Join Tables
Lab 7
Database Programming with Java GUI– Client/Server Application
Lab 8
IDE- Spring Tool Suites
Lab 9
Simple JSP
Lab 10 - 13
Spring MVC
Lab 14
Stored Procedures and Data Triggers
Assessments:
1. Test 1 : 10%
2. Test 2 : 10%
3. Assignment : 5%
4. Practical : 15%
5. Group Project : 20%
6. Final Examination : 40%