Back to Modules
IS105

Business Data Management

1 CreditsBoth

Description

This course will cover the fundamentals of relational database theory, important data management concepts such as data modelling, database design, database implementation and searches in unstructured data (i.e., text) in current business information systems for non-SCIS students. Students are expected to apply knowledge learned in the classroom to solve many problems based upon real-life business scenarios, while gaining hands-on experiences in designing, implementing, and managing database systems.

Requisites

Prerequisites: None

Co-requisites: None

Anti-requisites: IS105/ IS112/DSA308 - Mutually Exclusive

Attributes

Department: SCIS

Course Level: Undergraduate

Tracks: N/A

Areas: Accounting Data and Analytics Core Accounting Electives Accounting Options Business Options Data Science and Analytics Electives Econ Major Rel/Econ Options Financial Forensics Core Grad Req - Dig Tech/Data Ana (Intake 2024 onwards) Law Related Electives Social Sciences/PLE Major-related Tech for Business Core (Intake 2019 - 2023) Technology & Entrepreneurship Technology Studies Cluster Business Core-Dig Skls in Biz(Intake 2025 onwards)

Learning Outcomes

Explain the concepts of Entity-Relationship (ER) Model Explain the concepts of Enhanced Entity-Relationship (EER) Model Develop an EER model for a given application to support the given list of functions Explain the concepts of relations and the seven steps required to transform a given ER/EER model to a relational schema Apply the transformation from ER/EER models to relations in many scenarios Explain the concepts of data normalization and the first three normal forms Apply data normalization in different scenarios Explain the Structured Query Language (SQL) Demonstrate how to build a database and how to retrieve data from database using MySQL Explain the concepts of physical storage and indexing

Graduate Learning Outcomes

Disciplinary Knowledge, Critical thinking & problem solving, Collaboration and leadership, Communication

Competencies

Data Design, Design Thinking Practice, Software Design, Solution Architecture, Data Sharing

View Source Listing