No. 02

Deadline date:

Your assignment must be uploaded/submitted before or on 25/5/2016

Assignment Topic:

The topic of the assignment is Entity Relationship Diagram.

Uploading instructions

Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.

Rules for Marking

It should be clear that your assignment will not get any credit if:

The assignment is submitted after due date

The assignment is copied

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.

Assignment submission instructions:

Your assignment should be in doc format.