Data Processing SSS 2 (1st Term)

Subject Description: Data Modeling and Database Design

Hours: 24 Hours Prerequisites: Data Processing SSS 1 (1st, 2nd and 3rd Term)

Subject Overview

This subject introduces students to the fundamental concepts of data modeling and database design essential for modern information systems. Students will learn to design, implement, and manage databases using industry-standard practices while working with real-world scenarios from social media, e-commerce, and digital platforms they use daily.

Learning Objectives

By the end of this subject, students will be able to:

• Understand and apply the three stages of data modeling (conceptual, logical, physical)
• Design normalized databases up to Third Normal Form (3NF)
• Create comprehensive Entity-Relationship (ER) diagrams
• Identify and implement various types of database keys
• Compare different data models and select appropriate solutions
• Build functional databases using Microsoft Access
• Generate meaningful reports and queries from database systems
• Apply database concepts to modern applications like social media, streaming services, and e-commerce platforms

Subject Topics

1. Introduction to Data Models - Types, stages, and significance
2. Database Management Systems - Components and user roles
3. Normalization - Eliminating redundancy and organizing data efficiently
4. Database Keys - Primary, foreign, composite, and candidate keys
5. Entity-Relationship Modeling - Designing database relationships
6. Practical Implementation - Hands-on database creation and management

Assessment Methods

• Hands-on Projects (50%) - Five major projects to pick one covering different aspects of database design using MS Access implementations of real-world scenarios
• Assignments (50%) - Follow up class works and assignments to reenfore learning
• Midterm CAs (40%) - Theoretical concepts and CBT
• Final Exam (60%) - Comprehensive dataprocessing exam to test mastery of the subject

Required Software

• Microsoft Access
• Materials and datasets provided via School's Online Education