We want to build a data warehouse to store information on country consultations. In particular, we want to know the number of consultations, in relation to different criteria (people, doctors, specialties, etc. This information is stored in the following relationships: PERSON (Person_id, name, phone, address, gender)
DOCTOR (Dr_id, tel, address, specialty) CONSULTATION (Dr_id, Person_id, date, price)
What are the dimension hierarchies? Draw them.
Propose a relational diagram that takes into account the date, the day of the week, month, quarter and year.