This veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information represented in the previous tables about the pet, owner and treatment. It is also essential to record data about the date of the visit, including the day, month and year. Finally, the visit fee should be recorded. Note that there is no flat fee for each treatment as the treatment cost can vary depending on the pet type. Based on all these information, draw a star schema for this specific part of data warehouse focusing on recording data related to each visit.
This veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information represented in the previous tables about the pet, owner and treatment. It is also essential to record data about the date of the visit, including the day, month and year. Finally, the visit fee should be recorded. Note that there is no flat fee for each treatment as the treatment cost can vary depending on the pet type. Based on all these information, draw a star schema for this specific part of data warehouse focusing on recording data related to each visit.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
SQL Help
This veterinarian hospital wants to set up a data warehouse containing various information about the business.
One section of this data warehouse should focus on recording information related to each pet visit to the hospital.
For each of the visit, it is essential to record the various information represented in the previous tables about the pet, owner and treatment.
It is also essential to record data about the date of the visit, including the day, month and year.
Finally, the visit fee should be recorded. Note that there is no flat fee for each treatment as the treatment cost can vary depending on the pet type.
Based on all these information, draw a star schema for this specific part of data warehouse focusing on recording data related to each visit.
Transcribed Image Text:A local veterinarian hospital keeps record about the different pets they see over time as
well as information about the owners and treatment provided.
The following tables represent a sample of the information recorded about owners, pets
and treatments.
Owners
LastName
FirstName
Phone
Downs
Marsha
555-537-8765
James
Richard
555-537-7654
Frier
Liz
555-537-6543
Pets
PetName
Туре
Breed
Weight
King
Dog
Std. Poodle
25.5
Teddy
Cat
Cashmere
10.5
Fido
Dog
Std. Poodle
28.5
Border
King
Horse
25.0
Collie
Treatments
Anesthesia_Require
Name
Vaccine
No
Dental
Yes
Surgery
Yes
Transcribed Image Text:Team
City
Los Angeles
TeamID
TeamName
State
Win
Loss
1001
Wildcats
CA
10
3
1002
Hawks
San Francisco
CA
8
1003
Renegades
San Jose
CA
4
1004
Gators
San Francisco
CA
10
Player
PlayerID
TeamID
CollegelD
PlayerName
Age
Position
101
1001
1080
Julio Peters
23
WR
102
1003
1080
Lance Randolph
29
QB
103
1003
2001
Timothy Haas
27
ТЕ
115
Joey Daniel
1002
1478
32
LB
106
1004
1479
Hobert Golden
25
FB
110
1001
1478
Hunter Padilla
21
QB
College
CollegelD
CollegeName
Gator University
City
State
1478
San Francisco
CA
Hogwart College
Stark College
1479
San Francisco
CA
1080
Los Angeles
CA
2001
Data University
Portland
OR
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education