Enrolments for 2019 have closed.
Database Concepts
Undergraduate | RMI-CPT140 | 2019
Course information for 2019 intake
View information for 2020 course intakeDig 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.
- Study method
- 100% online
- Assessments
- Subject may require attendance
- Entry requirements
- Prior study needed
- Duration
- 13 weeks
HECS-HELP and FEE-HELP available
Database Concepts
About this subject
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.
- 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
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%)
For textbook details check your university's handbook, website or learning management system (LMS).
One of Australia's largest dual-sector institutes, 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 96,000 students study with RMIT, and many of their degrees are available through Open Universities Australia.
Learn more about RMIT University.
Explore RMIT courses.
- QS Ranking 2024:
- 11
- Times Higher Education Ranking 2024:
- 16
Entry requirements
Prior study
To help set you up for success before you start this subject, we suggest completing or having equivalent knowledge in:
Additional requirements
- Other requirements -
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.
Study load
- 0.125 EFTSL
- This is in the range of 10 to 12 hours of study each week.
Equivalent full time study load (EFTSL) is one way to calculate your study load. One (1.0) EFTSL is equivalent to a full-time study load for one year.
Find out more information on Commonwealth Loans to understand what this means to your eligibility for financial support.
Single subject FAQs
Single subjects are the individual components that make up a degree. With Open Universities Australia, you’re able to study many of them as stand-alone subjects, including postgraduate single subjects, without having to commit to a degree.
Each of your subjects will be held over the course of a study term, and they’ll usually require 10 to 12 hours of study each week. Subjects are identified by a title and a code, for example, Developmental Psychology, PSY20007.
First, find the degree that you would like to study on our website.
If that degree allows entry via undergraduate subjects, there will be information about this under the Entry Requirements section. You will find a list of 2-4 open enrolment subjects you need to successfully complete to qualify for admission into that qualification.
Once you pass those subjects, you will satisfy the academic requirements for the degree, and you can apply for entry.
Our student advisors are here to help you take that next step, so don’t hesitate to reach out when you’re ready! We’ve also made it easier to figure out the right way to get started on our pathways page.
Our student advisors are more than happy to help you plan your online study. Get in touch with an advisor by:
You can pay up front with your credit card, or you may be eligible for a HELP loan from the Australian government depending on your citizenship status and where you’ll live during your studies.
For more information about how to pay for your studies visit our fees page or contact a student advisor.
When you’ve made your choice, click ‘Enrol now’ on the relevant course page and follow the prompts to begin your enrolment. We’ll ask you to supply some supporting documentation, including proof of your identity, your tax file number, and a unique student identifier (USI) during this process.
Your university will get in touch with you via email to confirm whether or not your application has been successful.
If you get stuck at any time, reach out to us and we’ll talk you through it.
You can also take a look at our online self-service enrolling instructions .
Close of enrolment times vary between universities and subjects. You can check the cut-off dates for upcoming study terms by visiting key dates.