Database Analysis and Design
Duration
- One Semester or equivalentThis unit will be delivered on-line in Semester 2 2020.
Contact hours
- 48 hours
2020 teaching periods
Hawthorn
| Higher Ed. Semester 2 | ||
|---|---|---|
Dates: Results: Last self enrolment: Census: |
Swinburne Online
| Teaching Period 3 | ||
|---|---|---|
Dates: Results: Last self enrolment: Census: |
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
Unit information in detail
- Teaching methods, assessment, general skills outcomes and content.
Teaching methods
Face to Face Mode:
(Weekly): Scheduled hours: Lectures (12 x 2 hours), Labs (12 x 2 hour)
Other Student workload: Other activities including independent study and assessment tasks for a total of approximately 150 hours
Online:
Assessment
Learning Portfolio (Individual) 100%
- Core Tasks
- Extension Tasks
- Tests
- Learning Summary Report
General skills outcomes
During this unit students will receive feedback on the following key generic skills:
• problem solving skills
• analysis skills
• communication skills
• ability to tackle unfamiliar problems, and
• ability to work independently
Content
• 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
• 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
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.