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
Review:
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…
Choose a title, e.g.
Database. (Company, Music, Movie, Library, Hospital or
......
University Databases are not accepted, because these databases are mentioned a lot on
lectures or Internet)
1. Create a list of data items that will be stored in your project. For example, in
library project, you may ask the librarian about business requirements.
2. List all the business requirements that you gathered from users. Make sure to
explain what requirements gathering method you used.
3. Find and list all entities.
4. Find the attributes of entities (the attributes are data items that you already
found)
5. Define restrictions for each attribute (e.g. Number of digits in student ID,
range of values for Age attribute )
6. Define relationships between entities and their types (Explain how you found
the type of the relationships)
7. Create Entity-Relation (ER) model of your database.
8. Create necessary tables for your database.
9. Insert data in your tables.
10. Show in which normal forms your…
It's likely that this is what's being discussed on your data warehousing project team right now: whether or not to create a data warehouse prototype initially. In order to be ready for the enterprise-wide data warehouse, you'll need to learn some data warehousing basics. In other words, what do you want to say? So, what are your thoughts?
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
- I 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_forwardQuery design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:arrow_forwardquastion is draw ER digram ?Project Description: You need to develop a management information system to help users at the administration level of the university easily viewing/tracking various information about students , information about number modules had taken by students , information about departments, Name of the lecturers are teach the course and information about courses . Data Model: We need to store information about university organized into colleges .each college has college number, college name. Each department has dep_number dep_name and locations .each lab has number and lab name . We store each student's number, name(last_name,first_name)address contain (zip, street city), birthdate, age . Each department offers several coursers. Each course identified by code,coures_name .each course has many perquisite and Students enroll in many course by semester and year. Each lecturer has lecturer _id , lecturer name ,mails ,salary address Each course is…arrow_forward
- The processes used to complete a data science project vary in their number of steps and functions, but in the end, the objectives and outcomes are similar. Research on the Web to identify what you believe to be the set (version) of steps that you'd use to complete a Data Science project. You should find versions with 5, 7, 9, 11, 12, or more steps. If you choose a particular set of steps, cite your source and explain why you would use that approach. If you wish, you can develop your own approach, drawing on the research, if you think there may be a better way. As you get deeper into Data Science, in subsequent courses, you should learn the validity of your approach. List the steps of your approach, cite its source, and provide an explanation of why this particular approach would work best for you.arrow_forwardYou and your friends are considering creating an electronic database that would contain all the information available to troubleshoot and repair every make and model of car from 2006 forward. The database would include do-it-yourself repair information, exploded schematics of automobile engines, wiring diagrams, recall information, and technical service bulletins, among other data. Subscribers would be able to enter the year, make, and model of a car along with a description of the problem and get all the information needed to work on that specific car. Most of the data would be scanned in from existing sources. Special software would be written to convert the user's problem description into a description recognized by the system's search engine, which would then generate queries to retrieve and present the most pertinent information to solve the problem. What intellectual property issues might you and your friends encounter in digitizing all these existing information? How might you…arrow_forwardIf your data warehousing project team is considering whether to construct a data warehouse prototype first, this is what they are discussing. In order to be ready for the enterprise-wide data warehouse, you'll need to learn some data warehousing basics. So, what are your thoughts? I want to hear what you have to say.arrow_forward
- Create an ERD: entity relationship diagram for the situation below using the CROWS feet method Jersey athletics has decided to put a periodic survey on their website to engage more users in brand and the opportunities the business has to offer. The marketing team of DBD Sports will provide the survey topics, questions, and multiple choices fi each question. As the web developer, you are tasked with loading the survey during a specified time period on the site. no need to track WHO answers the survey, but jersey athletics Marketing would like to track the responses to each question. A total of 6 surveys will initially loaded into the database ranging from topics on personal health to team sports to nutrition. Each survey will be related to a particular topic. Marketing will specify the start and end date for each survey. Only one will be displayed on the site at a time. Each survey will have at least 10 questions. Each question will have at least 3 choices. Each visitor will be…arrow_forwardSubmit your final project as one or more text files as well as an image of an ER diagram. Your project should include an ER diagram of a small business database, queries to create database tables and constraints, queries to populate tables with data and questions and queries to create your reports that are specified in the rubric for this project.arrow_forwardThe Vegan Garden is a modest eatery located in Dawnsville, a sleepy town. The restaurant has been in business for five years. Currently, sales are captured manually using cash registers, and monthly sales reports and other company papers such as employee and supplier information are stored in antiquated file cabinets. Vegan Garden's proprietor has opted to create an information system. He sought the assistance of an information technology firm to develop an information system that would be compatible with the Vegan Garden's present business operations. You have been designated project manager for the Vegan Garden information system's development. As the development project's project manager, educate the owner of Vegan Garden about information system security problems. Describe ANY FIVE (5) OF THE MOST POPULAR SECURITY THREATS THAT AFFECT INFORMATION SYSTEMS.arrow_forward
- Do you have any suggestions for specific ways that may be utilized to capture the flow of data?arrow_forwardWhat are the Adventure Works KPIs? Since you are part of the technical team who will create and design the Data Warehouse, create a document with ten questions. Write questions to include “Measurements”, “By” and “For” terminology.arrow_forwardb) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)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