Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In EMPLOYEE table, ESalary is monthly salary. ESSN EName ESalary DNO E123 Rauf E223 Ahmed 12000 E323 Rizwan 20000 E423 Rauf E523 Umer DEPTNO

 

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Information Package is used for determining and storing information need for a Dataware... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts In Federal Taxation

Authors: Kevin E. Murphy, Mark Higgins, Tonya K. Flesher

19th Edition

978-0324379556, 324379552, 978-1111579876

More Books

Students also viewed these Databases questions

Question

Name the subdivisions of the Internal Revenue Code.

Answered: 1 week ago

Question

12. What kinds of people are most likely to develop sleep apnea?

Answered: 1 week ago