Database Concepts

• • Introduction to databases
  • Basic relational modelling
  • Basic entity-relationship modelling
  • Basic SQL programming
  • Advanced Relational Modelling
  • Relational database design
  • Advanced ER modelling
  • Advanced SQL programming

You are recommended to have completed the following subjects(s) or have equivalent knowledge before starting this subject:

• RMI-CPT110-Introduction to Information Technology
• RMI-CPT120-Introduction to Programming

Special requirements

• OtherDetails -

  Stable broadband connection required to access online learning materials and live chat sessions/recordings. (note: mobile broadband users may have difficulties participating in live chat sessions) Unrestricted broadband access to enable using SQLDeveloper via the RMIT MyDesktop service is generally expected.

Databases and the database technology are having a major impact on the growing use of computers. They play a critical role in almost all areas where computers are used.

This subject is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. This subject focuses on developing skills in designing databases for efficient data management and SQL programming for querying and using databases for various database applications.

• Assignment 1 (20%)
• Invigilated Exam (50%)
• Assignment 2 (30%)