ITGS228 : Introduction to Databases

Department

Department of Computer Networks

Academic Program

Bachelor in Computer Networks

Type

Compulsory

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

Multimedia over IP networks (ITNT405)
Cloud Computing (ITNT404)
Fundamentals ubiquitous computing (ITNT403)
Wireless Sensor Networks (ITNT402)
Personal Area Networks (ITNT401)
Security Policy and Procedures (ITNT304)
Human Computer Interaction (ITNT302)
Modeling and Performance Evaluation (ITNT301)
Arabic language 1 (ITAR111)
General English1 (ITEL111)
Physics (ITPH111)
Intro to Information Technology (ITGS111)
Problem solving Technic (ITGS113)
Mathematics I (ITMM111)
Arabic language 2 (ITAR122)
Mathematics II (ITMM122)
General English2 (ITEL122)
Introduction to Programming (ITGS122)
System Analysis and Design (ITGS124)
logic Circuit Design (ITGS126)
Introduction to Statistics (ITST211)
Object Oriented Programmin (ITGS211)
Introduction to Software Engineering (ITGS213)
Introduction to Networking (ITGS215)
Discrete Structures (ITGS217)
Numerical analysis (ITGS219)
Information Security (ITGS224)
Foundation of Information Systems (ITGS222)
Computer Architucture & Organization (ITGS223)
Introduction to Internet Programming (ITGS226)
Introduction to Databases (ITGS228)
Data Structure (ITGS220)
Design and Analysis algorithms (ITGS301)
Data Communication (ITNT311)
Local Area Networks (ITNT312)
Networks Programming (ITNT313)
Cryptographic Algorithms and Protocols (ITNT314)
Wireless and Mobile Networks (ITNT324)
Operating System (ITGS302)
Digital Communication (ITNT323)
Network Protocols (ITNT322)
Wide Area Networks (ITNT321)
Scientific Writing (ITGS304)
IT Project Management (ITGS303)
Distributed Systems (ITNT411)
Network Design and Management (ITNT412)
Network QoS (ITNT421)
High speed Networks (ITNT422)
Graduation Project (ITNT500)