27 Oct: (1) Proj1 and Ass2 marks released — See the respective page for more details. (2) Pre-exam consultations: 29 & 30 Oct (Thu & Fri), 1500 — 1700, K17 403. (3) COMP3311 past exam papers: http://cgi.cse.unsw.edu.au/~cs3311/09s1/admin/past-exams.php (Note: These exam papers were for COMP3311, which only has partial overlap with the current COMP9311 course content. Don’t panic if you see questions that are not covered in this course. In particular, we won’t ask you to write postgres functions in the exam.)
21 Oct: (1) Ass2 sample solution released — See the ass2 page. (2) FAQ part of Proj2 page updated.
15 Oct: (1) Proj2 spec updated, see proj2 page for details. (2) tut9-sol.pdf updated (fixed the error wrt the B+-tree after insertion).
9 Oct: Proj2 spec online. The deadline is 23 Oct (Fri).
30 Sep: Tutorial on functional dependency and normalization added.
22 Sep: Ass2 spec released. The deadline is 16 Oct (Fri).
14 Sep: Proj1 spec updated (see proj1 page for details)
14 Sep: You can look up your score and comments by 9311 classrun -collect ass1. Please contact the tutor (wangj@cse) if you have any question. More info at the ass1 info page.
10 Sep: Ass1 sample solution online. We are at the final stage of marking and will release the marks early next week.
3 Sep: Ass1 info page updated (2 more FAQ items).
2 Sep: Ass1 info page updated (1 typo in Q1(a) and one new FAQ for Q1(c)).
2 Sep: Added two scripts for testing ass1 queries (See Sec 2 of Ass1 info page).
25 Aug: Proj1 spec online. The deadline is 29 Sep (Tue).
18 Aug: There is an error regarding Ass 1 deadline. It should be 4 Sep (Fri).
12 Aug: Ass 1 spec released.
4 Aug: Week 1 lab page online. All labs start this week.
27 Jul: Consultation time for the course: Thu 1600-1700 K17-508. Consultation will start from Week 3 till Week 13.
22 Jul: Course forum created.
20 Jul: Note: We do not have tutorial in this session (sorry Forbes’s the mistake on the previous version of the Web page).
15 Jul: Rules regarding emails:
All emails should be sent to the course account cs9311@cse.
Strict spam email filtering is enforced due to the high level of spam emails. Please make sure you use either CSE or UNSW email address to email cs9311.
It is recommended that you come to the consultation if you have any technical question. Emails are just not as effective (cannot draw figures, cannot communicate in real-time)
14 Jul: Course homepage online.
| Lab | Week | Contents | Solution |
|---|---|---|---|
| lab1 | 3 | Linux Basics + Setting up your postgres server | |
| lab2 | 4 | postgres tutorial + exercise | sol |
| lab3 | 5 | postgres + SQL exercises | sol |
| lab4 | 6 | postgres server programming | |
| lab5 | 7 | same as lab4 | |
| lab6 | 8 | reserved for proj1 | |
| lab7 | 9 | reserved for proj1 | |
| lab8 | 10 | reserved for proj2 | |
| lab9 | 11 | reserved for proj2 | |
| lab10 | 12 | reserved for proj2 | |
| lab11 | 13 | reserved for proj2 |
All assignments are individual assignments.
| Specification | Topic(s) | Deadline | Solution |
|---|---|---|---|
| ass1 + ass1 info page | SQL + ER | 4 Sep 2009 | |
| ass2 | DB Theory | 16 Oct 2009 (Fri) |
All projects are individual projects.
See here.
| Name | Role | Phone | |
|---|---|---|---|
| Dr. Wei Wang | Lecturer-in-charge | 9385 7162 | cs9311@cse |
| Role | Name |
|---|---|
| textbook | Database Management Systems (Third Edition) |
| references | Database System Concepts (Fifth Edition) |
| references | research papers |
| Name | Comment |
|---|---|
| PostgreSQL | Database Server |
| Day | Time | Location |
|---|---|---|
| Wed | 1800 — 2100 | Central Lecture Block 4 (K-E19-G05) |
| Day | Time | Location |
|---|---|---|
| Thu | 1600-1700 | K17 508 |
| Week | Content | Reading | Tut/Lab/Ass/Proj |
|---|---|---|---|
| 1 | Course Introduction + Introduction | Chap1 | |
| 2 | Relational Model | Chap3 | |
| 3 | Relational Algebra | Chap 4 + Chap5 | lab/consultation starts |
| 4 | SQL (a) | Chap 4 + Chap5 | ass 1 spec released |
| 5 | SQL (b) | postgres documentation | |
| 6 | ER model (example) | Chap 2 + Chap 3.5 | proj1 spec released |
| 7 | ER model tutorial (sol ) | Chap 2 | |
| B | NULL | NULL | NULL |
| 8 | Mapping + Functional Dependency | Chap 3.5 + Chap 19 | |
| 9 | Functional Dependency + Normalization + FD and NF tutorial + sol | Chap 19 | ass2 spec released |
| 10 | Storage Manager | ||
| 11 | Indexing | proj2 spec released | |
| 12 | Review + Storage Manager Tutorial (sol) + Indexing Tutorial (sol) | ||
| 13 | NULL | NULL | NULL |
UNSW (The University of New South Wales) CRICOS Provider Number: 00098G