Introduction to Database Design and Management

Macquarie University

Course Description

  • Course Name

    Introduction to Database Design and Management

  • Host University

    Macquarie University

  • Location

    Sydney, Australia

  • Area of Study

    Computer Programming, Computer Science, Information Sciences, Information Technologies

  • Language Level

    Taught In English

  • Course Level Recommendations

    Lower

    ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.

    Hours & Credits

  • Credit Points

    3
  • Recommended U.S. Semester Credits
    3 - 4
  • Recommended U.S. Quarter Units
    4 - 6
  • Overview

    This unit introduces students to the principles and concepts of data storage, management and modelling, including the role of data and information in organisations. The unit will cover conceptual modelling techniques, converting conceptual data models into relational data models and verifying its structural characteristics with nomalisation techniques, and implementing and utilising a relational database using a database-management system. Fundamental data modelling tools, techniques and query languages such as Structured Query Language (SQL) will be used. Ethical and green approaches to the collection, backup, use and storage of data and the construction of systems are emphasised. An introduction to the concepts and issues relating to data warehousing, governance, administration, security and privacy and alternative database structures such as distributed and object oriented databases will be provided. The unit concentrates upon building a firm foundation in information representation, organisation and storage with particular emphasis upon the application of database systems.

Course Disclaimer

Courses and course hours of instruction are subject to change.

Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.