Information Systems & Operations Management
Approved course information last updated: 2 years, 8 months ago
Pre-requisites: ISOM 331
Requisite To: ISOM 472
Lab Session:
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.
- 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.