Database Analysis and Design
Duration
- One Semester or equivalent
Contact hours
- 24 hours face to face + blended
On-campus unit delivery combines face-to-face and digital learning.
2023 teaching periods
Hawthorn Higher Ed. Semester 2 |
||
---|---|---|
Dates: Results: Last self enrolment: Census: Last withdraw without fail: |
Aims and objectives
This unit challenges participants to critically explore modern database design and application in contemporary society. After delivering the fundamental principles and techniques required for modern database management, the unit challenges participant’s to develop innovative database solutions to practical problems, through novel application of data modelling techniques, and commercial and open-source database tools. The opportunities, challenges, and implications of big data, social media, data analytics, and unstructured data on conventional database systems are explored in parallel.
Unit Learning Outcomes (ULO)
Students who successfully complete this unit will be able to:
1. Critically evaluate data and database definitions and concepts.
2. Develop novel solutions to practical data management challenges using modern database tools and data modelling techniques.
3. Critically explore the organisational, societal, and technical impact of big data, unstructured data, and modern data analytics tools on database system design and management.
Unit information in detail
- Teaching methods, assessment and content.
Teaching methods
Hawthorn
Type | Hours per week | Number of Weeks | Total |
On Campus Class in Computer Lab | 2 | 12 | 24 |
Online (asynchronous lecture) | 1 | 12 | 12 |
Unspecified Activities Independent Learning | 9.5 | 12 | 114 |
TOTAL | 150 hours |
OUA
Type | Hours per week | Number of Weeks | Total |
Online (asynchronous lecture) | 12.5 | 12 | 150 |
TOTAL | 150 hours |
Assessment
Types | Individual/Group Role | Weighting | Unit Learning Outcomes (ULOs) |
Portfolio | Individual | 100% | 1,2,3 |
Content
• Data and database fundamentals and conventions
• Data management including SQL• Data modelling including ERD
• Data warehousing, big data, and data normalisation
• Business intelligence and data analytics
• Semi-structured and unstructured data storage
• Critical design and application of databases in organisations
Study resources
- Reading materials.
Reading materials
Students are advised to check the unit outline in the relevant teaching period for appropriate textbooks and further reading.