Data Modelling
This course will explore the conceptual, logical, and physical phases of data modeling, facilitating an understanding of their application in the system development process and the interrelationships of data elements. Students will learn how to define data requirements for databases and gain hands-on experience in modelling, validating, and normalizing data, resulting in a logical data model using different approaches. Building on this foundation, students will acquire the skills to create relational databases. Dynamic system modelling, emphasizing stocks, flows, and converters, is another integral part of this course, with practical lab exercises enabling students to construct and manipulate dynamic models for real-world challenges. Students will apply their knowledge by developing a database for an area of interest and then create a corresponding system dynamics model to illustrate potential impacts on the system.
- Hours: 42 hrs (3-0)