Content begins here

Dashboard

Help Opens in a new window

CMPG321 - Advanced DATABASES  [2024]

Distance Students

Classes: TEAMS Meetings as needed or on request

Facilitator: Dr. Jaco Pretorius

Email: jaco.pretorius@nwu.ac.za

Link to site: BSc in IT Distance

Plan B:  - Study units order changed 22/7 and DB Connectivity & Web Tech. added in October

                - tentative assignments and project deliverables dates added

 

We are here: Click Link to be transported

Week

Date

Study Unit 

General Information   Textbook, Slides, Class recordings etc.

Comments and other information

0

8 July-12 July

  

1) Intro Announcement sent via email...

2) Admin slides for your review: Admin and other info

3) For extra entertainment please see the study guide - Please note the participation/exam ratio on the  Assessment page in  (Study guide)

Semester Starts: Monday 8/07

1

15 July-19 July

1

Transaction Management and Concurrency Control (1)

Chapter 10 (p483-506)

Class slides: What is a transaction?

Class recording: Context of CMPG321 and Transactions  or press this link: https://youtu.be/nK6BfcLV9RA (Please note that the comments and writings of my tablet pen on the slides, were not recorded :-( . I will try and correct next week.)

 

 Slides and class recording updated. Links to slides were locked and not visible - corrected. You should be able to see all the slides now.

2

22 July-26 July

1

Transaction Management and Concurrency Control (2)

Chapter 10 (p483-506)

Class slides: Concurrency Control (updated slides)

Class Recording:  https://youtu.be/BGeV9yt-BO0

To Do:

Out:

 - Assignment 1 (Thursday 25/7)  -  Revision Questions  on Concurrency Control under Test & Quizzes

 - Revision Quiz (SU1)

Slides for week uploaded and should be available - please check

Youtube recording link to be uploaded on Thursday 25/7 - done - however, again without tablet pen writing. Sorry. (Solution for next week, will not make use of live PowerPoint slides, but will rather share the screen with PPS on it ).

3

29 July-2 Aug

2

DB Performance Tuning (1 & 2)

Chapter 11 (p515-538)

Class slides: Performance Tunining a Database

Class Recording:  https://youtu.be/Rp-v-LilyeI  

 

4

5 Aug-9 Aug

3

Distributed Database Systems (1) 

Chapter 12 (p.553-583)

Class slides:  DDBMS_Textbook slides

                        Class Recording slides

Class Recording:  The good, the bad and the ugly of Distributed DBMS

Semester Project:

                                  - Slides: Project Background Information

                                  -Data link: AirBnB data

 

To Do:

Semester project: 

Out: Deliverable 1, Phase 1 released today 7/8/24

In: Deliverable 1, Phase 1 need to be submitted  Tuesday 21 August

5

12Aug-16Aug

3

Distributed Database Systems (2)

Chapter 12 (p.553-583)  

....no class recording for this week - please look at the first slide about project phase 1 deliverable and revision quizzes (on the class slides underneath)

Class slides: DDBMS Texbook slides II 

 

Next week I will talk about Data Warehousing and Business Intelligence - the best part of databases where one is getting knowledge out of tons of data and information! This is the most existing part/environment of any database architecture (according to a very biased lecturer! :-)) See you next week! Whoo-hoo! :-)

To Do:

Out:

New

1) Revision Quiz 2 (on DB performance tuning)

2) Revision Quiz 3 (On DDBMS 1 and 2)

Persistent: 

 - Project Deliverable 1, Phase 1 for 21 August

 

6

19Aug-23Aug

4

BI and Data Warehousing:

Chapter 13 (589-644) 

 

Class Slides: Business Intelligence and Data Warehouses

Class Recording: On Business Intelligence, Data Warehousing and Knowledge

To Do:

In: Project Part 1 (Wednesday 21 August; Extended until Friday @ 17:00) 

New documents released for project: 1) Project Template

                                                                    2) Project Description (more 

                                                                         detail)

7

26Aug-30Aug

 5

SQL Fundamentals (I)

Chapter 7 (244-318)

SQL Recap Slides: SQL i

Recording: Semester test, DB Lifycle and your project; Logical Design and SQL

To Do:

1) SQL Homework 1  question (under Test & Quizzes - for easier marking)

2) Carry on to Phase 2 of project...

8

2 Sep-6 Sep

5

SQL Fundamentals (II) 

Chapter 8 (359-419)

No formal recording for today - please follow slides and look at To-Do's  (next column)

SQL Fundamentals ii: Slides:  and admin (and more about semester test)

 

Extra resource material on SQL to explain in more detail Chapter 7 & 8: (and see if you can use the information for phase 2 of your project)

i) Notes on intermediate SQL structures

ii) Notes on Advanced SQL structures

iii) Notes on SQL and Triggers

 

To Do:

Out:

 - Tentatively out: Phase 2  -  start looking at phase 2 of your project....(see week 12)

 - Revision Quiz - SU5 (SQL) - Due 10 September in preparation of semester test

 - SQL Practice Assignment (due 4 October in preparation for exam)

 

Submission closes for:

 - Revision Questions Concurrency Control 

 - Revision Quiz (SU1)

 

9

9 Sep-13 Sep

  

Semester Tests: 

2024 Second Semester Mid-Semester Assessment Timetable V1
Module Paper Date Start Time Duration
CMPG 321 1 2024/09/10 19:00:00 01:00:00

 

 

CMPG321 semester test:

How? Online via Efundi

When? Tuesday 10 September @ 19:00-20:00

What? SU 1-5

For more information: https://efundi.nwu.ac.za/x/Mh2vUZ

Type of questions to expect: https://efundi.nwu.ac.za/samigo-app/servlet/Login?id=223256381725864702097

10

16 Sep-20 Sep

  

Assessment Week

 

Out Project  Phase 2. (Please see Assignment tab for rubric )

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To Do:

Project Part 2: ( Start where you left of in Phase 1 of your project and add Phase 2 to the existing documentation.)

1)  Database Setup Load the Airbnb dataset into any DBMS of your choice (e.g. Oracle, MySQL, PostgreSQL, etc.).

2) Design the appropriate data structure, including primary and foreign keys, Constraints (e.g. NOT NULL, UNIQUE), Data types and domains, Relationships between entities.

3) Create the database schema, ensuring it supports the efficient execution of your queries. 5) Schema / ERD Provide a detailed Entity-Relationship Diagram (ERD) or schema diagram that represents your database structure as implemented in your chosen DBMS. This diagram should include all tables, columns, keys, and relationships.

4) SQL Query Development Develop a series of SQL queries that address the research questions you identified in order to support the focus of your project.

5) Make use of a variety of SQL techniques, including joins, aggregations, subqueries, transactions, etc. Optimize your queries for performance where necessary. (Please see Week 8  - Extra resource material on SQL for ideas)

6) Analysis and Reporting:  Analyse the results of your SQL queries to draw meaningful conclusions related to your focus area.

7) Present your findings in a well-organized report, including tables, charts, and any other relevant visualizations where applicable. Discuss any patterns, correlations, or insights you uncovered through your analysis. 

      

11

23 Sept-27 Sept

RESES

RESES

      12      

      30Sept-4 Oct      

      6      

Big Data and NoSQL

Chapter 14 (p.657-686)

Textbook Slides:NoSQL and Big Data

 

 Revision test after studying the work (will not count or be marked): Revision Questions (after studying chapter)

      

 

13

7Oct-11Oct

7

DB Connectivity & Web Tech. - not for exam

  

14

14Oct-18Oct

  

Project and Revision

IN:

Submission of Phase 1 & 2 of Project (One document): 16 October

 

Pre -Exam Information: (as received from the exams office)

 

  • Distance students will write their first exam opportunity at their normal exam centres, however, their second exam opportunity will only be available at the NWUs three campuses, the Parow exam centre and the Namibia exam centre.

  • Students can contact Elwon van Wyk at Elwon.VanWyk@nwu.ac.za if they have any inquiries about their exam venue. 

 

15

21 Oct-25Oct

  

CMPG321 Tentative Exam Times (as received from UDL office):

      1st Opp exam               Session                                  Date
CMPG321 2 2024-10-22

 

2nd Opp Exam            Paper                     Date                         Start                             End                        Duration

CMPG 321 1 2024-11-13 14:00 17:00 3:00

 

1st Opp Exam starts

 

What?: CMPG321 Exam Demarcation 2024

Count: 100 Marks

Duration: 3 Hours

1st Opp – Tuesday 22 October 2024 @ 14:00

2nd Opp – Wednesday 13 November 2024 @ 14:00

Demarcation:

Question 1 – Transaction Management & Concurrency Control [16]

Question 2 – DBMS and Query Optimisation [14]  

Question 3 – Distributed Database Management Systems [18]

Question 4 – BI and Data Warehousing [17] / [16]

Question 5 – Big Data Analytics and NoSQL [15] / [16]

Question 6 – Multiple choice (Predominantly SQL Related) [20]

Extra notes on Exam: Most questions relate to Name, Explain, Discuss, Describe, Compare, What, How, etc.  Focus on the CORE of each study unit. SQL Questions – don’t have to write elaborate SQL statements, the SQL related questions will be in the Multiple-choice section. 

 

 

 

Message Center Notifications

Help Opens in a new window