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

❖ Week 10 Tuesday

In today's lecture ...

• Course Review, Exam Details

Things to do ...

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

Coming Up ...

• Help Session on Wednesday (Nov 16), 3-5 on Zoom
• Help Session on Tuesday (Nov 22), 2-4 on Zoom
• Exam on Fri 25 Nov, details tomorrow, sample exams out now

❖ 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 agebra 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
   • functional languages & DB,   logic languages & DB
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 15)
ass1    = mark for assignment 1      (out of 15)
ass2    = mark for assignment 2      (out of 20)
exam    = mark for final exam        (out of 50)
okExam  = exam >= 20                 (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

Fri 25 Nov, 3-hour exam in the CSE Labs, morning and afternoon sessions

Questions ...

• 55% practical, using PostgreSQL/Python3
• 45% theory, typed answers

What you have access to ...

• the exam paper (html)
• the Course website (via webcms)
• cheat sheets for PostgreSQL/Python/Psycopg2

And using your own VLab/db2 setup

❖ Final Exam (cont)

Make sure that you have a PostgreSQL server set up on  db2

• /localstorage/$USER/env
• /localstorage/$USER/pgsql

Review the Prac 02 instructions if not

To avoid  db2  600 MB disk quota issues:

• clean out old databases before the exam (psql -l, dropdb)
• delete /localstorage/$USER/pgsql/data/log

❖ 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

If you are awarded a Supp Exam ...

• to be held in O-week of 23T1 (Feb 6-10)
• 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 COMP9xxx
• 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 ...

❖ Extras

Things I forgot to put on the slides ...

• mail cs3311@cse to ask questions during the exam
• submit all answers via Give or Webcms3
• don't leave submissions to the last minute
• submit questions as you complete them