SOF202 Database

1. SOF202

Database
2025/09

2. Course Information

1.
Lecture Class : Monday (10:00AM – 12:00PM) A5#G01
2.
Lab (DSC Group 1): Thursday (6:00PM – 8:00PM) A1#G09
3.
Lab (DSC Group 2): Wednesday (6:00PM – 8:00PM) A1#109
4.
Lab (DSC Group 3): Wednesday (3:00PM – 5.00PM) A1#111
5.
Lab (DSC Group 4): Wednesday (1:00PM – 3:00PM) A1#109

3. Course Teaching Lecturer

• Dr. Azmi Bin Mohd. Yusof
• Email : azmi.mohdyusof@xmu.edu.my
• Office: A1 – 348
Email : subashini.ganapathy@xmu.edu.my
Dr. Subashini A/P Ganapathy
Office: A1 - 414

4. Moodle & Teams Enrollment

Moodle & Teams Enrollment
• 1. Search for SOF202 Course
SOF202 Database 2025/09 - Dr Azmi Mohd Yusof

5. Course Objective

Learn the key ideas and tools for designing and managing databases, from
diagrams and normalization to writing SQL queries.
Work together in teams to solve real problems by applying database concepts
and using DBMS features like transactions, fault recovery, and concurrency control.

6. Specific Objectives

1. Create data models and database designs for applications using
E-R diagrams.
2. Apply normalization to build schema designs.
3. Use SQL to develop database applications.
4. Manipulate data by defining schemas, tables, indexes, and
views, and write complex queries.
5. Apply DBMS transaction features to ensure fault recovery and
concurrency control.

7. Topics covered

1. General
Introduction
2. Relational
Model
3. SQL
4. Database
Security
5. Database
Integrity
6. Relational
Database
Theory
7. Relational
Database
Design
8. Query
Processing
and
Optimization
9. Database
Recovery
10.
Concurrency
Control

8. Course Learning Outcomes

CLO1: Describe the basic theories (relational algebra, database
architecture, normalization and query optimization theories, etc..)
to support the designing of database.
CLO2: Demonstrate teamwork for solving problem using database
concepts.
CLO3: Use E-R diagram to model the database, transaction features
and of DBMS to achieve fault recovery and concurrency control.
CLO4: Construct SQL statements to define and manage (query and
update) relational database for given problem.

9. Assessment Methods (2025/09)

Continuous Assessment (Grouping)
Percentage
Assignment
20%
Lab Report
30%
Final Assessment (Individual)
Percentage
Examination
50%
Important:
You have to pass all the assessment in order to pass the overall
course (Triple Pass Grading System)
Minimum 40
Marks for each
assessment, but
in overall shall get
55%

10.

Assessment Mapping
Knowledge
and
Understanding
Interpersonal
Skills
Cognitive
Skills

11.

Other
Programme
Learning Outcome
(PLO)

12. Software Reference

My SQL
MySQL :: MySQL Downloads

13. Course References

• Hoffer, J. A., Venkataraman, R., & Topi, H. (2025). Modern database
management (14th ed.). Pearson.
• Kroenke, D. M., & Auer, D. J. (2024). Database concepts (10th ed.).
Pearson.
• Jukic, N., Vrbsky, S., & Nestorov, S. (2016). Database systems:
Introduction to databases and data warehouses (2nd ed.). Prospect
Press.

14.

Link to Group Assessment Name List
(Assignment + Lab Report)

15. Phases of Database Design

Assignment
Requirement
Analysis
Lab Report
Logical Design
• Map to
relational
schema,
apply
normalization
• Identify user
needs and
data
requirements
Implementation
• Build database
using SQL.
Conceptual
Design
Physical
Design
• Create
high-level
model
(e.g., E-R
diagram).
• Decide
storage,
indexing, and
performance
setup.
Maintenance
• Test,
optimize,
and update
the
database.