DATABASE TECHNOLOGY (3 SCU)

Learning Outcomes:

Upon successful completion of this course, students are expected to analyze requirements and anomalies in relational database design; use conceptual modeling mechanisms to design a database system; formulate queries for specific users’ information needs; use SQL as a data definition and data manipulation language; apply transaction processing and concurrency in multi-user database systems to obtain accurate results; design and create an information system project using SQL and visual programming; formulate NoSQL database; and describe the requirements of a Cloud Computing database.

Topics:

This course is designed to teach students the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. It introduces students to the relational model of databases along with its mathematical background, the application of relational database system and the system-level implementation, including File Organizations and Indexes, query processing, and transaction management.

Prerequisite(s): None