In EMPLOYEE table, ESalary is monthly salary. ESSN EName ESalary DNO E123 Rauf E223 Ahmed 12000...

 

Transcribed Image Text:

In EMPLOYEE table, ESalary is monthly salary. ESSN EName ESalary DNO E123 Rauf E223 Ahmed 12000 E323 Rizwan 20000 E423 Rauf E523 Umer DEPTNO DNAME DLOC GRADE LOSAL HISAL 5000 10001 10000 10 10 Sales RWP 10000 20000 10 20 HR KHI Purchase LHR 20001 20 17000 30000 30 7 30000 30 30 A) What is an Information Package? Create an information package for a Hotel business and explain it. B) Create a star schema based on information package you have created in part A and also explain "Grain" which you have set for creating star schema. C) Write the statements of any three queries on the star schema you have created in part B to show drill down operation. In EMPLOYEE table, ESalary is monthly salary. ESSN EName ESalary DNO E123 Rauf E223 Ahmed 12000 E323 Rizwan 20000 E423 Rauf E523 Umer DEPTNO DNAME DLOC GRADE LOSAL HISAL 5000 10001 10000 10 10 Sales RWP 10000 20000 10 20 HR KHI Purchase LHR 20001 20 17000 30000 30 7 30000 30 30 A) What is an Information Package? Create an information package for a Hotel business and explain it. B) Create a star schema based on information package you have created in part A and also explain "Grain" which you have set for creating star schema. C) Write the statements of any three queries on the star schema you have created in part B to show drill down operation.

Answer rating: 100% (QA)

Information Package is used for determining and storing information need for a Dataware... View the full answer