Section: Day12 - Creating a Database, table, design | IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle

Main course page

  • -- School of Information Technology --

    Fundamentals of Data Science

    IT5507
    • Forum icon
      Announcements Forum



    • 9 Best Free Online Data Science Courses In 2020

      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:

      1. Describe and explain data using a variety of visualization techniques and software tools.
      2. Analyse the data requirements of simple systems and model those requirements using conceptual and logical data modelling techniques.
      3. 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.

Day11 - Databases and MS Access
Day 13 - Creating Queries in Access

Day12 - Creating a Database, table, design

Day11 - Databases and MS Access
Day 13 - Creating Queries in Access