Open Universities Australia 13 6736 Favourites
Open Universities Australia
  • Study online
    • Explore study online
    • Architecture & construction
    • Art & creative design
    • Business & management
    • Community services & care
    • Education & teaching
    • Engineering
    • Health & medical science
    • Humanities & social science
    • IT & computer science
    • Law & justice
    • Media & communication
    • Psychology & mental health
    • Science
    • Search all courses
    • Study types
    • Undergraduate degrees
    • Postgraduate courses
    • Pathways and pre-university
    • Single subjects
    • Short courses
    • Choosing a course
    • Help me choose a course
    • Chat with a student advisor
    • Compare courses
    • Degrees vs single subjects
  • How OUA works
  • Your studies
    • Getting started
    • Key dates
    • Minimum age requirements
    • How to enrol
    • Applying for credit
    • Study planning
    • Textbooks & study materials
    • Computer requirements
    • Exams
    • International students
    • Financial options
    • Student loans
    • Study allowances
    • Fees
    • Support
    • Getting advice
    • Study preparation
    • Disability support
    • Smarthinking
    • Special Circumstances
    • Covid-19 & study
  • Advice
13 6736
Favourites
Sign in
  • OUA
  • Subjects

Undergraduate RMI-CPT140-2021

Database Concepts

Dig into data principles. Explore the use and application of database systems. Learn how to design and apply software solutions to meet requirements and specifications. Assess and compare software assets and IT systems for organisational and user fit.

From

$993 $1,243

Your upfront cost: $0

International student?

Duration

13 weeks

Study method

100% online

Available loans

  • HECS-HELP
  • FEE-HELP

Assessments

Subjects may require attendance

Prior study

Not required

Study terms

  • 30 Nov 2020
  • 31 May 2021
  • 29 Nov 2021
RMIT University - Logo
Australia's largest dual-sector institute, offering both TAFE and higher education, RMIT University proudly delivers work-related education and practical research relevant to current business and community needs. More than 60,000 students study with RMIT, and many of their degrees are available through Open Universities Australia.

QS RANKING 2021

15

Times Higher Education Ranking 2021

23

  • 2021

Subject details

What you'll learn

Upon successful completion of this subject you should be able to:

  • Describe various data modelling and database system technologies
  • Explain the main concepts for data modelling and characteristics of database systems
  • Identify issues with and compare, justify relational database design using the functional dependency concepts
  • Apply SQL as a programming language to define database schemas and update database contents
  • Apply SQL as programming language to extract data from databases for specific users’ information needs
  • Design a database schema using conceptual modeling mechanisms such as entity-relationship diagrams.
Topics covered
    • 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
Entry requirements

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.

Description

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.

Assessments

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

Check the learning management system (LMS) of your university for textbook details.

Check the learning management system (LMS) of your university for textbook details.

Related degrees

Undergraduate RMI-CPT-DEG-2021

Bachelor of Information Technology

Tell us a little about yourself

Open Universities Australia
Facebook Twitter Instagram LinkedIn YouTube
  • Contact us
  • About us
  • OUA Blog
  • Media centre
  • Partnerships
  • Universities
  • Your career
  • FAQ and glossary
  • Work with us
  • Courses
  • MBA online
  • COVID-19 and study
  • Partner Hub
  • Open2Study

Open Universities Australia is a not-for-profit organisation.
© Open Universities Australia 2021. All rights reserved.

  • Cookies
  • Copyright
  • Disclaimer
  • Privacy
  • Terms of use
  • Site map