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
Explain an integrity constrains?
How to create a temporary table in oracle?
How will you write a query to get a 5th rank student from a table student_report?
How to assign data of the deleted row to variables?
What privilege is needed for a user to query tables in another schema?
What is a user role in oracle?
How to export data to a csv file?
Explain about functional dependency and its relation with table design?
How do we represent comments in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to use "startup" command to start default instance?
How to get maxsal , minsal, ename department wise in single query
What is a table index in oracle?
How to delete multiple rows from a table in oracle?
What is data block in Oracle?