Question

List the entities, their attributes and relationships for the description given above and make an ERdiagram for this e-Commerce Portal. You may use the concept of keys, aggregation, generalisation, cardinality etc. as per need. Design the suitable RDBMS tables for the ER-diagram you have created. The database design should include keys, foreign keys, constraints and referential integrity constraints. Your database design should be normalized up to 3rd Normal Form. Make necessary assumptions wherever require.

13 Sep 2024
Answer :
Word Count : 747

### Entities, Attributes, and Relationships for an e-Commerce Portal

#### 1. Entities and Attributes

1. Customer
   - *Attributes:* CustomerID (Primary Key), Name, Email, PhoneNumber, Address, Password

2. Product
   - *Attributes:* ProductID (Primary Key), Name, Description, Price, StockQuantity, CategoryID (Foreign Key)

3. Category
   - *Attributes:* CategoryID (Primary Key), CategoryName

4. Order
   - *Attributes:* OrderID (Primary Key), CustomerID (Foreign Key), OrderDate, TotalAmount

5. OrderItem
   - *Attributes:* OrderItemID (Primary Key), OrderID (Foreign Key), ProductID (Foreign Key), Quantity, Price

6. Payment
   - *Attributes:* PaymentID (Primary Key), OrderID (Foreign Key), PaymentDate, PaymentAmount, PaymentMethod

7. Supplier
   - *Attributes:* SupplierID (Primary Key), Name, ContactInformation

8. ProductSupplier
   - *Attributes:* ProductID (Foreign Key), SupplierID (Foreign Key)

#### 2. Relationships

- Customer - Order: One-to-Many (A customer can place multiple orders)
- Order - OrderItem: One-to-Many (An order can contain multiple items)
- Product - OrderItem: One-to-Many (A product can be part of multiple order items)
- Product - Category: Many-to-One (A product belongs to one category)
- Order - Payment: One-to-One (Each order has one ______ ______ _______ __________ ____ ____ ______.
________ __________ ________ ________ __________ _________ __________ _______ ___ ____ ___ _____.
_____ ________ __________ ________ _________.
_____ ___ ____ _______ _______ ________.
___ ___ __________ _________ ___ _________ _______ _________ ______ _______.
_____ _______ _______ ___ __________ ___ ______ ___ ___ _________.
_________ _________ ___ ______ _____ _________ ________ _________ ______ _________ ________ ________.
_____ _____ ______ ____ _______ ___ ______ ______ _________.
________ ______ __________ _________ _______ _____ ____ __________ _________.
___ _____ ______ _____ ________ ___ __________ __________ _________ ____ _____ ______.
____ _________ ____ ______ ___ _____ _______ ___ _______ _________ ____.
______ ___ ______ _______ _______ _________ ________ _________ _________ ________ ______ _______.
______ ______ ________ ________ _________ _________.
___ _____ _________ ___ ________ __________ __________ _______ _________ __________ _______.
_________ __________ _____ ________ ____ ____ _____ ____.
______ ________ ___ __________ ________.
____ ___ ________ ________ __________ __________ _________.
________ ________ ____ ________ _____ _______.
_____ ____ _________ ___ _____ ____ ________ ______ ______.
________ ________ _____ _______ ______ ________ _____ __________ ___ ___ ______ ______.
__________ ___ _________ ___ ____ _______ _________ _____ ______.
_________ ______ _________ ___ _________.
_________ _________ _______ ________ ____ ___ __________ __________.
________ __________ _____ _____ _________ __________ ____ ____ ____ _____.
______ ______ ______ _______ ___ _______ ______ ___ ______.
__________ _____ ___ ______ ______ _________ _________.
___ _______ _____ ______ _______ ________ ________ _______ ________ _________.
_______ __________ ______ ______ _________ ___ __________ _________ _____.
___ ___ __________ _______ ______.
__________ ____ _________ _________ _______ ___ _________ ___ _________ __________ __________ _____.
_____ ______ ______ ______ ____ __________ ___ _____ _____.
________ _______ _________ ____ ________.
_____ ________ ____ _________ ____ __________ __________ ________ ________.
______ ____ _____ _____ _________ ________.
_____ _________ ___ ______ _______ _______.
______ _________ ________ _________ _______ ________ ____ _______.
________ _____ _____ _____ __________.
________ ________ ______ _____ ____ __________ _________ ___ ________ ___ __________ _______.
______ __________ ____ ___ _________ _______ _______ _____ _______.
_______ ______ ______ ________ _____ __________ __________ __________ _________ __________ ___ _______.
_________ __________ _________ ____ _________ _________ ____ _______ ___ _________ ____ _____.
_______ _____ ________ ____ _____ _______ ______ ______ _________.
___ _______ _____ ______ ________ _______.
_________ _________ __________ ____ ____ ___ ________.
___ _______ ____ _____ ____ ______.
__________ ___ _______ __________ __________ ______ _____.
_____ _________ _______ ____ __________.
________ __________ _______ ________ __________ ___ ________ _________ ____ ___ ___ ________.
_______ ___ ________ ________ _____ _________ ___ ___ ____ ________.
________ ____ ________ _______ ________.
___ ________ ____ _______ _______ _______ _________ ______.
________ _______ ____ ______ ___ __________ _________ _____.
_____ __________ ____ _____ _________ ___ ______ ___.
____ ____ ___ _________ ___ _______.
__________ ____ _____ _________ _______ ______ ______ ___.
_____ __________ _______ ____ _____ ___ ___.
__________ ____ ____ ______ __________ ___ __________.
_____ ___ ________ _______ _____ _________ _________ ____ _______ ____ _______.
____ _______ ____ ________ ______ ________ _____ ______.
_________ ______ _______ __________ _____.
_____ ________ _________ __________ _____ ___ ______ _____ __________ ____.
______ ________ _______ __________ _____ ________ ____ ______ ________ ________ _____ _____.
__________ _______ _______ _______ _________ ____.
____ ____ ___ __________ ________ _______ ______ __________.
_________ _________ ________ ________ ____ ______ ______ ____ _______ ________ _______ __________.
________ ___ _______ __________ ______ _____ _______ ______ ________.
___ ________ ______ _________ ______.
Get Full Answer on WhatsApp

IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance List the entities, their attributes and relationships for the descript
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→