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
How to update a table row with a record?
Explain view?
What are the uses of a database trigger?
How to define an anonymous procedure without variables?
What are the differences between char and varchar2 in oracle?
Can we use bind variables in oracle stored procedure?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to create an oracle database?
master table and child table performances and comparisons in Oracle ?
How to generate query output in html format?
what are the advantages of running a database in archive log mode?
What are data pump export and import modes?
What is the usage of merge statement?
How to divide query output into groups in oracle?
What is an oracle database?