Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.50PAE
Program Plan Intro
(a)
Draw an ERD for online marketplace which sells wallpaper, draperies and home decorating accessories based on provided information.
Program Plan Intro
(b)
User above ERD to name entities, attributes and relationships which will be needed to provide answer to following queries.
- Find other customers who had bought the same product a given customer or prospective customer had bought or was considering buying.
- Find other products other customers bought who also bought the product the customer just bought.
- Find other customers with at least three interests that overlaps with those of a given customer so that he can suggest to these customers other products they might want to purchase.
Program Plan Intro
(c)
Make changes in the ERD drawn above with respect to the given information.
Program Plan Intro
(d)
Make changes in the ERD drawn above with respect to the given information.
Program Plan Intro
(e)
User above ERD to name entities, attributes and relationships which will be needed to provide answer to following queries.
- Find products bought by customers in a same geographical area.
- Search products based on categories and characteristics of product.
- Find the products as per ratings, popularity and price.
In case the above ERD is not able to handle above queries make modifications in it to handle these queries.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
ERD
The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…
The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Prob. 2.12RQCh. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - For each of the descriptions below, perform the...Ch. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - The entity type STUDENT has the following...Ch. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Prob. 2.35PAECh. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Similar questions
- The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center. Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…arrow_forwardAttracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, they are unaware of the specificities of databases and have therefore asked you to create an EER model. A large number of songs will be made available through their website, and the following information on each song needs to be stored: title, year, length, and genre. Also, artist information will be added, including date of birth, name, and a URL to a website (e.g., Wikipedia page) with additional information on the artist. You can assume an artist is uniquely identified by her name, and that a song always belongs to exactly one artist. The Musicmatic students also point out that songs having the same title are possible, and only the combination of song and artist can be assumed to be unique. The database will also have to store information on the people using Musicmatic. It was decided to only discriminate between two types of users: regular…arrow_forwardThe administrators of Tiny College are so pleased with your design and implementation of their student registration/tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s TFBS (Travel Far But Slowly) Center. Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required, destination,…arrow_forward
- I really help with this. Thank youarrow_forwardDatabase design is a crucial phase during the database life cycle (DBLC).John is the CEO of a company that produces large-scale online educationpackages. The company has decided to start from scratch with a brand new database system. He has approached you to assist him specifically with the Conceptual Design. John has provided you access to their previous system and has set up interviews for you with multiple employees that use the system. John has also requested a visual representation of the data to help him get an overview. As a businessman, John must make important decisions based on reports generated by the system. A list of the required reports has been sent to you. John has also indicated that their data will be hosted across multiple sites due to thelarge amounts of data that have to be stored.Fully explain to John how you will approach the Conceptual Design stage.Your answer must refer to the situation described above.arrow_forwardPlease follow the picture for answer these question! Vis Library is a multi-categories book library that provides a wide range of genres from kids books to special braille books. The customers can read the books on-site or choose a delivery service. As a database designer, they want you to design and implement a database to support their business. At the initial meeting to discuss the database design, the following requirements were gathered: • A new customer is required to register the account, pick the membership type, and pay the necessary cost.• The systems must be able to manage the detailed information of each member. • There are two membership types: silver dan gold. This membership is necessary to borrow books and read on the spot.• Silver membership can be obtained by showing the id card and filling the registration form without any cost.• On the other hand, Rp 20000 registration costs and Rp 10000 monthly costs are needed to get a gold membership.• Gold member…arrow_forward
- Memory updated Here’s a simplified yet complete response to each question: DBMS Evaluation for Data WarehousingWhen evaluating DBMS products for a data warehouse, the key things to focus on are performance (how fast it can process data), scalability (how well it handles large amounts of data), data integration (how easily it works with different types of data), security, and ease of use. You’ll also want to consider cost and vendor support. Recommendation on Prototyping the Data WarehouseI would recommend building a prototype because it helps the team learn the necessary skills and spot potential issues early. A prototype gives a smaller, testable version of the data warehouse, so the team can practice using the tools and technologies, leading to fewer mistakes when building the full version. Explaining Multidimensional Data AnalysisMultidimensional data analysis is like viewing data from multiple angles at once. Imagine looking at sales by product, region, and time all at…arrow_forwardJami works as an intern on a huge insurance company's sales team. Jami is requested to get a list of all of her Facebook friends and contacts and submit them to the corporate database on the first day of her internship. The team's captain says "This database contains information on all of our staff, as well as their clients and prospects. This makes it very simple to minimise repetitive client encounters while also preventing us from cannibalising consumers and revenue from one another." Jami is asking if there are any ethical concerns she should be aware of. Do you believe this circumstance raises any ethical concerns? If so, what are the specific difficulties, and how would you advise Jami?arrow_forwardWEEK 9 ASSIGNMENT# 2 ANSWER THE QUESTION BELOW: Most database management system (DBMS) vendors have now moved to the cloud via cloud service providers (CSP) that offer reliable and simple to use cloud-based DBMS services. What are DBMS vendors doing currently to meet their customers growing data needs and what new features, services and solutions are emerging to help their customers? Note: Must include two current and two emerging cloud-based DBMS vendors, providing details that describe key differences in their customer-facing services and solutions. Analysis of where DBMS vendors are headed with their cloud offerings, features, and services. Summary and conclusion.arrow_forward
- Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate…arrow_forwardDineo has given what she wants to display on the website a lot of thought. And she has come up with quite a comprehensive set of business rules 1. A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Launchpads will be created in the database even before the first launch is hosted there.2. A launchpad is located in a country, and a country in turn is located on a continent.3. Each launchpad has a name and a location.4. A launch requires three things: a launchpad that hosts it, a launch vehicle (the rocket), and the payload.5. For a launch, the date, time and name should be recorded as well as whether it is a crewed launch or not.6. Each launch is performed by a launch vehicle. The serial number for the launch vehicle should be recorded. A launch vehicle can perform multiple launches over time.7. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and whether it is reusable needs to be recorded for the launch…arrow_forwardI was hoping you could explain how Salesforce's custom settings vary from its own metaData and whether or not either may be used in formula fields. This article has been submitted by a reader who is aware of its plagiarised content.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 Learning
Database 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