The total length medical services per medical facility

This assignment is due on Sunday, 14 May 2023, 8:00 pm (sharp) Singaporean Time (SGT).

This assignment is worth 20% of the total evaluation of the subject.

A submission that contains an incorrect file attached is treated as a correct submission with all consequences coming from the evaluation of the file attached.

All files left on Moodle in a state "Draft(not submitted)" will NOT be evaluated.

Whenever a property is put on the market by an owner, a description of the property is entered into an operational database. Whenever a property is purchased, its description is removed from an operational database.

(4) Find an average period of time on the market of real estate properties sold per month, year, street, city, country, and agent involved.

(5) Find the total number of times each real estate property has been sold in a given period of time.

Deliverables
A file solution1.pdf that contains
(1) a specification of data cube as a list of facts, measures, dimensions, and hierarchies obtained as a result of task (1),
(2) a perspective drawing of a three-dimensional data cube as a result of task (2).

Task 2 (5 marks)
Conceptual modelling of a data warehouse

A medical worker must hold one or more credentials that are granted to work in a particular medical facility. Doctors are allowed to deliver diagnosis and give treatment based on their specialization Paramedics are allowed to deliver only emergency diagnosis and treatment for any type of life-threatening problems. Nurses do not deliver diagnosis, but they do participate in treatment, particularly if the patient must be prepared for surgery or remain at the facility overnight.

The administration workers are concerned with personnel needs and assignments. Each medical worker must have at most one assignment at a facility. Several administration workers can be assigned to one assignment.

To draw a conceptual schema, use a graphical notation explained to you in lecture 11 Conceptual Data Warehouse Design.

To create a conceptual schema of a sample data warehouse domain, follow the steps listed below.

Deliverables
A file solution2.pdf with a drawing of a conceptual schema of a sample data warehouse domain.

Task 3 (5 marks)
Implementation of a table with a complex column type (0NF table) in Hive

(3) Include into the script SELECT statements that list the contents of the table.

When ready, use a command line interface beeline to process a script solution3.hql and to save a report from processing in a file solution3.rpt.

The data cube contains information about that parts that can be shipped by the suppliers.

Include into solution4.hql script SELECT statements that any 5 rows from each one of the external tables implemented in the previous step and the total number of rows included in each table.

When ready, use a command line interface beeline to process a script solution4.hql and to save a report from processing in a file solution3.rpt.

(1) Access Moodle athttp://moodle.uowplatform.edu.au/
(2) To login use a Login link located in the right upper corner the Web page or in the middle of the bottom of the Web page
(3) When logged select a site ISIT312 (SP223) Big Data Management (4) Scroll down to a section SUBMISSIONS
(5) Click at Assignment 2link.

(6) Click at a button Add Submission
(7) Move the zipped file A2-solutions.zip into an area You can drag and drop files here to add them. You can also use a link Add…
(9) Click at a button Save changes
(10) Click at a button Submit assignment
(11) Click at the checkbox with a text attached: By checking this box, I confirm that this submission is my own work, … in order to confirm authorship of your submission.