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



SQL Help


About 400 days of visit data are stored in the data warehouse, relating to at most 100 pets and a maximum of 80 owners. Knowing that the veterinarian hospital 20 different treatments, estimate the maximum number of rows in the fact table of the star schema in question


A local veterinarian hospital keeps record about the different pets they see over time as<br>well as information about the owners and treatment provided.<br>The following tables represent a sample of the information recorded about owners, pets<br>and treatments.<br>Owners<br>LastName<br>FirstName<br>Phone<br>Downs<br>Marsha<br>555-537-8765<br>James<br>Richard<br>555-537-7654<br>Frier<br>Liz<br>555-537-6543<br>Pets<br>PetName<br>Туре<br>Breed<br>Weight<br>King<br>Dog<br>Std. Poodle<br>25.5<br>Teddy<br>Cat<br>Cashmere<br>10.5<br>Fido<br>Dog<br>Std. Poodle<br>28.5<br>Border<br>King<br>Horse<br>25.0<br>Collie<br>Treatments<br>Anesthesia_Require<br>Name<br>Vaccine<br>No<br>Dental<br>Yes<br>Surgery<br>Yes<br>

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

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here