College

We appreciate your visit to College of Computers and Information Systems Information Systems Department Data Warehousing 14023301 3 Homework Due Friday May 27th 2022 Name ID Part I We want. This page offers clear insights and highlights the essential aspects of the topic. Our goal is to provide a helpful and engaging learning experience. Explore the content and find the answers you need!

**College of Computers and Information Systems**
**Information Systems Department**
**Data Warehousing 14023301-3**
**Homework Due: Friday, May 27th, 2022**

Name: __________
ID: __________

---

**Part I**

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)

**Tasks:**

1. What is the fact table?
2. What are the facts?
3. How many dimensions have been selected? What are they?
4. What are the dimension hierarchies? Draw them.
5. Propose a relational diagram that takes into account the date, the day of the week, month, quarter, and year.

---

**Part II: Reflection Questions**

1. Describe why you believe that any company can be considered a corporate data factory.
2. Name three places where data is being collected on you and your activities.

Answer :

1. The fact table in the data warehouse for storing information on country consultations would be the CONSULTATION table.

2. The facts in the data warehouse would be the number of consultations.

3. Three dimensions have been selected: Person, Doctor, and Date.

4. The dimension hierarchies would include Person (Person_id), Doctor (Dr_id), and Date (Year, Quarter, Month, Day of the Week).

5. Please refer to the attached relational diagram that includes the date, day of the week, month, quarter, and year.

In the given scenario, the fact table in the data warehouse would be the CONSULTATION table because it contains the specific information about each consultation, such as the doctor ID, person ID, date, and price.

The facts in this data warehouse are the number of consultations. By aggregating the data in the CONSULTATION table, we can determine the total number of consultations based on various criteria, such as different people, doctors, specialties, etc.

Three dimensions have been selected for analysis in this data warehouse: Person, Doctor, and Date. The Person dimension allows us to analyze consultations based on different individuals involved. The Doctor dimension provides insights into consultations based on various specialties or individual doctors. The Date dimension allows us to analyze consultations over time, including the year, quarter, month, and day of the week.

To visualize the relationships and hierarchies within the dimensions, a relational diagram is proposed. It represents how the dimensions and fact table are connected and can provide a clear understanding of the structure and relationships within the data warehouse.

Learn more about Data warehouse

brainly.com/question/14615286

#SPJ11

Thanks for taking the time to read College of Computers and Information Systems Information Systems Department Data Warehousing 14023301 3 Homework Due Friday May 27th 2022 Name ID Part I We want. We hope the insights shared have been valuable and enhanced your understanding of the topic. Don�t hesitate to browse our website for more informative and engaging content!

Rewritten by : Barada