:::success 29/05/2020 - CISC3000 - Final Exam - 14:30 to 17:30 :::

It includes:

  • Chapters #06 and #07
  • Quizzes #06 and #07
  • Tutorial #05 to #11
  • Project

Dear Students,
To help your revision for the final exam. There will be:

Exam Detail

Part 01 - MC with general questions

  1. 20 MCs with general questions similar to quiz #06 and #07.
    FINAL04 CISC3000 Final Review - Quiz · 语雀
    QUIZ06 CISC3000 Quiz 06
    QUIZ07 CISC3000 Quiz 07 - Chapter 07

    Part 02 - E-R Diagram

  2. 1 Question about E-R Diagram.
    You need to draw a diagram like the one at your Project or Tutorial #05.
    T05 CISC3000 Tutorial 05
    PlantUML Class Diagram Instruction
    PlantUML - 程序员必备绘图工具，不只是UML

Part 03 - SQL queries

  1. 1 Question about SQL queries such as Tutorial #06 (Ex. 02), and Tutorial #07 (Similar to midterm).
    TUR06 CISC3000 Tutorial 06
    TUR07 CISC3000 Tutorial 07

Part 04 - Normalization

  1. 2 Questions about Normalization, that can be about listing candidate keys, computing canonical cover or provide 3NF, or BCNF, decomposition. (Tutorial #08 to #11).

Review of Normalization
L07.2 Note about Normalization
Tutorial Exercise
TUR08 CISC3000 Tutorial 08
TUR09 CISC3000 Tutorial 09
TUR10 CISC3000 Tutorial 10 · 语雀
TUR11 CISC3000 Tutorial 11

Note:

There is no exercise like Tutorial #06 - Question 1.
(Grant or revoke privileges ❌)
There is no questions like Tutorial #11 Question 4 and 5.
(Design goals for relational databases & reason ❌)
(The reason of choosing non-BCNF design ❌)

On Friday, please join the Zoom meeting on time.
- You will not able to see the link for the final exam.
- You will need to open your camera for a while for attendance, then I will release the link for you.
- You need to keep yourself connected to Zoom, in case you have doubts during the exam.
Please use the CHAT to talk to me.
- I had created an anonymous questionnaire about this semester course.
It was a new experience for all of us and I would like to understand the weaknesses and strengths (if any) of this course. Please help me to answer it. It is much more simple than the usual SFQ.

Write your comments, I will survive smile! There is no connection between the questionnaire and your marks. Thank you very much. Cheers.