Studying online (if an online offering is shown below)
There are now 2 possible online modes for units:
Units with modes Online timetabled and Online flexible are available for any student to self-enrol and study online.
Click on an offering mode for more details.
Unit Overview
- Description
This unit deals with data modelling through the theory and practice of database design, implementation and use. Several database models are addressed, with a strong focus on the relational model and its theoretical grounding in sets and relational algebra. The process of problem decomposition into entity-relations, the design of appropriate relational schemas, and their refinement through normalisation underlies the unit. Critical issues surrounding the design of query languages and their implementation are addressed, and information retrieval is practised using a specific query language. Students learn database connectivity by building systems in one of several programming languages that support a connectivity Application Programming Interface (API).
- Credit
- 6 points
- Offering
(see Timetable) Availability Location Mode Non-standard teaching period UWA (Perth) Face to face Non-standard teaching period UWA (Perth) Face to face Non-standard teaching period UWA (Perth) Face to face Semester 2 UWA (Perth) Face to face - Outcomes
Students are able to (1) demonstrate understanding of existing database implementation and create refinements and improvements through analysis; (2) demonstrate understanding of the 'business' requirements to design a database; (3) refine the database to improve and ensure correctness and reliability; (4) correctly program structured query language (SQL) queries and reports; and (5) build an application layer interface for easier user interaction.
- Assessment
Indicative assessments in this unit are as follows: (1) labs and project; (2) mid-trimester test; and (3) final examination. Further information is available in the unit outline.
Student may be offered supplementary assessment in this unit if they meet the eligibility criteria.
- Unit Coordinator(s)
- TBA
- Unit rules
- Prerequisites
- Enrolment ina UWA College course and ATAR Mathematics Applications or equivalent
- Incompatibility
- CITS1402 Relational Database Management Systems
- The availability of units in Semester 1, 2, etc. was correct at the time of publication but may be subject to change.
- All students are responsible for identifying when they need assistance to improve their academic learning, research, English language and numeracy skills; seeking out the services and resources available to help them; and applying what they learn. Students are encouraged to register for free online support through GETSmart; to help themselves to the extensive range of resources on UWA's STUDYSmarter website; and to participate in WRITESmart and (ma+hs)Smart drop-ins and workshops.
- Visit the Essential Textbooks website to see if any textbooks are required for this Unit. The website is updated regularly so content may change. Students are recommended to purchase Essential Textbooks, but a limited number of copies of all Essential Textbooks are held in the Library in print, and as an ebook where possible. Recommended readings for the unit can be accessed in Unit Readings directly through the Learning Management System (LMS).
- Contact hours provide an indication of the type and extent of in-class activities this unit may contain. The total amount of student work (including contact hours, assessment time, and self-study) will approximate 150 hours per 6 credit points.
Face to face
Predominantly face-to-face. On campus attendance required to complete this unit. May have accompanying resources online.
Online flexible
100% Online Unit. NO campus face-to-face attendance is required to complete this unit. All study requirements are online only. Unit is asynchronous delivery, with NO requirement for students to participate online at specific times.
Online timetabled
100% Online Unit. NO campus face-to-face attendance is required to complete this unit. All study requirements are online only. Unit includes some synchronous components, with a requirement for students to participate online at specific times.
Online Restricted
Not available for self-enrolment. Students access this mode by contacting their student office through AskUWA. 100% Online Unit.
NO campus face-to-face attendance. All study and assessment requirements are online only. Unit includes some timetabled activities, with a requirement for students to participate online at specific times. In exceptional cases (noted in the Handbook) students may be required to participate in face-to-face laboratory classes when a return to UWA’s Crawley campus becomes possible in order to be awarded a final grade.
External
No attendance or regular contact is required, and all study requirements are completed either via correspondence and/or online submission.
Off-campus
Regular attendance is not required, but student attends the institution face to face on an agreed schedule for purposes of supervision and/or instruction.
Multi-mode
Multiple modes of delivery. Unit includes a mix of online and on-campus study requirements. On campus attendance for some activities is required to complete this unit.