Draw an ER diagram for the following scenario: 1. A designer has a store of designer dresses
Question:
Draw an ER diagram for the following scenario:
1. A designer has a store of designer dresses both for male and female.
2. People can buy as well as take dresses on rent from the store.
3. Each dress in the designer's store, is identified by unique ID.
4. A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc.
5. The designer maintains the name, phone number of people who have taken dresses on rent.
6. The designer also maintains the name, phone number, and address of people who have bought dresses from the store.
7. The designer also collects feedback from the people who have bought or taken dresses on rent from the store.
Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.