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.

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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Explain the naming convention for data-flow diagrams' various layers.
Explain the meaning of the term intersection table
Name the functional dependence and provide the determinant(s) in the following equation: Length * Width = Area
I want professional explanation and summarization for erd diagram
What two UML diagrams are most often used? Their objective?
Differentiate the purpose of normalization and Erd Diagram
Please describe the various categories for integral data types.
Write 10 physical significance of full subtractor
Why flow chart is required ?Explain different symbols used in the flow chart and explain with suitable example
Where do normalizations and Erd diagrams vary from one another?
Explanation of data label in a few sentences
Write down Steps to Convert POS to Canonical POS Form.