Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 9.38PAE
Program Plan Intro
To convert the star schema to a snowflake schema for the Millennium college and explain if it impacts the size of the fact table for this problem.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
For each consistency error in Figure 1, you should identify the consistency rule violated and suggest possible resolutions of the error. The ERD has generic names to help will concentrate on finding diagram errors rather than focusing on the meaning of the diagram
Study the details below and create ERD diagram for each question below.
Drone / Video: a Drone may take many Videos; a Video is taken by one Drone.
A Video instance is optional for a Drone; a Drone instance is required for a Video.
A Facility may be recorded by many Videos; a Video records one Facility.
A Video instance is optional for a Facility; a Facility instance is required for a Video.
A Video may be the basis of many Analyses; an Analysis is based on one Video.
An Analysis instance is optional for a Video; a Video instance is required for an Analysis
(a) Explain carefully four ways in which the diagram fails to model the intended world. In each case make sure you contrast the actual meaning with the intended meaning.
(b) Give an entity-relationship diagram, still using two entity types, which correctly models the intended world.
(c) Give a database schema (including primary keys) for the ER diagram which you have given in the previous part.
(d) Is there any part of the ER diagram which is not captured in the schema? How might this aspect be captured in the final database?
Chapter 9 Solutions
Modern Database Management
Ch. 9 - Prob. 9.1RQCh. 9 - Prob. 9.2RQCh. 9 - Prob. 9.3RQCh. 9 - List the five major trends that necessitate data...Ch. 9 - Prob. 9.5RQCh. 9 - Prob. 9.6RQCh. 9 - Prob. 9.7RQCh. 9 - Prob. 9.8RQCh. 9 - Prob. 9.9RQCh. 9 - Prob. 9.10RQ
Ch. 9 - List four objectives of derived data.Ch. 9 - Prob. 9.12RQCh. 9 - Prob. 9.13RQCh. 9 - Explain the pros and cons of logical data marts.Ch. 9 - Prob. 9.15RQCh. 9 - What is a helper table, and why is it often used...Ch. 9 - Describe the characteristics of a surrogate key as...Ch. 9 - Prob. 9.18RQCh. 9 - What is the purpose of conformed dimensions for...Ch. 9 - Prob. 9.20RQCh. 9 - Prob. 9.21RQCh. 9 - Prob. 9.22RQCh. 9 - Prob. 9.23RQCh. 9 - Prob. 9.24RQCh. 9 - Prob. 9.25RQCh. 9 - Describe the current key trends in data...Ch. 9 - Discuss the benefits of offering data warehousing...Ch. 9 - Prob. 9.28RQCh. 9 - List six typical characteristics of reconciled...Ch. 9 - Prob. 9.30RQCh. 9 - Prob. 9.31RQCh. 9 - Prob. 9.32RQCh. 9 - Prob. 9.33RQCh. 9 - Describe some field-level and record-level data...Ch. 9 - Prob. 9.35PAECh. 9 - Prob. 9.36PAECh. 9 - Prob. 9.37PAECh. 9 - Prob. 9.38PAECh. 9 - You are to construct a star schema for Simplified...Ch. 9 - Simplified Automobile Insurance Company would like...Ch. 9 - Prob. 9.41PAECh. 9 - Prob. 9.42PAECh. 9 - Prob. 9.43PAECh. 9 - Prob. 9.45PAECh. 9 - Prob. 9.46PAECh. 9 - Prob. 9.47PAECh. 9 - Prob. 9.48PAECh. 9 - Prob. 9.49PAECh. 9 - Prob. 9.50PAECh. 9 - Prob. 9.51PAECh. 9 - Prob. 9.52PAECh. 9 - Prob. 9.53PAECh. 9 - Prob. 9.54PAE
Knowledge Booster
Similar questions
- 7-48. Review the data-flow diagrams given to you by your instructor. Study the data flows and data stored in these diagrams and decide whether you agree with the team’s conclusion that the only six entity types needed are listed in the case and in PE Figure 7-1. If you disagree, define additional entity types, explain why they are necessary, and modify PE Figure 7-1 accordingly.arrow_forwardBased on the provided information below, what is the ERD Diagram to this fictional senerio that includes its primary key and attributes?arrow_forwardProblems 1 and 3 on pages 234 - 236 of the course textbook. You must use Draw.IO or MS Visio to complete this case study.Create an ER diagram Explain all normalization issues that exist in the ER Diagram. I want the ER Diagram before normalization and after normalization. Explain all normalization problems that you corrected between the first and second ER diagram. Normalize the data in the ER Diagram to 3NF See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=Nq91b4TQ29Q Create a dependency diagram using the information from your ER diagram. See the video for a demonstration on how to do this: https://www.youtube.com/watch?v=wFOJnRxqrp8 You must label all determinants and dependencies. Note: You must convert your DrawIO files to .jpg, gif or bmp images before you upload the assignment to Canvas. Copy and paste all diagrams into an MS Word document. Please make sure that you enlarge all diagrams so they can be easily…arrow_forward
- Develop a simple data model for a student database that includes student data, student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete entity relationship diagram that shows how these tables are related to one another.arrow_forwardWhat exactly are entity-relationship diagrams, and how do they come into play? What kind of symbol is utilized to represent a relationship? What is an associative entity, and how does it work? Give an illustration of your point.arrow_forward1. To create the ERD for the SIM system, the Entity - Relationship Diagram, which helps to describe the database for a computer system, go back to the information system DFD you created for Assignment 4 and just label the data flow arrows using the cardinality notation. That will show the relationship between the entities on your ERD. 2. To design sample data tables from the ERD you created in #1, you need to think of the objects that will be part each process. These objects will become the column headers for your table. So for example, the Customers table will have fields like name and address, and their household should have an ID #. Do this for all the objects in your ERD. Carlie asked that the database be a 3NF or Third Normal Form, all that means is that you will have a simple, one field, primary key for each of your data tables. No data repeats in any table and all of the fields in a table are dependent on its primary key. So you should create 6 data tables, one for each of the…arrow_forward
- What is the precise definition of a weak entity type? What is the undisclosed information? Could you please provide an example? What is the definition of alternative specialization?What is my representation on the Entity-Relationship (ER) diagram? Please provide more context or information about the example and diagram you are referring to. What subject or topic is this related to?arrow_forwardPlease provide a description of the best practices for developing excellent data-flow diagrams.arrow_forwardWhat is the main role of an ER diagram in data modelling? How many courses each student can have? What is the relationship degree between the entities? Ternary Is there an associative entity, if yes can you name it? What is uniquely identifying the student entity table (Primary Key)?arrow_forward
- You might lay up the advantages and disadvantages of using the star schema rather than the snowflake model instead of choosing the snowflake model. Which one departs from the standard more than the other does and by what measure?arrow_forwardFor each entity, there needs to be an indication of whether it is one-to-one, one-to-many or many-to-many relationship. Here are the answers I have but I could use more guidance with it. I struggle with this type of question. BOOK and BOOK COPY (1:1) COURSE and COURSE-SECTION (M:N) COURSE-SECTION and ROOM (M:1) INSTRUCTOR and COURSE (1:M) ROOM and INSTRUCTOR (M:1)arrow_forwardIn the ER-Model, what are the guidelines for properly recognizing entities and developing connections between them?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning