Section: Day 2 - Database Systems | IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle

Home Courses Students Staff Library Help

Section: Day 2 - Database Systems | IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle

Main course page

-- School of Information Technology --

Fundamentals of Data Science
IT5507
- Announcements Forum
- Welcome to the Fundamentals of Data Science Course!
  
  We hope you enjoy your learning journey!
- Lecturer: Dr Hamid Mahroeian
  Email: hamid.mahroeian@whitireia.ac.nz
  
  Lecturer: Dr Harvey Ho
  Email: harvey.ho@weltec.ac.nz
- Course aim:
  To provide learners with a basic understanding of how data is modelled, stored, manipulated, and analysed using databases and visualisation techniques.
  
  Learning outcomes:
  By the end of this course, the student will be able to:
  Describe and explain data using a variety of visualization techniques and software tools.
  Analyse the data requirements of simple systems and model those requirements using conceptual and logical data modelling techniques.
  Create a simple database that includes tables, columns, primary keys, foreign keys and simple queries.
  
  Student Resources:
  Learning materials will be provided as required during the course via Moodle.
  Any other reference material will be provided by the lecturer throughout the course.
  Completion criteria:
  Students must attempt all assessments and achieve an overall grade of 50% to be successful in this course.

Day 2 - Database Systems

Day 2 - Database Systems

In this session, we explore Database Systems, where we navigate the essentials of information management, exploring data distinctions, database evolution, design intricacies, and the crucial role of Database Management Systems (DBMS) in shaping effective decision-making and information organization.
- Examples - Database Systems bank and university File
- Business Process Modelling BPMN File
- Day 2 - Database Systems File
- Lab 2.0 File
- Submit your Lab 2.0 here Assignment
- Lab 2.1 File
- Submit your Lab 2.1 here Assignment
- ----------------------------------------------------------------------------------------------------------------------------------------------------------------
- Quiz 2
- ----------------------------------------------------------------------------------------------------------------------------------------------------------------
- Additional resources
- Create BPMN diagrams in Visio URL
- Explore The Role of Data Processing in Research URL
- Importance of Database Design in DBMS URL
- Blockchain vs. Traditional Database: What Should Be a Startup’s Choice URL
- 5 Common Data Management Mistakes and How to Avoid Them URL