Question 4 (8 marks) Consider the following conceptual schema of a four-dimensional data cube. DOCTOR full-name medical-

[answerhappygod]

Question 4 8 Marks Consider The Following Conceptual Schema Of A Four Dimensional Data Cube Doctor Full Name Medical 1 (105.92 KiB) Viewed 24 times

Question 4 (8 marks) Consider the following conceptual schema of a four-dimensional data cube. DOCTOR full-name medical-licence ID PATIENT YEAR year-number MONTH nonth-number DAY day-number MEDICAL PROCEDURE cost medical-insurance ID full-name /time-spent HOSPITAL ID name address (1) Use HBase shell command language to write the commands that create HBase table implementing a conceptual schema given above. (1 mark) (2) Write the commands of HBase shell command language that insert into HBase table created in the previous step information about 2 patients, 2 doctors, 1 hospital, 2 medical procedures. (3 marks) (3) Write the commands of HBase shell command language, that perform the following data retrieval operations on Hbase table. - Find all information about a patient whose medical insurance number MI6789. (1 mark) - Find all information about the medical procedures where the costs were higher than 100. (1 mark) (4) Extend Hbase table with information about the consultations between patients and doctors. A description of a consultation consists of a consultation date and consultation topic. Write the commands of HBase shell command language that adds information about two consultations. (1 mark) (5) Extend Hbase table with information about the specialisations of doctors. Assume, that a specialisation is described by a name and level. Write the commands of HBase shell command language that adds information about a specialisation of one doctor. (1 mark)