Course Title: Database Systems

Course Code: CS 124

Credit Value: 3 Credits

Contact Hours

• Lectures: 2 hours/week

• Practical/Laboratories: 2 hours/week

Duration: 15 Weeks (One Semester)

Prerequisite: Introduction to Programming

Recommended: Discrete Mathematics

1. COURSE DESCRIPTION

This course introduces the fundamental principles of database systems, focusing on the design, implementation, and management of relational databases. Students learn how to model data, design relational schemas, write SQL queries, and understand how database management systems support data storage, retrieval, integrity, security, and transaction processing.

Hands-on laboratory sessions emphasize practical SQL skills using a relational DBMS and expose students to real-world database applications and design practices.

2. COURSE OBJECTIVES

By the end of this course, students should be able to:

1. Explain the purpose and components of database systems.

2. Design databases using conceptual and logical models.

3. Create and manipulate databases using SQL.

4. Apply normalization techniques to reduce redundancy.

5. Use database constraints to maintain integrity.

6. Understand transaction management and concurrency concepts.

7. Explain basic database security and backup mechanisms.

3. LEARNING OUTCOMES

Upon successful completion, students will be able to:

• Describe database concepts and architectures.

• Design Entity–Relationship (ER) diagrams.

• Implement relational schemas.

• Write SQL queries for data retrieval and manipulation.

• Apply normalization principles.

• Use constraints and views effectively.

• Explain transactions and ACID properties.

• Apply basic database security principles.

• Use DBMS tools proficiently.