Database Concepts
UndergraduateRMI-CPT1402023
Course information for 2023 intake
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.
Enrolments for this course are closed, but you may have other options to start studying now. Book a consultation to learn more.
- Study method
- 100% online
- Assessments
- Subject may require attendance
- Entry requirements
- Part of a degree
- Duration
- 13 weeks
- Loan available
- HECS-HELP and FEE-HELP available
Database Concepts
About this subject
Upon successful completion of this course 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 course is an introduction to the principles, use, and applications of database systems. It assumes no previous knowledge of databases or database technologies. This course 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
To enrol in this subject, you must be admitted into a degree.
Prior study
To help set you up for success before you start this subject, we suggest completing or having equivalent knowledge in:
Others
It is assumed that you have basic computer literacy.
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.