Database Systems

  • Information Systems |
  • English

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.

Textbook

Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, Database Systems: The Complete Book, Prentice Hall

Course Content

content serial Description
1Course Description and Introduction
2The Entity Relationship Model
3The Entity Relationship Model continued
4Constraints in ERMs
5The Relational Model
6Case Study
77th Week Examination
8Normalization
9SQL and Relational Algebra
10SQL and Relational Algebra continued
11SQL DDL and DML
1212th Week Examination
13SQL Queries and Sub Queries
14SQL Queries and Sub Queries continued
15Revision
16Final Examination

Markets and Career

  • Generation, transmission, distribution and utilization of electrical power for public and private sectors to secure both continuous and emergency demands.
  • Electrical power feeding for civil and military marine and aviation utilities.
  • Electrical works in construction engineering.
Courses
  • Degree Bachelor
  • Code: IS273
  • Credit hrs: 3
  • Prequisites: CS143
Download.pdf
Apply Now

Start your application

Start The your journey to your new career.
SUBMIT IT NOW