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 a 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

IS -132 CRs

Objectives

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

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
3Constraints in ERMs
4The Relational Model
5SQL and Relational Algebra
6SQL DDL and DML
7SQL Queries and Sub Queries
8Functional Dependencies and Normalization part 1
9Functional Dependencies and Normalization part 2
10Semi-Structured Data and XML part 1
11Semi-Structured Data and XML part 2
12Transaction Management part 1
13Transaction Management part 2
14Projects Discussion
15Revision

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: CIS2101
  • Credit hrs: 3
  • Prequisites: CCS1302
Download.pdf
Apply Now

Start your application

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