Official government website of the Government of Kingdom of Saudi Arabia
Link to official Saudi websites end with edu.sa

All links to official educational websites in the Kingdom of Saudi Arabia end with sch.sa or edu.sa

Government websites use the HTTPS protocol for encryption and security.

Secure websites in the Kingdom of Saudi Arabia use the HTTPS protocol for encryption.

Registered with the Digital Government Authority under number:

20250417892
Main
UQU Programs
Computer Science

Introduction to Database

DS2201
3 hours English

Introduction to Database

Introduction to Databases
1 Introduction to Databases
2 Database Systems Concepts and Architecture
3 Database Design and Entity-Relationship (ER) Modeling
4 Relational Database Model: Schema and Integrity
5 The Relational Algebra
6 Functional Dependencies and Normalization
7 SQL Basics: Queries, Data Definition, and Manipulation
8 Advanced SQL: Joins, Subqueries, and Views
9 SQL: Integrity Constraints
10 Indexing and Query Optimization
11 Transactions, Concurrency Control, and Recovery
12 Database Security and Backup Strategies
13 NoSQL Databases Overview
14 Emerging Trends: Cloud Databases and Big Data Integration
15 Project Presentation and Discussion
1.1 Mapped to: K1

Describe the differences between a relational database and flat files.

Teaching Strategy Lectures, interactive discussions, guided readings
Assessment Methods Exams, quizzes, participations
1.2 Mapped to: K1

Model data using ER and UML diagrams and derive relational schemas.

Teaching Strategy Lectures, lab exercises, project-based learning
Assessment Methods Lab projects, quizzes, exams, participations
1.3 Mapped to: K1

Apply normalization concepts to improve database designs.

Teaching Strategy Lectures, hands-on lab activities, case studies
Assessment Methods Assignments, exams, participations
2.1 Mapped to: S4

Design relational databases using modern tools and techniques

Teaching Strategy Guided exercises, discussions on best practices, scenario-based problem solving
Assessment Methods Projects, lab assessments, exams
2.2 Mapped to: S4

Create and query databases using SQL commands.

Teaching Strategy Lab-based instruction, real-world SQL problems, individual assignments
Assessment Methods Projects, lab assessments, coding test, exams
2.3 Mapped to: S4

Optimize database performance through indexing and query optimization.

Teaching Strategy Guided exercises, discussions on best practices, scenario-based problem solving
Assessment Methods project evaluations, lab assessments, exams
3.1 Mapped to: V3

Collaborate effectively in teams to solve database-related challenges.

Teaching Strategy Group projects, peer review, collaborative lab exercises
Assessment Methods Group project evaluations, peer feedback
3.2 Mapped to: V3

Demonstrate responsibility in ensuring data integrity and security.

Teaching Strategy Case studies, ethical discussions, role-play scenarios
Assessment Methods Case study analysis, reflective essays
Assessment
Weight
Lab Exercises
20%
Midterm Exam
20%
Group Project
20%
Final exam
40%
Total
100%