HomeworkLib
Question

in which normal form is the fact tables in data warehouses schemas (snowflake, star and fullfact...

in which normal form is the fact tables in data warehouses schemas (snowflake, star and fullfact schemas)?

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution :-

Star Schema -

In Star schema the fact tables are in third normal form(3NF).

Snowflake schema -

  • Here in this schema it has fact table surrounded by multiple dimension tables which in turn can be connected to other dimension tables with many-to-one relationship.
  • The snowflake schema is more complex as compared to star schema.
  • Thus is snowflake schema we have a group of multiple dimension tables instead of big dimension tables connected to a fact table.
  • In Snowflake schema the dimension tables are in third normal form(3NF).
0 0
Add a comment
Know the answer?
Add Answer to:
in which normal form is the fact tables in data warehouses schemas (snowflake, star and fullfact...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Question 2) For each of the tables below: A) Determine the highest normal form the table...

    Question 2) For each of the tables below: A) Determine the highest normal form the table is in B) Explain your answer (why that is the highest normal form for the table) Tables: OFFICER_INITIATIVE_DETAILS (initiativeID, cause, officerID) SOLICITATIONS (solicitID, solicitType, solicitChannelAndDate, collegeID, collegeName, donorID)

  • Present data in the form of tables. For each data set shown by the table, make...

    Present data in the form of tables. For each data set shown by the table, make a scatter plot with data given. Use the scatter plot to find whether an exponential function, a logarithmic function, or a linear function is the best choice for modeling the data year percent 1970 50 1980 64 1990 67 2000 70 2020 70

  • Using tables and charts below, explain the criteria for 3rd Normal Form and normalize the table...

    Using tables and charts below, explain the criteria for 3rd Normal Form and normalize the table you obtained for the previous question to meet them. Also , is the table you obtained for the previous question in BCNF? School_ID Course_ID Grade Student_Name Department Tuition Fee Instructor COP01, COPO2, COPO3 A, A, B John Smith BU01, BU02 B, B Roger Hicks CISE 4114123 3124234 250 James, Andrew, Peter Alan, Alan Business 300

  • Question 1 A data warehouse differs from an operational database in that most data warehouses have...

    Question 1 A data warehouse differs from an operational database in that most data warehouses have a product orientation and are designed to handle transactions that update the database. Select one: True False Question 2 An operational data store (ODS) provides a fairly recent form of a customer information file (CIF), which is often used as an interim staging area for a data warehouse. Select one: True False Question 3 An advantage of the hub-and-spoke data warehouse architecture is that...

  • Determine which strategies are dominated in the following normal-form games.

    Determine which strategies are dominated in the following normal-form games.

  • Part C:Analyzing KE datatables Analyze the following data tables containing KE DATA, Identity which data is...

    Part C:Analyzing KE datatables Analyze the following data tables containing KE DATA, Identity which data is consistent with an object that is SPEEDING UP, which one is consistent with an obiect that in SLOWING DOWN, which one is consistent with an object that moving at a CONSTANT SPEED. and which one is consistent with an abject that is AT REST. You will only Hosive credit when all four have been chosen correctly. Time (S) KE(J) 100 200 300 14 4233...

  • #1 & #4 ? 1. Which of the quantities recorded in Data Tables 4 and 5...

    #1 & #4 ? 1. Which of the quantities recorded in Data Tables 4 and 5 are base measures and which are derived measurements ? Explain your answer. O Word(s) в і у T T. 4. What are the material compositions of the marble and the density cylinder? Use Data Table 5 and Table 3 to explain your answer SET T. O Word(s) Data Table Photo 1 mm Data Table Photo 2 Data Table 3 Photo 3 Data Table 4...

  • Question 1 Design a database, satisfying the rules of third normal form (3NF), to represent the d...

    Question 1 Design a database, satisfying the rules of third normal form (3NF), to represent the data in Figure 1. This data set contains information about different breakfast cereals and the companies that make them You can work with a pen and paper to decide how many tables wll be in your database and the contents of each table Company Cereal Colourful Company's country Region Kellogg's Kellogg' s Uncle Toby's Uncle Toby's Harraways Froot Loops Corn Flakes Vita Brits Weeties...

  • 2) What normal form is this data in? Why? 3) What is the primary key of...

    2) What normal form is this data in? Why? 3) What is the primary key of this table? 4) Draw a functional dependency diagram for this table 5) From your functional dependency diagram, determine the maximum set of 3NF tables that could be generated to minimize the data in the original table the most. Include tabulations (i.e., show the data) for your tables. Underline the primary key of each table. Circle or highlight the total number of tables you developed....

  • To be in the third normal form, Hint: In order to in 3NF you must first...

    To be in the third normal form, Hint: In order to in 3NF you must first have attained 1NF and 2NF so all of the above is the correct answer. In the database design world the saying is that to be completely normalized the data be represented "by the key, the whole key, and nothing but the key so help me Codd". Ted Codd was the person behind the development of the relational theory back in the 1960s and 70s....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT