How would you design a database for an e-commerce website?
• 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 |
What are the components of Logical database structure of ORACLE database?
How to connect to a local oracle 10g xe server?
Can a formula column be obtained through a select statement ?
How to create a new table by selecting rows from another table?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to work with data objects interactively?
Explain database link?
Are truncate and delete commands same? If so why?
if you update view? where we store the data?
what is the difference between substr and instr function in oracle?
What is the difference between substr & instr functions?
What are the advantages of oracle 12c?