• Week 10 Tuesday
• Public Service Announcement
• COMP3311 Course Aims
• Syllabus Overview
• Assessment Summary
• Final Exam
• Revision
• Supplementary Exams
• Assessment
• Some Thoughts ...
• Finally ...

❖ Week 10 Tuesday

In today's lecture ...

• Course Review,   Exam Details

Things to do ...

• Quiz 6 due by 23:59 Friday (Apr 21)
• MyExperience course evaluation

Coming Up ...

• no lecture on Thursday; online consultation instead
• will also schedule pre-exam Help Sessions for next week

❖ Public Service Announcement

The Health Psychology lab in the School of Psychology at UNSW

• looking for participants to take part in research studies
• taste and flavour perception; sensory and cognitive processes

Participants are remunerated at a rate of $25 per hour

If you are interested in learning more

• complete an expression of interest at
  https://unsw.au1.qualtrics.com/jfe/form/SV_9LaeSfb4jZuImy2
• or contact them at healthbehaviourresearch@unsw.edu.au.

❖ COMP3311 Course Aims

At the end of this course you should be able to:

• develop accurate, non-redundant data models;
• realise data models as relational database schemas;
• formulate queries via the full range of SQL constructs;
• use stored procedures and triggers to extend DBMS capabilities;
• write applications in Python that interact effectively with databases;
• understand the overall architecture of relational DBMSs;
• analyze performance issues in relational database applications;
• understand how queries are evaluated via relational algebra operations;
• understand the concepts behind transactions and concurrency control

❖ Syllabus Overview

1. Data modelling and database design
   • Entity-relationship (ER) design, relational data model
   • Relational theory   (algebra, dependencies, normalisation)
2. Database application development
   • SQL for querying, data definition and modification   (PostgreSQL's version)
   • extending SQL   Queries, Functions, Aggregates, Triggers
   • PostgreSQL,   psql (an SQL shell),   PLpgSQL (procedural SQL)
   • SQLite,   sqlite3 (an SQL shell)
   • Python3,   Psycopg2,   accessing data programmatically
3. DBMS theory/technology
   • relational algebra,   functional dependencies,   normalization
   • performance tuning,   catalogues,   access control
   • DBMS architecture,   query processing,   transaction processing

Things in gray will definitely not be examined.

❖ Assessment Summary

Your final mark/grade will be determined as follows:

quizzes = mark for on-line quizzes   (out of 12)
ass1    = mark for assignment 1      (out of 12)
ass2    = mark for assignment 2      (out of 16)
exam    = mark for final exam        (out of 60)
okExam  = exam >= 25                 (after scaling)
mark    = quizzes+ ass1 + ass2 + exam
grade   = HD|DN|CR|PS  if mark >= 50 && okExam
        = FL           if mark <  50 && okExam
        = UF           if !okExam

❖ Final Exam

Mon 1 May,   3-hour exam,   morning and afternoon sessions

Morning: arrive by 10:00am,   Afternoon: arrive by 1:20pm

Things that are NOT the same as 22T3 final exam

• closed exam environment, on CSE workstations
• no access to Webcms3, or web in general
• no BYO laptop

Things that are like 22T3 final exam

• invigilated, in the CSE labs

❖ Final Exam (cont)

Questions ...

• 5 practical exercises, using PostgreSQL/Python3/Psycopg2
• 4 theory exercises, typed answers, like tute questions

What you have access to ...

• the exam paper (html)
• content slides, lecture slides, course notes
• documentation for PostgreSQL/Python/Psycopg2

What you do not have access to

• Webcms3, the class directory, your home directory

❖ Final Exam (cont)

When you login (zID/zPass) into the exam environment ...

• we create some working directories
  • including templates and testing scripts
• we create a local PostgreSQL server for you
• we load the exam database into your PG server
• we start a web browser, pointing at the exam entry page

PostgreSQL server runs on your workstation

Database: will not be huge, will not be overly complex (e.g. < 10 tables)

You do not have access to  VLab or  /localstorage  or  /home/YOU

❖ Final Exam (cont)

For the prac questions ...

• files are contained in a q? directory
• including a template, test cases and a check script

For the theory questions ...

• each question has a text file template q?.txt

General suggestions ...

• submit your answers using a submit script (e.g. submit q2)
• give up on questions that are taking too long (e.g. > 30 mins for prac)
• submit questions as you complete them; can submit multiple times
• don't leave all submissions to the last minute; if late, not marked

❖ Final Exam (cont)

❖ Final Exam (cont)

Questions are as follows:

1. an SQL query
2. another SQL query
3. yet another SQL query
4. a PLpgSQL function
5. a Python3/Psycopg2 script
6. some random analysis/synthesis question
7. another random analysis/synthesis question
8. etc. etc. etc.

Note that the database for Q1-5 will be available in advance.

❖ Revision

Sources for revision material:

• Lecture Material, Prac/Tute Exercises, Assignments
• Fundamentals of Database Systems, Elmasri/Navathe
• Database System Concepts, Silberschatz/Korth/Sudarshan
• Database Management Systems, Ramakrishnan/Gehrke
• Database Systems: Complete Book, Garcia-M/Ullman/Widom
• Database Systems: App-oriented, Kifer/Bernstein/Lewis
• PostgreSQL/Python/Psycopg2 Documentation (to some extent)

❖ Supplementary Exams

Suplementary Exams are only available to people who

• are absent from the Final Exam with good reason
  (good = documented, serious, clearly affects ability to do exam)
• have performed well during the rest of the semester
• see previous slide

If you are awarded a Supp Exam ...

• to be held in O-week of 23T2 (Thu 25 May)
• you must make yourself available for it
• non-attendance at the Supp ⇒ mark of 0 for the exam

❖ Assessment

Assessment is about determining how well you understand the syllabus.

If you can't demonstrate your understanding, you won't pass.

In particular, I don't pass people just because ...

• please, please, ... my parents will be ashamed of me
• please, please, ... I tried really hard in this course
• please, please, ... this is my final course to graduate
• please, please, ... I'll be excluded if I fail COMP3311
• please, please, ... if I fail this, I can't do COMP93xx
• etc. etc. etc.

❖ Assessment (cont)

Of course, assessment isn't a "one-way street" ...

• we get to assess you in the final exam
• you get to assess us in the Course Evaluation

MyExperience evaluations are online (via MyUNSW) NOW

Several evaluations: course, lecturer, tutor

Telling us good things is ok.

Telling us things to improve is very useful.

❖ Some Thoughts ...

You need to learn for life, not just the exam.

In particular, learn to find answers for yourself.

No single correct answer. (Solutions range from poor to excellent)

Take pride in your work. (Aim for quality, not just correctness)

❖ Finally ...