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