Database Analysis and Design

INF10002 12.5 Credit Points Hawthorn, Sarawak Available to incoming Study Abroad and Exchange students

Duration

  • One Semester or equivalent
     
    This unit will be delivered on-line in Semester 2 2020. 

Contact hours

  • 48 hours

2020 teaching periods

Hawthorn

Higher Ed. Semester 2

Dates:
3 Aug 20 - 1 Nov 20

Results:
8 Dec 20

Last self enrolment:
16 Aug 20

Census:
31 Aug 20

More teaching periods

Swinburne Online

Teaching Period 3

Dates:
2 Nov 20 - 7 Feb 21

Results:
2 Mar 21

Last self enrolment:
15 Nov 20

Census:
27 Nov 20


Prerequisites

Nil

Corequisites

Nil
 
Alternative Tertiary Entry Program: Students who have passed INF00001 are exempted from taking this unit and must select another unit in its place with advice from a Course Advice Specialist. 

Aims and objectives

Digital data is central to the modern economy. Transactions, managerial decisions, and strategy development rely on data. Databases are the tool used to create, store, organise, and disseminate data. This unit delivers the fundamental principles needed to effectively design and use databases. 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. Both commercial and open-source database management tools are focused upon.
 
Students who successfully complete this unit will be able to:
 
1. Define and explain fundamental data and database concepts including tables, relations, keys, queries, transactions, and structured, semi-structured, unstructured data
 
2. Create, store, retrieve, exploit, and visualise data using modern database tools, functions, and techniques
 
3. Understand and apply conventional data modelling techniques to solve practical database design problems
 
4. Explain the impact of big data and modern data analytics tools in the design, use, and management of database systems.