Description

The course covers topics related to the analysis, design, and normalization of relational databases. Case studies are analyzed and discussed on each concept. Hands on implementation skills using SQL are covered including data definition, data modification, SQL queries and subqueries. Implementation skills are practiced on ORACLE database management system. Advanced topics such as concurrent transactions are discussed along with related problems. Students also learn about additional Data Bases support for special data types such as Extensible Mark-Up Language (XML) documents.

Program

Information Systems (2021)

Objectives

• 1. Understand the fundamental concepts of database and database management systems, and historical roots of database.
  2. Understand conceptual database design using Entity-Relationship modeling.
  3. Understand database design methodology using normalization.
  4. Design a database system for a real-world problem.
  5. Learn about SQL data modification and data definitions.
  6. Write SQL queries and sub queries.
  7. Implement and verify a database system using ORACLE.