Question: Question 6 Using a case study as an example: Rebel Sports Store has a chain of retails stores who sells athletic products such as shirts,

Question 6

Using a case study as an example:

Rebel Sports Store has a chain of retails stores who sells athletic products such as shirts, shorts, and shoes. Rebel sources its athletic shirts only from Global Athletic Apparel Manufacturer (GAAM) while the other products are from different manufacturers.

To support the growing store and internet order, Rebel uses a database to ensure that the data is current, accurate and easily accessible.

In running different retail store (branches), Rebel gathers and organises information about branches, products and manufacturers.

Each branch has a number the uniquely identifies the branch. In addition, Rebel tracks the branch's name and its location.

Each product has a code that uniquely identifies the product. In addition, Rebel tracks the product name, product colour, quantity and price.

Each manufacturer has a code the uniquely identifies the manufacturer. In addition, each manufacturer has a manufacturer name and location

Identify the entities:

Identify the attributes of each entity:

Entity-Relationship diagram:

Draw ER diagram using the following relation

A branch sells several products.

A product can be sold in different branches

A product is manufactured by only one manufacturer

A manufacturer makes different products

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

PLEASE READ THIS CASE STUDY AND ANSWER THESE TWO QUESTION. I. External Environment Natural Environment Societal Environment Task Environment II. Internal Environment Corporate Structure Corporate...

Prepare a Quantitative Strategic Planning Matrix (QSPM) as appropriate for the following case (Under Armour, inc., 2013) Under Armour, Inc., 2013 www.ua.com, UA Headquartered in Baltimore, Maryland,...

Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...

PLEASE READ THIS CASE STUDY AND ANSWER THESE TWO QUESTION. SOLVE IT CLEARLY ( TAKE YOUR TIME ) Q1 External Environment: Natural Environment Societal Environment Task Environment Q2 Internal...

Question. 1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Include a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in...

Prepare a internal-external (ie) Matrix for the following case (Under Armour, inc., 2013) Under Armour, Inc., 2013 www.ua.com, UA Headquartered in Baltimore, Maryland, Under Armour (UA) was founded...

Prepare a Strengths-Weaknesses-Opportunities-threats (SWOT) Matrix for the following case (Under Armour, inc., 2013) Under Armour, Inc., 2013 www.ua.com, UA Headquartered in Baltimore, Maryland,...

Please use the Following Information in the exhibits and Case Study above to answer the following questions in paragraph forms. Please make sure to read carefully and answer concise as possible by...

Nike Inc Case Study Please use the Following Information in the exhibits and information from the Case Study above to answer the following questions in paragraph form in about a 4-5 page analysis -...

The sweatshop scandal of the 1990s, which revealed that Nike used forced child labor to manufacture its products, greatly damaged the company. Nike has ever since been plagued with the claims of...

Leverock's Waterfront Steakhouse in Maderia Beach, Florida, uses a questionnaire to ask customers how they rate the server, food quality, cocktails, prices, and atmosphere at the restaurant. Each...

The system of Advanced Problem APlO.l is to have a percent overshoot less than 13%. In addition, we desire that the steady-state error for a unit ramp input will be less than 0.125 (Kv = 8) [24]....

What is the annual breakeven point in units? sold?Determine the formula used to calculate the breakeven number of? units, then calculate the number of units that must be sold to break even....

Insider trading is explained in Chapter 10 (pages 368 to 373) as buying or selling stocks of businesses with having information from an inside person that is not known to the public. The buyer or...

4. As your starting point, take two everyday decisions you have made during the past year. Discuss these decisions based on the following question: Why do you think your decisions may have been wrong?

1. To provide an understanding that social facts are mentally constructed and do not exist as an objective reality.

7. Give examples of the following when you formulate a social problem or phenomenon: a) When you generalize from reality. b) When you choose something from social reality and do not choose some-thing...