Assignment Topic:

The topic of the assignment is Entity Relationship Diagram.

Objective

• This assignment has been designed so that you understand the concept of Entity Relationship Diagram.

Assignment

A store displays items on shelves and would like to keep track of which items are on which shelves. An item is described by a unique item Id, iId, its manufacturer, manuf, its name, name, and the space it occupies on a shelf, space, its cost, cost, and its retail price, price. A shelf is described by a unique shelf Id, sId, and its size, size. When an item is placed on a shelf, a date, removeDate, is specified for when the item will be removed from the shelf. You can assume any reasonable domains for these attributes.

Using the above scenario construct the ER-Diagram, identify different entities and specify their attribute types. Show the relationship which exist between the entities. Also identify the identifier and descriptors for the entities. What type of relationships exists among different entities? Mention any necessary assumptions that you make.