DATABASE (WBL) - COURSE INFORMATION

Course Description

Welcome to the Database Management course! In this course, you will learn the fundamental concepts, principles, and techniques of managing and working with databases. Databases are essential for storing, retrieving, and organizing data in various applications, and this course will provide you with a solid foundation in designing, implementing, and maintaining databases.

Course Details

• Course Code: SECP2523 - SECTION 1
• Instructor: ROZILAWATI BINTI DOLLAH @ MD ZAIN
• Credits: 3
• Prerequisites: Basic understanding of computer science and programming
• Format: In-person lectures, hands-on lab sessions, assignments, and a final project

Learning Objectives

By the end of this course, you will be able to:

1. Understand the fundamental concepts of databases and their role in modern applications.
2. Design and model relational databases using Entity-Relationship (ER) diagrams.
3. Implement and manage databases using Structured Query Language (SQL).
4. Explore database normalization techniques to eliminate data redundancy and improve data integrity.
5. Utilize advanced SQL queries to retrieve and manipulate data.
6. Gain insights into transaction management and database security.
7. Work with real-world database management systems (DBMS) and tools.

Course Outline

1. Introduction to Databases

   • Overview of databases and their applications
   • Database management systems (DBMS) and their features
   • Types of databases: relational, NoSQL, and more

2. Data Modeling and Design

   • Entity-Relationship (ER) modeling
   • Attributes, keys, and relationships
   • Normalization: 1NF, 2NF, 3NF, and beyond

3. SQL Fundamentals

   • Basic SQL queries: SELECT, INSERT, UPDATE, DELETE
   • Filtering and sorting data
   • Joins, subqueries, and aggregate functions

4. Advanced SQL

   • Indexing and optimization
   • Views and stored procedures
   • Triggers and user-defined functions

5. Transaction Management

   • ACID properties of transactions
   • Concurrency control and isolation levels
   • Handling deadlocks and data consistency

6. Database Security

   • Authentication and authorization
   • Role-based access control
   • Encryption and data masking

7. NoSQL Databases

   • Introduction to NoSQL databases
   • Types of NoSQL databases: document, key-value, column-family, graph
   • Comparing NoSQL and relational databases

8. Database Administration

   • Backup and recovery strategies
   • Performance monitoring and tuning
   • Database maintenance and optimization

9. Final Project

   • Design and implement a database for a specific application
   • Project proposal, schema design, and implementation

Assessment and Grading

• Participation: 10%
• Assignments: 30%
• Midterm Exam: 20%
• Final Project: 40%

Recommended Resources

• Textbook: "Database Systems: Design, Implementation, and Management" by Carlos Coronel, Steven Morris, and Peter Rob
• DBMS: MySQL, PostgreSQL, MongoDB (for NoSQL)