Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
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
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 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 - Give an example, Other than those described in...Ch. 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 - Prob. 2.24PAECh. 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 - Prob. 2.29PAECh. 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 - Figure 2-27 represents a situation of students who...Ch. 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.46PAECh. 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_forwardDraw an ER diagram that represents the main aspects of the Apple products database (entities, attributes, relationships, mapping cardinalities, etc.) Entity Sets: Customer Preference Apple product Store Factory Product_Item Relationships: Buys Sells Contracts Produces Has Contains Customer buys apple product Store sells apple product Factory contracts_with Store Factory produces apple product Customer has preferences Store contains product_itemarrow_forwardReview: PVF manufactures high-quality wood furniture and distributes it to retail stores throughout the United States. Its product lines include dinette sets, stereo cabinets, wall units, living room furniture, and bedroom furniture. In the early 1990s, PVF’s founder, Alex Schuster, started to make and sell custom furniture in his garage. Alex managed invoices and kept track of customers by using file folders and a filing cabinet. By 1994, business expanded and Alex had to rent a warehouse and hire a part-time bookkeeper. PVF’s product line had multiplied, sales volume had doubled, and staff had increased to 50 employees. By 2000, PVF moved into its third and present location. Due to the added complexity of the company’s operations, Alex reorganized the company into the following functional areas: Manufacturing, which was further subdivided into three separate functions—Fabrication, Assembling, and Finishing Sales Orders Accounting Purchasing PINE VALLEY FURNITURE Alex and…arrow_forward
- Dineo 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_forwardPlease, can you DRAW the NEW ER diagram to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has.arrow_forwardCreate the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.)arrow_forward
- You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1 – 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track of similar information for suppliers as well (although instead of supplier first and last name, there will just be a supplier company name). The database should maintain the data on products that are offered. Information about which product is offered by which supplier should also be maintained. Finally, which customers have purchased which products should also be tracked (note that we are only interested in which customers bought which product, but not concerned about the date or how many were bought).1.1 Business RulesAssumptions for the business model are as follows: • Only customers that have purchased one or more products will exist in the database. • Only…arrow_forwardCan you draw Entity Relationship (ER) diagram based on the text. (Please use the draw.io web site for drawing.) Entity: HoneynetCentralServer Attributes: server_id (Primary Key), cronjob_interval Relationships: one-to-many with Honeypot one-to-one with LogProcessor Entity: Honeypot Attributes: honeypot_id (Primary Key), ip_address, ssh_credentials, server_id (Foreign Key) Relationships: many-to-one with HoneynetCentralServer one-to-many with LogEntry Entity: LogEntry Attributes: log_entry_id (Primary Key), timestamp, message, action_type, attack_level, honeypot_id (Foreign Key) Relationships: many-to-one with Honeypot Entity: LogProcessor Attributes: processor_id (Primary Key), rule_filters, server_id (Foreign Key) Relationships: one-to-one with HoneynetCentralServer Entity: MongoDBAtlasDatabase Attributes: database_id (Primary Key), connection_string Relationships: one-to-many with StoredLogEntry Entity: StoredLogEntry Attributes: stored_log_entry_id (Primary Key), log_entry_id…arrow_forwardExplain the difference between Salesforce's custom settings and custom metaData.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