Question

Varun is the owner of New Trends Fashion Company that deals in garments. He wants to make a Database Application for his company. Suggest any six possible entities that can be used in the database for his website.

Hint:

Identify core entities like Customer, Product, and Orders to design an efficient database for any business.

Answer 1

A database for an online fashion company like New Trends must handle various types of information related to products, customers, transactions, and operations.
Entities represent real-world objects or concepts in the database.
Here are six possible entities that Varun can include in his application:
(i) Customers: Stores customer information such as name, contact details, address, login credentials, and order history.
(ii) Products: Contains details about garments such as product ID, name, category, size, color, price, and stock availability.
(iii) Orders: Maintains order details including order ID, customer ID, product IDs, quantities, date of purchase, and payment status.
(iv) Payments: Stores payment transactions, methods (credit card, UPI, COD), payment IDs, timestamps, and success/failure status.
(v) Inventory: Tracks stock levels, incoming shipments, and warehouse details to avoid stockouts and delays.
(vi) Reviews/Ratings: Collects customer feedback, product reviews, star ratings, and comments to enhance product visibility and trust.
These entities help organize, retrieve, and manage business data efficiently and support smooth operation of the e-commerce platform.