IS105

Download as PDF

Business Data Management

Course (UG/PG)

Undergraduate

Offering Unit/Department

Course 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.

Course 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

Discipline-Specific Competencies

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

SMU Graduate Learning Outcomes

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

Grading Basis

GRD - Graded