ITGS228 : Introduction to database

Department

Department of Information Systems

Academic Program

Bachelor in Information Systems

Type

General

Credits

03

Prerequisite

ITGS217

Overview

This course introduce the fundamentals of database management system characteristics of DB approach, components of DB systems, DB architecture, Data modeling, Database users and administrators. Entity-Relationship model, Relational-Algebra, SQL Programming, Database design, Functional dependency and Normalization, Relational Database, Introduction to Object oriented database and UML, practical applications using a standard Relational DB system.

Intended learning outcomes

Knowledge &understand

  • The student remembers the database and the database management system and lists the uses of the database.
  • The student learns how to analyze the requirements to access the database using the ERD relational model.
  • The student draws these analyzed requirements through the use of Chen symbols in the ERD relational model.
  • The student converts these symbols into database properties, relationships, and tables.
  • The student learns how to analyze the requirements to access the database using normalization (simplification).
  • The student decomposes these requirements into properties using functional dependencies.
  • The student converts these properties into database tables using the four normalization formulas 0NF, 1NF, 2NF, and 3NF.
  • The student learns about relational algebra and how to deal with data in database tables theoretically.

mental skills

  • The student proposes a set of requirements.
  • The student analyzes requirements using Chen symbols in the relational model.
  • The student infers a set of properties, relationships, and tables.
  • The student analyzes the requirements using functional dependencies in the slightest normalization.
  • The student derives a set of properties, relationships, and tables using the four normalization formulas.
  • The student compares the relational model method with the normalization formulas.

Practical & professional skills

  • The student distinguishes the requirements through forms, reports, statements and texts.
  • The student uses the requirements to extract properties, relationships and tables in one of the two ways (relational model - normalization formulas).
  • The student should design a correct database.
  • The student performs a set of theoretical operations on the data inside the tables using relational algebra

General and transferable skills

  • The student is able to solve problems related to database design.
  • The student is able to use Chen symbols or normalization formulas in design.
  • The student is able to use any other symbols such as UML in the design.
  • The student is able to team work in designing a database.
  • The student is able to manage time when using one of the two design methods.
  • The student is able to communicate with institutions wishing to design a database for them.

Teaching and learning methods

  • Lectures
  • Tutorials
  • Solve some models
  • Labs

Methods of assessments

  • Midterm1 exam = 25
  • Midterm2 exam = 25
  • Practical exam = 15
  • Final exam = 35

Course contents

  • Database System
  • Database Structure
  • Data Models
  • Structure Of The Relational Model, Relational Keys, And Integration Constraints
  • Interpretation Of The Entity-Relationship Diagram, Pluralism, Participation And Origin Constraints
  • Entity, Property, And Relationships In An ERD Diagram - 1:1 Relationship And 1:N Relationship
  • Entity, Property, And Relationships In An ERD Diagram - The N:M Relationship And The Circular Relationship
  • Converting The Chart Using The Ten Conversion Rules - Part 1
  • Schema Transformation Using The 10 Transformation Rules - Part Two
  • Functional Dependency In Normalization
  • Determine The Primary Key Using Functional Dependencies
  • First And Second Normalization Formulas
  • The Second And Third Normalization Formulas
  • Relational Algebra

Information Retrieval Systems (ITIS401)
Knowledge Management (ITIS402)
Data Mining/Business Intelligence (ITIS404)
Business Process Management (ITIS405)
Decision support system (ITIS406)
IS Innovation and New Technologies (ITIS407)
E-Government (ITIS408)
Physics (ITPH111)
Mathematics I (ITMM111)
Arabic language 1 (ITAR111)
Problem solving Technic (ITGS113)
Intro to Information Technology (ITGS111)
General English1 (ITEL111)
Mathematics II (ITMM122)
logic Circuit Design (ITGS126)
System Analysis and Design (ITGS124)
Introduction to Programming (ITGS122)
General English2 (ITEL122)
Arabic language 2 (ITAR122)
Introduction to Statistics (ITST211)
Object Oriented Programmin (ITGS211)
Introduction to Software Engineering (ITGS213)
Introduction to Networking (ITGS215)
Discrete Structures (ITGS217)
Numerical analysis (ITGS219)
Computer Architucture & Organization (ITGS223)
Data Structure (ITGS220)
Foundation of Information Systems (ITGS222)
Information Security (ITGS224)
Introduction to Internet Programming (ITGS226)
Introduction to database (ITGS228)
Operating System (ITGS302)
Scientific Writing (ITGS304)
Web Application Development (ITIS311)
Human Computer Interaction (ITIS312)
Data and Information Management (ITIS313)
Advanced Databases (ITIS325)
IT Infrastructure (ITIS323)
Design and Analysis algorithms (ITGS301)
Multimedia Systems (ITIS324)
Advanced System analysis & Design (ITIS326)
Enterprise Architecture (ITIS411)
Risk management and Security (ITIS412)
Introduction to Artificial Intelligence (ITIS413)
IT Project Management (ITGS303)
Enterprise Systems (ITIS421)
IS strategy ,management and acquisition (ITIS422)