Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please re- write this answer by keyboard In the Star Schema , the center of the table can have one fact table and

can you please re- write this answer by keyboard

In the Star Schema, the center of the table can have one fact table and a number of associated dimension tables.It is mainly used for the query of large data sets.

image text in transcribed

Dimension Table Dimension Patient Table Habite Patient ID Habit-ID Smoking Patient ID Name Age Marital Status No. of children Education Alcohol Overweight ter physical activid Fact Table Patient-ID Cancer ID Habiti Risk factor-10 Diagonistics status District Treatment Medication fus Dimension Table Dimension Table Cancer .Pk Patient-ID - ID cancer status Type of cancer Severity of Caum I Risk factor I Patient-ID Risk factor 10 family history of cancer Anemia

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

Students also viewed these Databases questions