Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 8, Problem 8.67PAE
Problems and Exercises 8-65i5 through 8-68 refer to the large Pine Valley Furniture Company data set provided with the text.
8-67. Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 8-15 looks at a portion of that EER diagram.
Figure 8-15 Figure for Problem and Exercise 8-67
Let’s make a few assumptions about the average usage of the system:
- There are 60,000 customers, and of these, 85 percent represent regular accounts and 15 percent national accounts.
- Currently, the system stores 2,500,000 orders, although this number is constantly changing.
- Each order has an average of 30 products.
- There are 5,000 products.
- Approximately 1,500 orders are placed per hour.
- Based on these assumptions, draw a usage map for this portion of the EER diagram.
- Management would like employees only to use this
database Do you see any opportunities for denormalization?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Problems 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…
Problems 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…
Define Normalization & Normalize the following table to 3NF using excel
Chapter 8 Solutions
Modern Database Management
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Use the following diagram relation to perform the normalization. You need to provide the 2NF and 3NF.arrow_forwardProblem: Transform the table into 1NF, 2NF, and 3NF. subject Advanced student_number firstname 035-20130-0205 term lastname year 2016-2017 program BSIT 2nd Database Mairo Eli Systems Management Information 035-20130-0205 Systems Systems Analysis and 035-20130-0205 Design 2016-2017 2nd BSIT Mairo Eli 2016-2017 2nd BSIT Mairo Eliarrow_forwardDraw an E-R diagram for this situation.arrow_forward
- For each of the following E-R diagrams transform the diagram to a relational schema (draw the graphical notation). QI) COURSE Course ID Description Credits {Prerequisite} Q2) COURSE Course ID Is Prerequisite Description Creditsarrow_forwardConvert the given ER diagram to Relational Schema. Draw the complete diagram.arrow_forwardDraw an E-R data model for the Garden Glory database and Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.arrow_forward
- Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.arrow_forwardDo the tables in figure 1 exhibit entity referential integrity? Why or why not?arrow_forwardUse the following diagram relation to perform the normalization. You need to provide the Dependency Diagram and 1NF.arrow_forward
- you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities and their relationship (As given in Table) Table 4.4 Components of the ERM Entity Relationship Connectivity Entity SCHOOL operates 1:M DEPARTMENT DEPARTMENT has 1:M STUDENT DEPARTMENT employs 1:M PROFESSOR DEPARTMENT offers 1:M COURSE COURSE generates 1:M CLASS SEMESTER includes 1:M CLASS PROFESSOR is dean of 1:1 SCHOOL PROFESSOR chairs 1:1 DEPARTMENT PROFESSOR teaches 1:M CLASS PROFESSOR advises 1:M STUDENT STUDENT enrolls in M:N CLASS BUILDING contains 1:M ROOM ROOM is used for 1:M CLASS Note: ENROLL is the composite entity that implements the M:N relationship “STUDENT enrolls in CLASS.” all entities, relationships (including names), and…arrow_forwardAccording to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why or why not?arrow_forward1) The manager of an international company would like to know the quantity sold for each product and foreach store by day, week, month, and year. For each store, the manager would like to know its correspondingcity and country.You have to design a star schema to achieve the goal of this manager.2) If you think that some of your proposed dimension tables in Q1, are not normalized, you have to convertyour star schema into snowflake schema to normalize these dimension tables.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY