Question
Scenario: You work for the sales department of BikesRUs, a manufacturer of high-end mountain bikes. You are tasked to participate in the development of a
Scenario:
You work for the sales department of BikesRUs, a manufacturer of high-end mountain bikes. You are tasked to participate in the development of a data model that will be used to create a database to store and keep track of data that is important to the business. The data base will help in creating reports with information about the operations of the business.
The sales department of BikesRUs has a set list of bicycles they sell and a list of frequent customers. BikesRUs customers are retail stores and small shops. Sales reps work with customers facilitating bike selection, purchases, or addressing any concern before and after the sale.
BikeRUs collects and stores data on:
customers - including their contact information, address, and names, credit information
bicycles - including name, description, cost, storage location.
salereps - including name, phone, commission rate
orders - including dates, customer and rep who place order and the bike that was sold and the price paid.
Review the ER-Diagram material in Chapter 5 Appendix in your textbook and the tutorials in this section.
Using the scenario of BikesRUs, identify the entities, attributes, and relationships between entities that exist.
Note that the relationship between entities can be 1:1 and 1:N. That is, a specific customer can place many (N) orders, but one specific order belongs to only one customer (1).
Draft an Entity-Relationship diagram using the entities, attribute, and relationships you identified:
- Draw a box for each entity you identified.
- Within each box (entity), write the attributes that describe the entity.
- Link the boxes (entities) with arrows to show the relationship between them.
- Use proper ER-Model notation (Crows Feet Notation)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started