Content begins here
Overview
CMPG321 - Advanced DATABASES [2023]
Potchefstroom, Vanderbijlpark and Distance Students
EXAM DEMARCATION (Click to be transported)
Week |
Date |
Study Unit |
General Information Textbook, Slides, Class recordings etc. |
Comments and other information |
|
|
0
|
17 July-21 July |
Intro & Semester 1 Recap - Databases |
Class Recording: https://youtu.be/HWV5kPnJKcY
Most accurate transcript of the day: "I'm actually I'll for the loss of master on your third year. Um, so welcome and yeah, hopefully this all the people from fungal populations, drum and the distance students, that kind of thing." |
Semester Starts: Monday 17/07
|
|
| 1 | 24 July-28 July | 1 |
Transaction Management and Concurrency Control (1) Chapter 10 (p483-506)
|
Class Recording: https://youtu.be/E9mXmeUpIlk VC fulltime: Next class Friday 28/07 - Concurrency Control Slides for SU1: SU1-CH10.pptx
On the side: Interesting Read: Never forget ACID again. Transcript of the day: Hands off, please. Still , let me just see a cat joke. |
Note: Answered: Distance Exam 70 and Sem 30 with Full time students remaining 50/50. VC: Friday Class: To Do: 1) Get student representatives 2) Start with Concurrency control and 3) point finger at students 4) Get cat joke from class. |
| 2 | 31 July-4 Aug | 1 |
Transaction Management and Concurrency Control (2) Chapter 10 (p483-506) |
PC Class: Monday 31 July - done and dusted. Wednesday 2/8 1) Class recording link (let's try SharePoint 's stability - if not stable enough, let me know and will revert back to YouTube) - Class Recording (Without permission) 2) Slides used in VC and Distance class recording: Slides_Class_3_Wednesday_2Aug
|
To Do: 1) VC and Distance: You have a tiny homework assignment...enjoy :-) Interesting read for Homework 1: 2) Quiz on SU1 is out
|
| 3 | 7 Aug-11Aug | 2 |
SQL Fundamentals (I) Chapter 7 (244-318) |
PC Class: Monday 07 August ---000--- VC & Dist: 1) Wednesday - 9/8 No Class - Whoo, hoo! - a good time for reflection :-) 2) Friday 11 August: Online class @ 10:30: Teams Link 3) VC only: Please see poll for best suitable options for f2f classes 4) SQL Intro: SQL Intro (Self-study) 5) Class Recording Link: https://youtu.be/ziaZRmHZ8ow
|
Wednesday 9 Aug - Woman's Day Project - Released VC: Friday classes @ 10:30 seems to have a clash with other classes. VC Poll on Friday Class times: Please indicate which time will suit you the best: https://efundi.nwu.ac.za/x/FQAjsb
|
| 4 | 14 Aug-18 Aug | 2 |
SQL Fundamentals (II)
Chapter 8 (359-419) |
1) PC Class: Monday 14 August 2) VC and Distance Class Recording: https://youtu.be/0W28l7ncvYk 3) VC and Distance: Slides used in class: SQL Extra , Requirements and Conceptual Model 4) More slides on SQL (semester 1 slides for recap): SQL_1 ; SQL_2; SQL_3; SQL_4; SQL_5 5) * Experiment with ChatGPT to identify entities. Remember to ask the correct questions! Also look at Google Maps (Satellite) and the traffic function - please note - no interviews with questionnaires allowed (needs ethical clearance) - do desktop research only) * (VC and Distance) Homework Assignment 2 - use Feedback answers to help with business rules and logical diagram |
To-Do: 1) VC physical class & time arrangement for Fridays - as discussed - no physical class on Friday - make use of time to work on project deliverable 1 and homework assignment 1 (I am available between 9:30-10:30 online for any questions on project/homework assignment 2 - PC students also welcome!) 2) Extend Project Deliverable to 25 August - done 3) Open up Discussion forum for finding group members:
|
| 5 | 21Aug-25Aug | 3 |
Distributed Database Systems (1) Chapter 12 (p.553-583) |
1) Project: Deliverable 1 - submission extended to Friday 25 August @ 17:00 2) VC&Distance: - Class Recording:youtu.be/F9PCM9xhZPM 3) DDBMS Slides: Chapter 12_DDBMS 4) PC Class: Monday 21 August & Wednesday 23 August @ 09:30 5) |
To-Do: 1) All: Submission of Deliverable 1-Requirements Analysis & Logical Data Model (Friday) 2) All: Release Deliverable 2 - (next week Monday/Tuesday) - Logical and Physical Data Models 3) VC: Confirm Venue for Friday's Class (for now it is the Whale Lab and class starts at 14:30)
|
| 6 | 28Aug-1Sep | 3 |
Distributed Database Systems (2) Chapter 12 (p.553-583) |
1) PC Class: Monday 28 August - No Class 2) VC & Distance:
|
To-Do: 1) All: Release Deliverable 2 - (Thursday/Friday) - Logical and Physical Analysis Phase 2) VC Friday Class: Whale Lab and class starts at 14:30 |
| 7 | 4Sept-8Sep | 4 |
Big Data and NoSQL Chapter 14 (p.657-686) |
Transcript of the day: "Eating lectures, assignments, projects and all those type of stuff. But in any case, yeah, I'm also going to give you. I'm going to be part of the problem." |
To-Do: 1) Release Project Deliverable 2 Final 2) VC Students--> Friday class @ 14:30 alternate between online and face-to-face? for better attendance and accommodate Distance students? 3) Semester test |
| 8 | 11 Sep-15 Sep | 5 |
BI and Data Warehousing Chapter 13 (589-644) |
Textbook Slides: CMPG321_SU4_CH13_Data_Warehousing.pptx |
To-Do: 1) More on semester test 2) VC and Distance: Online Class Friday @ 9:30
3) Friday - Release HW3 (VC and Distance) - Done _close 9 October |
| 9 |
18 Sep-22 Sep |
Semester Test |
All campuses: No formal class on Wednesday but will be available for any questions: Open class Wednesday 20 Sept @ 8:00 -8:30: Done Teams Link
22 September 2023 @ 08:00 (check timetables closer to time) Test Information (60 Marks, +-1 hour) - Demarcation - VC and PC (22/09/2023 (8:00-9:00 )
Distance students (Online only - 19:00-22:00 for +-1h) - Online via Efundi (link will appear at exaclty 19:00)
|
Sunday - 24 Sept - Heritage Day |
|
| 10 | 25 Sep-29Sep |
Assessment Week |
Assessment Week (No class) |
Assessment Week | |
| 11 | 2 Oct-6Oct |
RESES |
RESES |
RESES | |
12 |
9Oct-13Oct | 6 |
DB Performance Tuning (1 & 2) Chapter 11 (p515-538) |
PC Class: Monday 09 September PC, VC and Distance: Class recording; Wednesday 11 Oct @ 8:00 -9:15 : https://youtu.be/9g60PP7l7q4
NB: Sick test arrangements: Thursday evening (12 October) on Efundi starting @ 19:00 - test links were sent out to individual students with valid medical certificates. |
To-Do: - VC - Hand out of tests in Friday's class: - Deliverable 3: Cancelled
|
| 13 | 16Oct-20Oct | 7 |
DB Admin & Security (Not for exam) Chapter 16 (p.734-776) |
PC, VC and Distance recording: https://youtu.be/fXhzAptRKxs PC, VC and Distance: Start preparing for exam PC Sick test arrangements (with dated and valid proof): @ Mr. Henri van Rensburg
VC & Distance: Sick test arrangements: Thursday evening (19 October) on Efundi starting @ 19:00 - test links were sent out to individual students with valid medical certificates.
|
To-Do: - Recap last lecture on DW (missed due to a Teams Freeze) - VC - Mark Assignment 3; Sick tests and other outstanding assignments - PC, VC, Distance: Deliverable 2 submission on Wednesday. - Start getting semester test marks in order - marks in before 27 October. |
| 14 | 23Oct-27Oct |
Project and Revision |
VC, Dist: Informal class Wednesday 25 Oct @ 8:00 -8:30 : Teams Link (open for general questions) PC: Informal / Optional class - Monday 23 October - Admin, discuss exam demarcation, review?, final semester test handout. |
||
| 15 | 30 Oct-3Nov | Exams |
Tentative date: 2 November @ 14:00 90 Marks; 2 Hours Question 1 – Transaction Management [15] Question 2 – Distributed Database Management Systems [15] Question 3 – BI and Data Warehousing [20] Question 4 – Big Data Analytics and NoSQL [10] Question 5 – DB Performance Tuning and Query Optimisation [10] Question 6 – Multiple choice (Predominantly SQL Related) [20] Extra notes on Exam:
|
1st Opp Exam starts - 30 Oct-22 November |
