Saved Bookmarks
| 1. |
You have to propose and optimal database design in RDBMS for a super store. In which clients came and canpurchase 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 define1) 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» 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. |
|