Question
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Concepts In Federal Taxation
Authors: Kevin E. Murphy, Mark Higgins, Tonya K. Flesher
19th Edition
978-0324379556, 324379552, 978-1111579876
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App