How would you design a database for an e-commerce website?
Answer Posted / hr@tgksolutions.com
• Tables Needed:
o Users: Stores user info.
o Products: Stores product details.
o Orders: Stores order history.
o Payments: Stores payment transactions.
• Use indexes for fast lookups.
• Implement ACID transactions for financial data.
• Use sharding for high-traffic scaling.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a trace file and how is it created in oracle?
How to insert multiple rows with one insert statement in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is ADDM Advisor in Oracle?
Can group functions be used in the order by clause in oracle?
What is oracle in java?
What is a private synonym?
Can you create a synonym without having a table?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What are the differences between char and varchar2 in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is an index associated with a constraint?
What is a nested table and how is it different from a normal table?
State the difference between a primary key and foreign key?
what is meant by magic query