434 Data and Information Management

Information Systems & Operations Management

Approved course information last updated: 2 years, 2 months ago

Pre-requisites: ISOM 331

Requisite To: ISOM 472

Lab Session:

Course Description

This course introduces students to basic theoretical and fundamental concepts, methods and techniques essential to developing inventive database systems in a business context. It instills in students core skills required to identify organizational information requirements, model the requirements using appropriate conceptual data modeling techniques, convert the conceptual data model into logical data model, verify the structural characteristics of the logical model with proper normalization techniques, and implement and maintain a database using a suitable database management system (dbms). The course also provides students with fundamental concepts in managing data and information quality, privacy, and security.

Course Learning Objectives (CLOs)
  • Clo1: understand the role of database systems in managing organizational data and information in a changing technological environment.
  • Clo2: apply appropriate techniques and tools (e.g., interviews, documents analysis, prototyping, etc.) to clearly identify the information requirements of a database potential users.
  • Clo3: apply suitable data conceptual modeling techniques (e.g., entity-relationship and oo-class diagraming) to effectively capture and model the information requirements of a database potential users.
  • Clo4: choose and innovatively use a proper logical data model (e.g., network, relational, oo, etc.) to convert the conceptual model into a logical data model (i.e., logical database design).
  • Clo5: apply a proper technique (e.g., normalization) to verify the integrity and structuredness of the data in the logical database design.
  • Clo6: choose and apply a suitable dbms and a database programming language (e.g., sql) to implement, populate, access, and update the designed database.
  • Clo7: recognize and present fundamental concepts and organizational roles in data and information quality, privacy and security management.
Syllabus History
  • Compliant

    Submitted by: omar.khalil

    Validated by: omar.khalil

  • Compliant

    Submitted by: omar.khalil

    Validated by: omar.khalil

  • Compliant

    Submitted by: kamel.rouibah

    Validated by: kamel.rouibah

  • Compliant

    Submitted by: kamel.rouibah

    Validated by: kamel.rouibah

  • Compliant

    Submitted by: omar.khalil

    Validated by: omar.khalil

  • Compliant Updated

    Submitted by: omar.khalil

    Validated by: omar.khalil