Milly Bonka , owner of Milly’s Chocolate Factory , has hired you as a consultant to design a database management system to help keep track of the make-up of items and their sales between her branches. You are given the following incomplete Entity Relationship Diagram (ERD) and the following requirements.

Items may be sold by one or more branches.
An Item can be composed of multiple other items.

Select all the tasks required to finalize the ERD. [9 marks]
Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before answering this question.
Select all options that apply. Negative marking applies to this question.

Question

Milly Bonka , owner of  Milly’s Chocolate Factory , has hired you as a consultant to design a database management system to help keep track of the make-up of items and their sales between her branches. You are given the following incomplete Entity Relationship Diagram (ERD) and the following requirements.

Items may be sold by one or more branches. 
 An Item can be composed of multiple other items. 
 
 Select all the tasks required to finalize the ERD. [9 marks] 
 Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before answering this question. 
 Select all options that apply. Negative marking applies to this question.

Answer

Create a one-to-many relationship between ITEM and BRANCH.

Answer

Create a foreign key in entity ITEM to represent the recursive relationship

Answer

The primary key of BRANCH appears in COMPOSITION entity as a foreign key

Answer

Replace the primary key of ITEM with a composite key.

Answer

The primary keys of both ITEM and BRANCH are added as foreign keys to the entity SALE.

Answer

Identify additional entities and attributes as necessary to complete the ERD

Answer

The primary key of SALE appears in BRANCH as a foreign key

Answer

Create a one-to-many relationship between ITEM and the SALE entity

Answer

Choose an appropriate primary key for the SALE entity.

Answer

Separate the attribute Address into non-decomposable attributes

Answer

The primary key of SALE is added as a foreign key in ITEM.

Answer

Create a recursive relationship between the ITEM entity and itself.

Answer

Create a bridge entity between ITEM and BRANCH name it SALE.

Answer

The primary key of BRANCH appears in ITEM as a foreign key

Answer

Create a one-to-many relationship between BRANCH and the SALE entity

Answer

The primary keys of both SALE and ITEM are added as foreign keys to the COMPOSITION entity.

Crowdly

Milly Bonka , owner of Milly’s Chocolate Factory , has hired you as a consultan...

Want instant access to all verified answers on connect.belgiumcampus.ac.za?