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 |
How to connect to oracle using service name instead of sid?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to start a new transaction in oracle?
What is a Sequence ?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How to write a query with an inner join in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are a query and state the different types of queries and their uses?
What is data type in oracle?
Can you assign multiple query result rows to a variable?
Is java required for oracle client?
What is a synonym? What are its various types?