KOLEJ VOKASIONAL _____________ LOGO KOLEJ

JABATAN TEKNOLOGI MAKLUMAT

PERANCANGAN KURSUS
COURSE OUTLINE

MAKLUMAT KURSUS (COURSE INFORMATION)

SEMESTER/TAHUN (SEMESTER/YEAR) : SEMESTER 2 TAHUN 1

KOD KURSUS (COURSE CODE) : DKA2233

NAMA KURSUS (NAME OF COURSE) : DATABASE

BEBAN AKADEMIK PELAJAR (STUDENT ACADEMIC LOAD) :

Kategori Aktiviti / Jumlah Jam /

Aktiviti Pembelajaran / Learning Activity
Category of Activities Total Hours
Kuliah / Lecture 14.00
Pembelajaran Berpandu /
Tutorial / Tutorial 14.00
Guided learning
Amali / Practical 42.00
Persediaan Kuliah, Tutorial dan Amali / Preparation for
17.50
Pembelajaran Kendiri / Self Lecture, Tutorial and Practical
learning Ulangkaji / Revision 17.50
Persediaan Penilaian / Preparation for assessment 8.00
Penilaian Rasmi / Formal Pentaksiran Berterusan / Continuous assessments 5.00
assessments Penilaian Akhir / Final examination 2.00
Jumlah SLT/ Total SLT 120
Nilai Kredit/ Credit Value 3

Kursus Pra-syarat (Pre-requisite Course) : None

Nama Pensyarah (Name of Lecturer) :

Disediakan oleh (Prepared by): Disahkan oleh (Approved by):

Tandatangan (Signature): Tandatangan (Signature):

Nama (Name): Nama (Name):

(PENYELARAS KURSUS) (KETUA PROGRAM/KETUA JABATAN)

Tarikh (Date): Tarikh (Date):

DKA2233 1
MATLAMAT (GOALS):

To expose students to database development using database programming techniques emphasizing database
structures, modeling, and database access.

SINOPSIS (SYNOPSIS):

This course will cover the various ways information can be stored in databases, and then concentrate on the structure
and manipulation of relational databases. Student will learn and have lots of practice with SQL, Structured Query
Language for creating databases, adding information, updating data, and for querying the database for subsets of
matches and for summary information.

HASIL PEMBELAJARAN (LEARNING OUTCOMES):

Upon completion of the course, students will be able to:

1. Apply current database programming languages to real life. (C3, PLO1, C1)
2. Manipulate data using database programming languages. (P3, PLO2, C3a)
3. Comply with database programming languages standard professionally. (A2, PLO6, C4a)

ISI KANDUNGAN (CONTENT):

MINGGU KANDUNGAN PENTAKSIRAN

(WEEK) (CONTENT) (ASSESSMENT)

DKA2233 2
1–4 1.0 Introduction to Database Programming
● Written Test
1.1 Introduction to Database Programming
1.1.1 Overview of latest Database Programming
1.1.2 History
1.1.3 Basic of RDBMS Concepts
(a) Relational Databases
(b) Entity-relationship Diagram (ERD
(c) Database Normalization
1.1.4 Types of Commands
(a) Data Definition Language (DDL)
(b) Data Manipulation Language (DML)
(c) Data Control Language (DCL)
(d) Data Query Language (DQL)
(e) Transactional Control Commands

1.2 Create and Manage Tables using DDL

1.2.1 Create a Table
(a) Naming
(b) Field
(c) Record/Row
(d) Column
(e) Primary Key
(f) AUTO_INCREMENT
(g) NULL Value
(h) Constraints
(i) Data Types
1.2.2 CREATE TABLE Statement
1.2.3 Create table from an existing table
1.2.4 Review Table Structure
1.2.5 ALTER TABLE Statement
1.2.6 DROP TABLE Statement

DKA2233 3
 5 – 10 2.0 Manipulating Data
● Practical Test
2.1 Manipulating Data Using DML and Transactional
Control Commands
2.1.1 INSERT Statement
2.1.2 Inserting data from another table
2.1.3 UPDATE Statement
2.1.4 DELETE Statement
2.1.5 TRUNCATE TABLE Statement
2.1.6 COMMIT Command
2.1.7 ROLLBACK Command

2.2 Retrieving Data Using SELECT Statement

2.2.1 SELECT statement
(a) DISTINCT Clause
(b) WHERE Clause
(c) AND and OR Clause
(d) IN Clause
(e) BETWEEN Clause
(f) LIKE Clause
(g) ORDER BY Clause
(h) GROUP BY Clause
(i) COUNT Clause
(j) HAVING Clause
(k) Operators
(l) Expressions

11 – 14 3.0 Customize Output and Displaying Data

● Portfolio
3.1 Using Functions to Customize Output
3.1.1 Various Types of Functions
(a) Aggregate Functions
(b) Scalar Functions
(c) Date Functions

3.2 Displaying Data from Multiple Tables

3.2.1 JOIN Types
(a) INNER JOIN
(b) LEFT JOIN
(c) RIGHT JOIN
(d) FULL JOIN

15 STUDY WEEK

16-17 FINAL EXAMINATION WEEK

AMALI (PRACTICAL):

1. Manipulate data using database programming languages.

DKA2233 4
PENILAIAN (ASSESSMENT):

CLO Min
Type of Sub
No CLO1:C3,PLO1 CLO2:P3,PLO2 CLO3:A2,PLO6 Total Passing
Assessment Total
(Cognitive) (Psychomotor) (Affective) Marks
Continuous Assessment
Written Test 20% 20%
1 60% 24%
Practical Test 25% 25%
Portfolio 15% 15%

Final Examination
2 40% 16%
Practical 40% 40%
Total Mark (CLO) 20% 65% 15% 100% 40%

Assessment Specifications Table (AST):

ASSESSMENT
METHODS FOR
COURSEWORK (CA)
CLO
PRACTICAL
WORK

WRITTEN TEST
(RUBRIC)

PRACTICAL
CLO2 (Psychomotor)

CONTEXT
CLO1 (Cognitive)

CLO3 (Affective)

TEST

20% 25% 15%

1.0 Introduction to Database

Programming
2.0 Manipulating Data
3.0 Customize Output and Displaying
Data

Remark:
1. Suggested time for
 Written Test : 60 minutes
 Practical Test : 120 minutes
 Portfolio : 120 minutes
2. 40 Notional hours is equivalent to 1 credit.

DKA2233 5
RUJUKAN (REFERENCES):
MAIN REFERENCE:
1. Josephine Bush (2020). SQL Database Programming: Published by Packt Publishing Ltd.
2. Walter Shields (2019). SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and
Manipulating Data With SQL. Published by ClydeBank Media LLC.
3. James Howard (2023). SQL: The #1 Crash Course for Beginners to Master SQL Programming Quickly With 40
Hands-On Exercises (Computer Programming). Published by Independently published

EXTRA REFERENCES:
1. W3Schools Online Web Tutorials. (n.d.). Https://Www.W3schools.Com. Retrieved February 23, 2021, from
https://www.w3schools.com.
2. Essential SQL for the beginners. (2020, April 04). Retrieved February 23, 2021, from
https://www.sqltutorial.org/
KEHADIRAN/PERATURAN SEMASA KULIAH (LECTURE ATTENDANCE/REGULATION):
1. Pelajar mesti hadir tidak kurang dari 80% masa pertemuan yang ditentukan bagi sesuatu kursus.
Students must attend lectures not less than 80% of the contact hours for every course.

2. Pelajar yang tidak memenuhi perkara (1) di atas tidak dibenarkan menghadiri kuliah dan menduduki sebarang
bentuk penilaian selanjutnya. Markah sifar (0) akan diberikan kepada pelajar yang gagal memenuhi perkara
(1).
Students who do not fulfill (1) will not be allowed to attend further lectures and sit for any further
examination. Zero mark (0) will be given to students who fail to comply with (1).

3. Pelajar perlu mengikut dan patuh kepada peraturan berpakaian yang berkuatkuasa dan menjaga disiplin diri
masing-masing untuk mengelakkan dari tindakan tatatertib diambil terhadap pelajar.
Students must obey all rules and regulations of the university and must discipline themselves in order to avoid
any disciplinary actions against them.

4. Pelajar perlu mematuhi peraturan keselamatan semasa proses pembelajaran dan pengajaran.
Student must obey safety regulations during learning and teaching process.

MATRIK HASIL PEMBELAJARAN KURSUS DAN HASIL PEMBELAJARAN PROGRAM

(MATRIX OF COURSE LEARNING OUTCOMES AND PROGRAMME LEARNING OUTCOMES)

Dilampirkan (As attached).

DKA2233 6
 MATRIK HASIL PEMBELAJARAN KURSUS DAN HASIL PEMBELAJARAN PROGRAM
MATRIX OF COURSE LEARNING OUTCOMES AND PROGRAMME LEARNING OUTCOMES

Nama PPT (PPT Name) : Kolej Vokasional ............, Kementerian Pendidikan Matrik ini perlu digunakan bersama:
(This matrix is to be used with)
Program (Programme) : Diploma Teknologi Komputeran 1. Objektif Pendidikan Program (PEO)
(Programme Educational Objectives (PEO))
Kod Kursus (Course Code) : DKA2233 2. Hasil Pembelajaran Program (PLO)
(Programme Learning Outcomes (PLO))
Nama Kursus (Course Title) : DATABASE

Pemetaan kepada PLO

Kaedah Kaedah
Hasil Pembelajaran Kursus (CLO) PLO1 PLO2 PLO3 PLO4 PLO5 PLO6 PLO7 PLO8 PLO9 PLO10 PLO11 KPI
Penyampaian Pentaksiran
1 Apply current database programming Lecture, Written Test
languages to real life. (C3, PLO1, C1) C3 Tutorial
2 Manipulate data using database Practical, Practical Test, 100% students
programming languages. (P3, PLO2, C3a) P3 Demonstration Final obtained 50%
Examination marks and
3 Comply with database programming Case Study, Portfolio above
languages standard professionally. (A2, Project,
A2
PLO6, C4a) Tutorial, Group
Work, SCL, Lab
Total 20% 65% 15%

DKA2233 7
 PEMETAAN PLO – MQF2.0 LOD – MBOT LOD LEVEL OF LEARNING TAXONOMY

MQF2.0
PROGRAMME MBOT
LEARNING
LEARNING OUTCOME LEARNING OUTCOME COGNITIVE PSYCHOMOTOR AFFECTIVE
OUTCOME DOMAIN
(PLO) DOMAIN
(LOD)
PLO1 Pengetahuan & C1 Knowledge & MBOT1 Knowledge (Cognitive C1 Remember P1 Perception A1 Receiving
Kefahaman Understanding Domain) C2 Understand P2 Set A2 Responding
C3 Apply P3 Guided Response A3 Valuing
PLO2 Kemahiran praktikal C3a Practical Work Skills MBOT2 Practical Skills/Modern
C4 Analyze P4 Mechanism A4 Organising
Tool Usage/DigitalSkills
C5 Evaluate P5 Complex Overt Response A5 Internalising
(Psychomotor Domain)
C6 Create P6 Adaptation
PLO3 Kemahiran Saintifik & C2 Cognitive Skill MBOT3 Analytical, Critical P7 Origination
Penyelesaian masalah Thinking, Design Thinking and
Scientific Approach/Numeracy
Skills (Cognitive Domain)
PLO4 Kemahiran C3c Communication Skills MBOT4 Communication Skills
berkomunikasi (Affective Domain)
PLO5 Kemahiran Sosial & C3b Interpersonal Skills MBOT5 Social And Responsibility
Kerja Berpasukan In Society And Technologist
Community (Affective Domain)
PLO6 Kemahiran Personal C4a Personal Skills MBOT6 Lifelong Learning And
Information
Management/Personal Skills
(Affective Domain)

PLO7 Kemahiran C4b Entrepreneurship Skills MBOT7 Technoprenuership And

Keusahawanan Management Skills (Affective
Domain)
PLO8 Etika & Profesionalisme C5 Ethics and MBOT8 Ethics And
Professionalism Professionalism (Affective
Domain)
PLO9 Kepimpinan, Autonomi C3f Leadership, Autonomy MBOT9 Teamwork And
& Tanggungjawab and Responsibility Skills Leadership (Affective Domain)
PLO10 Kemahiran Digital C3d Digital Skills MBOT2 Practical Skills/Modern
Tool Usage/DigitalSkills
(Psychomotor Domain)
PLO11 Kemahiran Numerasi C3e Numeracy Skills MBOT3 Analytical, Critical
Thinking, Design Thinking and
Scientific Approach/Numeracy
Skills (Cognitive Domain)

DKA2233 8
DKA2233 9