Availabilities:
Not currently available in 2018
Unit Summary
Unit type
UG Coursework Unit
Credit points
12
AQF level
Level of learning
Advanced
Former School/College
Pre-requisites
Unit aim
This unit will provide the student with an overall understanding of database concepts and theory. Students will learn how to design and build a database, from data analysis to mapping a specific database model. The relational model is emphasized and introduced using structured queried language (SQL) for creating and manipulating databases. Assignment work includes the analysis, design, and implementation of a database.
Unit content
Learning outcomes
Unit Learning Outcomes express learning achievement in terms of what a student should know, understand and be able to do on completion of a unit. These outcomes are aligned with the graduate attributes. The unit learning outcomes and graduate attributes are also the basis of evaluating prior learning.
On completion of this unit, students should be able to: | GA1 | GA2 | GA3 | GA4 | GA5 | GA6 | GA7 | |
---|---|---|---|---|---|---|---|---|
1 | list and explain the terminology of the relational database model | Knowledge of a discipline | Communication and social skills | |||||
2 | model business information requirements using entity relationship diagrams (ERD) | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
3 | translate a data model (ERD) into a logical database design with normalised relations | Knowledge of a discipline | ||||||
4 | design, develop, test and prove the functionality of a database | Intellectual rigour | Creativity | Knowledge of a discipline | ||||
5 | formulate, write and execute SQL queries | Knowledge of a discipline | ||||||
6 | describe the necessary steps to develop an effective physical database design | Intellectual rigour | Knowledge of a discipline | Communication and social skills | ||||
7 | explain the main functions of database administration and data warehouses. | Intellectual rigour | Knowledge of a discipline | Communication and social skills |
On completion of this unit, students should be able to:
- list and explain the terminology of the relational database model
- GA4: Knowledge of a discipline
- GA6: Communication and social skills
- model business information requirements using entity relationship diagrams (ERD)
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- translate a data model (ERD) into a logical database design with normalised relations
- GA4: Knowledge of a discipline
- design, develop, test and prove the functionality of a database
- GA1: Intellectual rigour
- GA2: Creativity
- GA4: Knowledge of a discipline
- formulate, write and execute SQL queries
- GA4: Knowledge of a discipline
- describe the necessary steps to develop an effective physical database design
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
- GA6: Communication and social skills
- explain the main functions of database administration and data warehouses.
- GA1: Intellectual rigour
- GA4: Knowledge of a discipline
- GA6: Communication and social skills
Prescribed texts
- Kroenke, DA & Auer, DJ, 2013, Database Concepts, 6th edn, Pearson Prentice Hall, New Jersey USA. ISBN: 978-0132742924.
- Kroenke, DA & Auer, DJ, 2013, Database Concepts, 6th edn, Pearson Prentice Hall, New Jersey USA. ISBN: 978-0132742924.