Question

Supreme Products manufactures products like pressure cookers, cookwares, water purifiers, food processors etc. The company markets its products to wholesalers all over the country and dealers sell them to customer. The company has five regional offices and many sales persons are attached to regional offices. Salespersons contact dealers and explain about products, incentives offered, training programs for wholesalers and demonstrations for customers etc. Dealers place orders with the salespersons attached with the regional office of their location. After receiving goods they make payments, which may be in instalments. Company would like to develop a system to monitor sales of different products, performance of salespersons and orders from wholesalers.

Do the following:

(i) Identify entities, attributes and relationships giving functionalities and draw an E-R diagram for the system.

(ii) Convert this to relational tables explaining the logic involved. (5+5)



b. Give examples of:

(i) A many-to-many relationship in which one of the participants is another relationship.

(ii) A subtype that has an associated weak entity that does not apply to the super type. ​

Answer 1

Answer:

can't get the question mate!!!