Enrolments for 2021 have closed.
Database Analysis and Design
Undergraduate | SWI-INF10002 | 2021
Course information for 2021 intake
View information for 2022 course intakeLook into how organisations deal with and utilise different types of data.
Sort through structured, semi-structured and unstructured data. Build and operate simple database systems. Get to know some of the key database and data retrieval tools.
- Study method
- 100% online
- Assessments
- 100% online
- Entry requirements
- No ATAR needed,
- No prior study
- Duration
- -
HECS-HELP and FEE-HELP available
Database Analysis and Design
About this subject
Students who successfully complete this subject will be able to:
Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data
Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques
Understand and apply conventional data modelling techniques to solve practical database design problems
Explain the impact of big data and modern data analytics tools in the design, use, and management of database systems.
- Database relations, tables, records, keys, filters, queries, parameters, forms, indexes
- Data formats, manipulation, and exchange tools
- Transactions and ACID
- Entity-relationship diagrams and modelling
- SQL
- Data warehousing, big data, and data normalisation
- Data analytics, business intelligence, visualisations, and functions
- Semi-structured and unstructured data storage
- Applications and examples of data and databases in organisations
This subject was previously known as INF20004 Database Concepts and Modelling.
This subject delivers the fundamental principles needed to effectively design and use databases. Databases are the tool used to create, store, organise, and disseminate data. It seeks to unpack the notion of data, and introduce contemporary tools and techniques for storing, retrieving, exploiting, and visualising data. Emphasis is given to understanding data modelling and design approaches, and the emerging opportunities afforded by big data, social media, data analytics, and unstructured data. The unit focuses on commercial and open-source database management tools.
Learning Portfolio consisting of:
Core Tasks
Extension Tasks
Tests
Learning Summary Report- Learning Portfolio - Individual (100%)
For textbook details check your university's handbook, website or learning management system (LMS).
Swinburne University of Technology leads the way with innovative and new ways of teaching, learning and thinking. It offers a wide range of study options, from pre-apprenticeships, undergraduate, postgraduate and PhDs, including online degrees with Open Universities Australia. Swinburne is known for career-oriented education and encouraging lifelong learning.
Learn more about Swinburne.
Explore Swinburne courses.
- QS Ranking 2024:
- 19
- Times Higher Education Ranking 2024:
- 14
Entry requirements
No entry requirements
Equivalent subjects
You should not enrol in this subject if you have successfully completed any of the following subject(s) because they are considered academically equivalent:
SWI-INF20004 (Not currently available)
SWI-CIS211 (Not currently available)
SWI-CIS210 (Not currently available)
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.
Why study a single subject?
Bite sized study
Try studying a particular area to see if online study suits you, or upskill in just a few months with a single subject that you’re interested in.
Pursue a dream
With thousands of single subjects to choose from, you can find topics that get you on the path to your higher education goals fast.
Gain Uni credit
Most single subjects are part of a full degree. That means if you’re keen to keep learning, you can gain credit for the subjects you’ve successfully completed.
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.