ITGS228 : Introduction to Databases

Department

Department of Mobile Computing

Academic Program

Bachelor in Mobile Computing

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

Principles of Games Developments (ITMC404)
Parallel and Distributed Computing (ITMC403)
Mobile Multimedia (ITMC402)
Mobile 3D Graphics (ITMC401)
Mobile Commerce (ITMC304)
Programming Paradigms (ITMC302)
ARM microprocessor (ITMC301)
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)
Computer Architucture & Organization (ITGS223)
Data Structure (ITGS220)
Foundation of Information Systems (ITGS222)
Information Security (ITGS224)
Introduction to Internet Programming (ITGS226)
Introduction to Databases (ITGS228)
Mobile Applications Development (ITMC311)
Design and Analysis algorithms (ITGS301)
Operating System (ITGS302)
Principles of mobile communication networks (ITMC312)
IT Project Management (ITGS303)
Scientific Writing (ITGS304)
Cross-Platform Mobile App Development (Flutter) (ITMC323)
Heterogeneous and Mobile Databases (ITMC322)
Mobile Interaction Design (ITMC321)
Mobile Operating System (ITMC313)
Security in mobile computing (ITMC411)
Personal Area Networks (ITMC412)
Social Networking (ITMC413)
Networks Programming (ITMC414)
Fundamentals ubiquitous computing (ITMC421)
Cloud Computing (ITMC422)