Database Analysis and Design
Look 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.
Enrolments for this year have closed. Keep exploring subjects.
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.
QS RANKING 2022
Times Higher Education Ranking 2022
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
- 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
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)
No additional requirements
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%)