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
Health Informatics

Healthcare Database Management Systems

DS3021
3 hours English

Healthcare Database Management Systems

Healthcare Database Managment system
1 Introduction to Database Management systems with an emphasis on the importance of DBMS in healthcare setting: / Databases, database users, system concepts, and Architecture
2 Data Modeling: Entity Relationship Diagram with healthcare examples
3 ERD to enhanced-ER (EER) data model and EER diagrams with healthcare examples
4 Basics of Functional Dependencies and Normalization for Relational Databases: / Database Normalization: 1NF, 2NF, 3NF, BCNF
5 Relational operations queries: / Algebra Operations / Basic SQL queries / Advance SQL queries
6 Relational Database Design by ER- and EER-to-Relational Mapping / Steps of an algorithm for ER-to-relational mapping
7 Database Programming Techniques: / Brief introduction on SQL Programming Techniques / Brief introduction on Web Database Programming Using PHP / Brief introduction on Object and Object-Relational Databases / Brief introduction on XML: Extensible Markup Language
8 File Structures, Hashing, Indexing, and Physical Database Design
9 Brief introduction on Distributed Databases, NOSQL Systems
10 Brief introduction on Database Security
1.1 Mapped to: K1

Describes database management system

Teaching Strategy Interactive academic lectures Class and group discussions
Assessment Methods Examination
1.2 Mapped to: K1

Enumerate the advantages of using database management systems in healthcare

Teaching Strategy Interactive academic lectures Class and group discussions
Assessment Methods Examination
1.3 Mapped to: K1

Explains Database Programming Techniques

Teaching Strategy Interactive academic lectures Class and group discussions
Assessment Methods Examination
2.1 Mapped to: S1

Creates Entity Relationship Diagram in healthcare

Teaching Strategy Practical sessions
Assessment Methods Examination
2.2 Mapped to: S1

Writes SQL queries

Teaching Strategy Practical sessions
Assessment Methods Practical Exam
2.3 Mapped to: S1

Differentiate between ER and Normalization in relational model construction

Teaching Strategy Interactive academic lectures Individual and group case studies Class and group discussions Practical sessions
Assessment Methods Examination
2.4 Mapped to: S1

Design a Relational Database Model in healthcare

Teaching Strategy Practical sessions
Assessment Methods Examination
3.1 Mapped to: V1

Complete the required tasks on time independently

Teaching Strategy Textbook and research literature readings Class and group discussions
Assessment Methods Assignments Student projects
Assessment
Weight
Quiz
10%
Mid Term Exam
20%
Assignments
10%
Student projects
10%
Practical Exam
10%
Final Exam
40%
Total
100%