visits Patiens-D Doctoon Or dered Terto Phy Sian-iD physician- D Physian-ID patient - ID Name Time Speciality Test-ID Degree ičense number Reason vitaly Tests Test -ID Datt - oidned Datt - Retund Resutt patients CPT-o des vital -1D Patient-ID CPT-Code Height weight Tempenatune pulse Ratt Blood prusute Name SSN Name Description DOB PHONE PRIMARY phys/ciaD Event-Types Everds Patient ID vit al - Datt vital-Time Co de Event- ID Patient-ID Event -Code conditions Stant -Datl Dia gnosis patiend - ID phy sian - ID Con dition Daity ICDIO END -Datl Name Description Based upon the above schema: For each of the following, indicate whether the described result is a slice, a dice, a rollup, or a drilldown: An administrative worker uses the data warehouse to investigate survey scores based on patients that saw physicians with 3 specialities during the period 2017- 2018 after being diagnosed with conditions relating to lung disease. An administrative worker views results only for a particular physician while conducting a review of that physician. An HMO worker views a summary of the data by month and by year.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
visits
Patiend- D
physician- p
Doctoon
Or dered Testo
Phy sian-ID
Physian-ID
patiend -ID
Name
Time
Speciality
Test-ID
Degree
ličense number
Reason
vitals
patients
Tests
CPT-Co des
vital -1D
Test -ID
Patient-ID
CPT-Code
Height
weight
Tempenatune
pulse Ratt
Blood presure
Name
SSN
Datt -ordned
Date -Retund
Resutt
Name
Description
DOB
PHONE
PRIMARY
phys/ciaD
Evends
Event-Types
Patient ID
vit al - Datt
vital -Time
Event- ID
Patient-ID
Event -Code
Code
conditions
Stont -Datl
Diagnosis
patient - ID
phy sian - ID
Con dition
Daity
ICDIO
END - Datl
Name
Description
Based upon the above schema:
For each of the following, indicate whether the
described result is a slice, a dice, a rollup, or a
drilldown:
An administrative worker uses the data warehouse to
investigate survey scores based on patients that saw
physicians with 3 specialities during the period 2017-
2018 after being diagnosed with conditions relating
to lung disease.
An administrative worker views results only for a
particular physician while conducting a review of that
physician.
An HMO worker views a summary of the data by
month and by year.
Transcribed Image Text:visits Patiend- D physician- p Doctoon Or dered Testo Phy sian-ID Physian-ID patiend -ID Name Time Speciality Test-ID Degree ličense number Reason vitals patients Tests CPT-Co des vital -1D Test -ID Patient-ID CPT-Code Height weight Tempenatune pulse Ratt Blood presure Name SSN Datt -ordned Date -Retund Resutt Name Description DOB PHONE PRIMARY phys/ciaD Evends Event-Types Patient ID vit al - Datt vital -Time Event- ID Patient-ID Event -Code Code conditions Stont -Datl Diagnosis patient - ID phy sian - ID Con dition Daity ICDIO END - Datl Name Description Based upon the above schema: For each of the following, indicate whether the described result is a slice, a dice, a rollup, or a drilldown: An administrative worker uses the data warehouse to investigate survey scores based on patients that saw physicians with 3 specialities during the period 2017- 2018 after being diagnosed with conditions relating to lung disease. An administrative worker views results only for a particular physician while conducting a review of that physician. An HMO worker views a summary of the data by month and by year.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY