Programme Code : BCA
Course Code : cs-67
| More

Year : 2012 Views: 962 Submitted By : Pankaj rana On 22nd September, 2012

Do you have solution for this Question. If yes    I aslo want solution.

Q.


A departmental store maintains inventory of goods about its sections. Each section can sell a number of items. An item sold by one section may be part of other section also. The departmental store has a number of registered buyers. Some of the buyers, however, may not be registered. A buyer purchases one or more items and a number of such items. A buyer gets a bill for the purchases s/he made. A buyer can purchase many times in a month. A buyer may buy several times even in a single day. A buyer who had made purchase of more than Rs10,000/- in a month, is given a status of preferred buyer. The preferred buyer is given a discount of 5% on all purchases on all the purchases made in the next month. The store acquires all the items from a stockiest. Each item has an item code. All acquisition of items are recorded. The cost price of an item of a different acquisition may be different. The selling price of an item is decided by the cost price of that item, handling overheads and profit margin. For all the items the store presently uses them as fixed quantity.

Perform the following tasks for the store. Please make and state assumptions, if any.

1) List the entities, their attributes and relationships for the description and make an ER-diagram for the Store. You may use the concept of keys, aggregation, generalisation, cardinality etc. in a proper way. (10 Marks)



2) Design the suitable RDBMS tables for the ER-diagram so created in question 1. The database design should include keys, foreign keys, constraints and referential integrity constraints. (10 Marks)


No Answer Found