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
Is truncate autocommit in oracle?
what is the dual table in oracle?
Is oracle a programming language?
How to create a table in a specific tablespace?
How to concatenate two text values in oracle?
What is a trigger oracle?
Can we write dml statement in function in oracle?
Explain oracle data types with examples?
What is Java Pool in Oracle?
Please explain drop constraint oracle?
How to establish administrator authentication to the server?
How to assign values to data fields in record variables?
What happens in oracle commit?
What is the difference between sharding and partitioning?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?