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.
Extracted 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
Extracted 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