Module Database Form 4 2023
Introduction to Database
Instructor: Ts. Syahrul Affendi Bin Abdul Rahman
Overview
Key Topics:
Role of Data
Data and Information
Data Management:
Manual Processing System
File System
Database System
Data Integrity, Consistency & Redundancy
Database Definition
Database: A computer-based information system used for storing, accessing, and updating data.
Data vs Information
Data: Raw, unorganized facts needing processing.
Information: Data that has been processed to be meaningful.
Data Management Methods
Manual Processing System
File System
Database System
Importance of Data Management
Benefits:
Increased Productivity
Cost Efficiency
Enhanced Operational Agility
Reduces Security Risks
Decreases Data Loss
Enhances Decision Accuracy
Data Integrity, Consistency & Redundancy
Data Integrity: Assurance that information is uncorrupted and accessible only to authorized users.
Data Consistency: Ensures data remains unchanged over time, regardless of access frequency.
Data Redundancy: Same data stored in multiple locations, often problematic.
Database Systems Overview
DBMS vs File System:
DBMS: Collection and retrieval of data, providing an abstract view.
File System: Isolates data and is limited in data management capabilities.
Database Models
Types of Models:
Hierarchical Model
Network Model
Relational Model
Object-Oriented Model
Entity Relationship Diagram (ERD)
Purpose: Visual representation of entities and relationships within a system.
Components: Entities, attributes, relationships, and cardinality.
Activities
Group activities to create ERD for various systems (e.g., Library System, Human Resource System).
Class activity: Create ERD for School Information System.
Review & Assessment
Quizzes and Exercises:
Assess understanding of database concepts and models through quizzes.
Key Terminology: Entity, Attribute, Relationship, Cardinality.