# data[].attributes.body
Muhammad Harith Daniel Bin Kamarudin ( 2021102963 )

# data[].attributes.body
AINA SAFIAH BT SAHDAN
2021102439

# data[].attributes.body
ZAHRA BT ATAN (2021113019)

# data[].attributes.body
2021114417

# data[].attributes.attachment_link.title
NUR ADRIANA BT MD RAFII-TUTORIAL WEEK 12

# data[].attributes.body
FAZREENA BINTI MOHAMED DAUD
2021196163

# data[].attributes.body
YUMNI NAJIHAH BINTI KAMARUL BAHRIN
2021155929

# data[].attributes.attachment_link.title
Tutorial week 12 YUMNI NAJIHAH BINTI KAMARUL BAHRIN 2021155929

# data[].attributes.body
Nadia Najihah Bt Yusaini
2021114457

# data[].attributes.body
NUR AFIQAH BINTI MOHD FAWZI
2021113491

# data[].attributes.attachment_link.title
NUR AFIQAH BINTI MOHD FAWZI TUTO W12 ICT501

# data[].attributes.body
NUR AZIERA BINTI ISHAK
2021120129

# data[].attributes.attachment_link.title
TUTORIAL WEEK 12 NUR AZIERA ISHAK 2021120129

# data[].attributes.body
2021171849

# data[].attributes.body
NURUL FARHANA BINTI MOHAMAT 2021112771

# data[].attributes.attachment_link.title
NURUL FARHANA MOHAMAT 2021112771 TUTOR W12

# data[].attributes.body
NIK AIREEN YASMIN BT NIK AZAM - 2021120611

# data[].attributes.body
NURAINI FATIHAH BINTI AMRAN
2021115339

# data[].attributes.attachment_link.title
TUTORIAL 12 (NURAINI FATIHAH BINTI AMRAN 2021115339)

# data[].attributes.body
AINUN NABIHAH BT MOHD HASSAN
2021172795

# data[].attributes.body
a) Retrieve all information of the employee(s) whose salary is between RM3000 and RM4000.

b) Retrieve the name and address of all employees who work for the "Research" department.

c) For each project located in "Shah Alam", list the project number, the controlling department number and the department manager's name and birth date.

d) Display the names of all employees who did not have any dependents.

e) Retrieve the project number, the project name and the number of employees who work on the project more than 5 employees.

f) Create table DEPENDENT with integrity requirements.

# data[].attributes.body
ZAHRA ATAN
2021113019

# data[].attributes.body
AINAA RAHILA BT ABD RAHMAN
2021120213

# data[].attributes.body
YUMNI NAJIHAH BINTI KAMARUL BAHRIN
2021155929

# data[].attributes.attachment_link.title
WEEK 11_YUMNI NAJIHAH BINTI KAMARUL BAHRIN 2021155929

# data[].attributes.body
Fazreena Mohamed Daud

# data[].attributes.body
AINA SAFIAH BT SAHDAN
2021102439

# data[].attributes.body
NADIA NAJIHAH BT YUSAINI

# data[].attributes.attachment_link.title
TUTORIAL W11 NADIA NAJIHAH BINTI YUSAINI 2021114457

# data[].attributes.headline
NUR ADRIANA BT MD RAFII @ MAZLAN (2021114417)

# data[].attributes.subject
NUR ADRIANA BT MD RAFII @ MAZLAN (2021114417)

# data[].attributes.body
NUR AFIQAH BINTI MOHD FAWZI
2021113491

# data[].attributes.attachment_link.title
NUR AFIQAH BINTI MOHD FAWZI 2021113491 TUTO W11

# data[].attributes.attachment_link.title
Ict Week9 MUHAMMAD ALIF IZZUDDIN BIN MAT TA'EH (2021702445)

# data[].attributes.body
2021171849

# data[].attributes.body
NURUL FARHANA BINTI MOHAMAT 2021112771

# data[].attributes.attachment_link.title
NURUL FARHANA BINTI MOHAMAT 2021112771 TUTORIAL WE

# data[].attributes.body
Ainun Nabihah bt Mohd Hassan
2021172795

# data[].attributes.body
NURAINI FATIHAH BINTI AMRAN
2021115339

# data[].attributes.attachment_link.title
TUTORIAL WEEK 11 (NURAINI FATIHAH BINTI AMRAN 2021115339)

# data[].attributes.body
NUR AZIERA BINTI ISHAK
2021120129

# data[].attributes.attachment_link.title
TUTORIAL W11 NUR AZIERA ISHAK 2021120129

# data[].attributes.body
You are the sales manager in a computer company and you need to look at the data from a product manager and a financial analyst perspectives.

a)Illustrate a three-dimensional data cube that compares the sales of various products in different cities for January 2018 and February 2018. This view of the data might be useful to identify products that are performing poorly in certain cities.

b)Illustrate a three-dimensional data cube that shows quantity of various products shipped during a four-month period in Terengganu and Kelantan. This view of the data is the basis for trend analysis.

c) Name and illustrate a multidimensional schema to represent both of the scenarios in i and ii in one diagram.

# data[].attributes.body
Based on Table 2.0 below, answer the followings:
a) Draw a 3-dimensional data cube for total number of students for each programme at different branches for semester March - July 2017.
b) Explain 2 advantages of multidimensional representation over relational representation for student enrollment.

# data[].attributes.attachment_link.title
Chapter 7 & 8 - Distributed Database Management Systems

# data[].attributes.headline
Muhammad Harith Daniel Bin Kamarudin (2021102963)

# data[].attributes.subject
Muhammad Harith Daniel Bin Kamarudin (2021102963)

# data[].attributes.attachment_link.title
Muhammad Harith Daniel Bin Kamarudin Toturial 9

# data[].attributes.body
2021303919

# data[].attributes.body
LILY NUR SAQINAH BT IDHAM WAZIR (2021101837)

# data[].attributes.attachment_link.title
ICT 501_TUTORIAL WEEK 9_LILY NUR SAQINAH BT IDHAM WAZIR_2021101837

# data[].attributes.body
Nik Aireen Yasmin bt Nik Azam - 2021120611

# data[].attributes.attachment_link.title
tutorial week 9_ Fazreena Mohamed Daud_2021196163

# data[].attributes.headline
NUR ADRIANA BT MD RAFI @ MAZLAN (2021114417)

# data[].attributes.subject
NUR ADRIANA BT MD RAFI @ MAZLAN (2021114417)

# data[].attributes.body
YUMNI NAJIHAH BINTI KAMARUL BAHRIN
2021155929

# data[].attributes.attachment_link.title
TUTORIAL WEEK 9 YUMNI NAJIHAH BINTI KAMARUL BAHRIN_2021155929_

# data[].attributes.body
2021171849

# data[].attributes.attachment_link.title
TUTORIAL 7 NADIA NAJIHAH BINTI YUSAINI 2021114457

# data[].attributes.body
2021341121

# data[].attributes.body
AINA SAFIAH BINTI SAHDAN
2021102439

# data[].attributes.attachment_link.title
TUTORIAL CH7&8_AINA SAFIAH BINTI SAHDAN 2021102439 CS2413A

# data[].attributes.body
NUR AFIQAH BINTI MOHD FAWZI
2021113491

# data[].attributes.attachment_link.title
NUR AFIQAH BINTI MOHD FAWZI TUTO W9 ICT501

# data[].attributes.body
NURAINI FATIHAH BINTI AMRAN
2021115339

# data[].attributes.attachment_link.title
TUTORIAL WEEK 9 (NURAINI FATIHAH BINTI AMRAN)

# data[].attributes.body
AINUN NABIHAH BINTI MOHD HASSAN
2021172795

# data[].attributes.body
NIK AIREEN YASMIN BINTI NIK AZAM - 2021120611

# data[].attributes.body
NURUL FARHANA BINTI MOHAMAT 2021112771

# data[].attributes.attachment_link.title
NURUL FARHANA BINTI MOHAMAT 2021112771 TUTORW9

# data[].attributes.body
NUR AZIERA BINTI ISHAK
2021120129

# data[].attributes.attachment_link.title
TUTORIAL WEEK 9 NUR AZIERA BINTI ISHAK 2021120129

# data[].attributes.body
Reconstruct the relations from the fragments for Question 2.

# data[].attributes.body
Suggest a relation which is suitable for derived horizontal fragmentation for Question 1. Give a reason for the answer. Show the derived horizontal fragments in SQL.

# data[].attributes.body
Based on the above scenario, which of the above relations would you horizontally fragment? Give a reason for your answer. Show the fragments in SQL.

# data[].attributes.body
An international oil and gas company has decided to distribute its project information database based on the regional distribution. The current centralized relational schema is diagram below:

Departments are grouped regionally as follows:

Region 1: Kuala Lumpur
Region 2: Paris
Region 3: New York

# data[].attributes.attachment_link.title
Chapter 7 & 8 - Distributed Database Management Systems

# data[].attributes.body
2021110239

# data[].attributes.attachment_link.title
NURUL DAYANA BINTI ZAHARIN SHAH ict tuto week 7

# data[].attributes.body
LILY NUR SAQINAH BT IDHAM WAZIR (2021101837)

# data[].attributes.attachment_link.title
ICT 501_TUTORIAL WEEK 6_LILY NUR SAQINAH BT IDHAM WAZIR_2021101837

# data[].attributes.body
2021171849

# data[].attributes.headline
NUR ADRIANA BT MD RAFII @ MAZLAN (2021114417)

# data[].attributes.subject
NUR ADRIANA BT MD RAFII @ MAZLAN (2021114417)

# data[].attributes.body
NUR AFIQAH BINTI MOHD FAWZI
2021113491

# data[].attributes.attachment_link.title
NUR AFIQAH BINTI MOHD FAWZI 2021113491 TUTO W7

# data[].attributes.body
LILY NUR SAQINAH BT IDHAM WAZIR (2021101837)

# data[].attributes.attachment_link.title
ICT 501_TUTORIAL WEEK 7_LILY NUR SAQINAH BT IDHAM WAZIR_2021101837

# data[].attributes.body
2021393819

# data[].attributes.body
NURUL FARHANA BINTI MOHAMAT 2021112771

# data[].attributes.attachment_link.title
NURUL FARHANA BINTI MOHAMAT 2021112771  TUTO W7

# data[].attributes.attachment_link.title
Fazreena Binti Mohamed Daud (2021196163) _ tutorial (week7)

# data[].attributes.body
AINUN NABIHAH BT MOHD HASSAN
2021172795

# data[].attributes.body
NIK AIREEN YASMIN BINTI NIK AZAM - 2021120611

# data[].attributes.body
AINAA RAHILA BT ABD RAHMAN
2021120213

# data[].attributes.body
NUR AIN NAZIRAH BINTI MOHD HASSANI
2021149331

# data[].attributes.attachment_link.title
ICT501 TUTORIAL WEEK 7 NUR AIN NAZIRAH BINTI MOHD HASSANI-converted

# data[].attributes.body
YUMNI NAJIHAH BINTI KAMARUL BAHRIN
2021155929

# data[].attributes.attachment_link.title
TUTORIAL WEEK 7 YUMNI NAJIHAH BINTI KAMARUL BAHRIN 2021155929

# data[].attributes.body
2021341121

# data[].attributes.body
AINA SAFIAH SAHDAN
2021102439

# data[].attributes.attachment_link.title
AINA SAFIAH SAHDAN 2021102439_TUTORIAL ch6

# data[].attributes.body
NUR AZIERA BINTI ISHAK
2021120129

# data[].attributes.attachment_link.title
TUTORIAL WEEK 7 NUR AZIERA BINTI ISHAK 2021120129

# data[].attributes.body
NURAINI FATIHAH BINTI AMRAN
2021115339

# data[].attributes.attachment_link.title
ICT501 TUTORIAL WEEK 7 (NURAINI FATIHAH BINTI AMRAN_2021115339)

# data[].attributes.attachment_link.title
TUTORIAL 6 NADIA NAJIHAH BT YUSAINI (2021114457)

# data[].attributes.body
Please answer midterm exam from oracle academy module: DP Database Programming with SQL Learner.
GOOD LUCK!!

# data[].attributes.body
Describe three (3) failure types in transaction management.

# data[].attributes.body
Considering the log information that involves three transactions in Figure 2.0. Assume that the immediate update protocol with check pointing is used for crash recovery. Explain the restart work necessary for the three transactions.

# data[].attributes.body
2021110239

# data[].attributes.body
2021110239

# data[].attributes.body
NUR AYUSHA BINTI CHE DAUD
2021120201

# data[].attributes.body
Ainaa Rahila bt Abd Rahman
2021120213

# data[].attributes.attachment_link.title
Transaction Tutor W6_AINAA RAHILA BT ABD RAHMAN

# data[].attributes.body
(2021171849)

# data[].attributes.body
NUR AIN NAZIRAH BINTI MOHD HASSANI
2021149331

# data[].attributes.attachment_link.title
ICT501 TUTORIAL WEEK 6 NUR AIN NAZIRAH BINTI MOHD HASSANI

# data[].attributes.body
NUR AFIQAH BINTI MOHD FAWZI
2021113491

# data[].attributes.attachment_link.title
NUR AFIQAH BINTI MOHD FAWZI 2021113491 ICT501 TUTO W6

# data[].attributes.body
NURUL FARHANA BINTI MOHAMAT 2021112771

# data[].attributes.attachment_link.title
NURUL FARHANA BINTI MOHAMAT 2021112771 WEEK6

# data[].attributes.body
Nadia Najihah Bt Yusaini
2021114457

# data[].attributes.attachment_link.title
TUTORIAL 5_NADIA NAJIHAH BT YUSAINI (2021114457)

# data[].attributes.body
2021114417

# data[].attributes.body
YUMNI NAJIHAH BINTI KAMARUL BAHRIN
2021155929

# data[].attributes.attachment_link.title
TUTORIAL WEEK 6 YUMNI NAJIHAH BINTI KAMARUL BAHRIN (2021155929)

# data[].attributes.body
MUHAMMAD IMRAN BIN SAIDI
2021393819