Waikato Home
COMPX323-23A (HAM)
Advanced Database Concepts
15 Points
Staff
Convenor(s)
|
Colin Pilbrow
9584
G.1.11
colin.pilbrow@waikato.ac.nz
|
|
|
Annika Hinze
4052
G.1.23
annika.hinze@waikato.ac.nz
|
|
Administrator(s)
Librarian(s)
You can contact staff by:
- Calling +64 7 838 4466 select option 1, then enter the extension.
-
Extensions starting with 4, 5, 9 or 3 can also be direct dialled:
- For extensions starting with 4: dial +64 7 838 extension.
- For extensions starting with 5: dial +64 7 858 extension.
- For extensions starting with 9: dial +64 7 837 extension.
- For extensions starting with 3: dial +64 7 2620 + the last 3 digits of the extension e.g. 3123 = +64 7 262 0123.
What this paper is about
How this paper will be taught
The objective of this paper is to provide students with in-depth knowledge and hands-on experience of a modern corporate relational database system. COMPX323 is taught through weekly flipped classroom sessions which will be run in an integrated fashion. Students are expected to watch online mini-lectures (of about 10min) before attending the sessions. In addition, some of the material will be taught in a lab environment.
Topics covered in the programme (incl project) will include:
- Advanced database design (Entity-Relation model and relational schema)
- Database Design Quality
- Advanced data retrieval (SQL)
- Indexing for faster data access
- No-SQL databases
Note that the labs will start in the second half of the course (SQL onward).
Required Readings
Learning Outcomes
Students who successfully complete the course should be able to:
Assessments
How you will be assessed
Marks for completed work will be posted on Moodle for you to check and ensure that they have been recorded correctly. If there is any discrepancy in your marks, inform the lecturer.
Ensure you keep all complete coursework until you have received your final grade. The completed coursework will be required if you need to have your grade reviewed.
If you are enrolled on a BE(Hons), samples of your work may be required as part of the Engineering New Zealand accreditation process for BE(Hons) degrees. Any samples taken will have the student name and ID redacted. If you do not want samples of your work collected then please email the engineering administrator, Natalie Shaw (natalie.shaw@waikato.ac.nz), to opt out.
The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam.