Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.64PAE
(a)
Program Plan Intro
Usage map of the EER diagram based on the given assumptions.
(b)
Program Plan Intro
Based on the EER diagram, create a set of normalized relation.
(c)
Program Plan Intro
Opportunities for denormalization in given scenario.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Draw an ERD for the following situation.
Each sales representative writes many invoices.
Each invoice is written by one sales representative.
Each sales representative is assigned to one department.
Each department has many sales representatives.
Each customer can generate many invoices.
Each invoice is generated by one customer
Consider the E-R diagram in Figure 6.30, which models an online bookstore.a. Suppose the bookstore adds Blu-ray discs and downloadable video to its collection. The same itemmay be present in one or both formats, with differing prices. Draw the part of the E-R diagram that models this addition, showing just the parts related to video.b. Now extend the full E-R diagram to model the case where a shopping basketmay contain any combination of books, Blu-ray discs, or downloadable video.
E8.4 Consider the following scenario involving Pineview Ford, an auto dealership.
Auto dealership Pineview Ford is organized as follows:
• Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership.
• Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle.
• Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle.
• In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle.
Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below.
Source 1 Pineview Sales and Service Database
Source 2 Pineview Rental Log
The data warehouse has to enable an analysis of revenue by…
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
- E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by…arrow_forwardWhat are the two conditions that must be fulfillrd for a PDA to be deterministic?arrow_forwardI need help in this MCQ based on the UML attached below. Assuming there is some relationship between Car and Driver, what would be the best multiplicity to specify? Group of answer choices a)1 Car is to 1 Driver b)1 Car is to 0..1 Driver c)0..1 Car is to 0..1 Driver d)0..1 Car is to 1 Driver e)None of the givenarrow_forward
- In a dimensional model, how is transaction time commonly represented?arrow_forwardIn Question #1, instead of eliminating states of the new NFA in the order of 1, 2 and 0,arrow_forwardGiven the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee Hasan employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.arrow_forward
- Computer Science Draw the CONTEXT Digram for the given case study below: “UAETourism & Travel Agency LLC” from this year on, the tickets will be sold in three distinct ways: traditionally, i.e. by the two events agencies, in electronic format directly on the festival website, and through SBB. All parties will have access to the same unique tickets database of the new system, to avoid double selling. A partnership with the SBB railway company needs to be set up, such that SBB can sell combi-tickets including both the festival admission fee and the train ride to the festival venue at reduced price, from anywhere in Dubai. This way, more music fans would have easier and cheaper access to UAETourism . Moreover, the system will have to be extended to support not only Arabic, but also English, French and Italian. Since tickets will also be sold online, SecurePayment Inc. will be contracted to provide and ensure the security of the online payment service. The UAETourism event manager…arrow_forwardUsing the ERD diagram above, explain what would happen if the minimal cardinality was changed to “1” for Raw Materials. (i.e., the relationship becomes "raw materials are used in 1 to many items.”). Please note that the current ER diagram shows the following relationship, “raw materials are used in 0 to many items.”arrow_forwardDraw an ER diagram for the following scenarios: Library System Stanford University is having a library. Students and Faculties are eligible to issue books. If a student registers to a course, he/she must issue a book related to that course. A student can issue a maximum of 10 books and faculty can issue a maximum of 15 books. Every book has a deadline to return the book.arrow_forward
- Draw the ER Diagrams of the following cases Among the automobile manufacturing Companies, a Company manufactures many Cars, but a given car is manufactured in only one company.arrow_forwardConsider the E-R diagram in Figure 6.30, which models an online bookstore.Now extend the full E-R diagram to model the case where a shopping basket may contain any combination of books, Blu-ray discs, or downloadable video.arrow_forwardDraw the ER diagram to fulfill these requirements.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education