List the entities, their attributes and relationships for the descript

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)
_____ _______ _____ __________ ____ _______ _____ ____ _____ _________.
___ _______ __________ ____ ___ ___ ______ ____.
___ ____ ___ _____ _________.
__________ _________ _____ _______ ________ _________ _________ _____ ______.
___ ___ ________ _____ ________ ______ ______ _____ ____ _______ __________.
_________ _____ ___ _________ _______.
_________ _______ ____ ___ ________ _____ _____ _________ _________ _________ _________.
___ _________ _____ ______ _______ ______ _______ ___ _________ _______ __________.
__________ _____ __________ ___ _______ __________ _____ ______ _____ ____ _______.
____ _________ _____ ________ ____ _____.
________ _______ __________ _______ ________.
___ ______ _________ ____ ____ __________ ______ __________.
___ _____ ______ _________ _________ __________ _____ _____ ____ ______ ____.
____ _____ _______ _______ ___ _________ _________ __________ ____ __________ ___ _____.
________ ________ ____ ________ __________ __________ ________ _______ _________ _____.
____ _________ ____ _________ ___ ________ _____ ______ ____.
______ ______ _________ _________ ______ __________ _____ _________ ________ __________ ______.
_______ ___ __________ ______ ___ ____ ______ _____.
________ ___ ___ _______ _____.
______ _____ _____ ________ ______ __________ ___ ___ _____ ______.
____ __________ _____ _____ ___ ____ ___ ___ _______.
___ _________ __________ _____ _________ _________ ________.
__________ ______ __________ _______ _____.
____ ___ _______ ____ ________ ___ _________ ___ ___ __________ ________.
_______ ____ ____ _____ _________ __________ ________ ____ __________.
____ ______ ___ __________ _________.
________ ______ __________ _______ _________ ______ ______ ____ _____ ______ _________ _______.
___ ________ __________ ________ _________ _______ _________ ______ ______ ______ __________ ____.
____ ___ ______ __________ ________ ______ ________ _____ ______ __________.
_________ ______ ____ _______ __________ _____ __________.
____ __________ _____ ________ __________ _______ ______ ___ ______.
____ ___ _____ ________ ________ ______ _______ _______ _______ _________ ___.
________ _________ __________ ______ ___ ________ _______ _______ ______ ____.
____ _____ _____ _____ __________.
_________ __________ _________ _____ __________ _________ ________.
__________ __________ _______ ___ _____ _______ __________ _______ _______ _______ ______.
_____ _________ ____ __________ ___ ______ ________ ______ ___ ___ _______.
_____ ____ ___ ___ ________ _______ __________ _________ _________ _________ ________ _______.
________ _______ _____ ______ ___.
____ ____ ___ _________ ____ ____ ____ _____ ____ _________ __________ ________.
__________ _______ _________ ____ _______ ______ _____ __________ ________ _________ ____.
_____ ______ ______ __________ ___ ____ _________ _________ ___ _________ ______ __________.
_________ __________ ______ ______ __________ _______ _______ _________.
____ ___ ______ ______ __________ _______ _____ ___ _______ ______ ______.
____ _______ ________ _________ ____ _____ __________ ______.
_________ ________ _______ __________ __________ _____ ____.
__________ _________ __________ ________ _________.
_________ ______ ___ _____ _________ _____ _________ __________ _________ ____ _________ _______.
____ _________ _____ _________ ____.
_________ ____ _______ ________ ______ _________ ______ ___ __________ ______.
________ __________ _________ _____ _____ _________.
____ __________ _________ _______ __________ _______ ________ ___ ________ _______ ______ ______.
_________ ______ ______ ________ _____ _________ _______ _____ _____ __________.
____ ___ ______ ________ ___ _________ _______ ____ ________ ________ _______.
________ _____ ________ _________ ________ ________ _____ ____ _________ ________ __________.
_______ _______ ______ ______ _______ _________ _______ ________ ___ __________ ____.
_______ ____ ___ ____ ______ _______ ___ ____ ___ ________ ____.
______ _________ _________ ________ _______ ______ _____ ______ ___ __________ __________.
______ _____ _____ ______ ___.
___ ________ _______ ___ __________ ______ ________ __________ ________.
_________ __________ ___ ________ __________ _________.
______ __________ _____ ________ ____ _______ _______.
__________ ________ _____ _________ ___ ______ ____.
_________ _________ ____ ________ ________.
______ ________ ________ _____ ___ __________ ______ ______ _______ _______.
________ ___ __________ ________ ___ __________ ____ _____ __________ _________ ___ ______.
___ ______ ____ _________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★