Question

You have to propose and optimal database design in RDBMS for a super store. In which clients came and can

purchase products according to their likes and dislikes. Super store have same products of different companies. In

the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of

stock according to FIFO system.

Your required to define

1) Entities and their attributes [1]

2) Attributes Types [1]

3) Each Attribute Required space. [1]

4) Define keys of each entity [2]

5) Defile relationship between the entities. [3​

Answer 1

Make a Propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system.

Required to define

Entities and their attributes

Attributes Types

Each Attribute Required

Define keys of each entity

Define relationship between the entities.