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
What is hash cluster in oracle?
What is oracle and what are its different editions?
How to use "startup" command to start default instance?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How can we delete duplicate rows in a table?
Why does for update in oracle 8 cause an ora-01002 error?
What is an oracle?
What is a sub query and what are the different types of subqueries?
how do u setup a replication site?
When do we use group by clause in a sql query?
How to drop a tablespace?
How to invoke the data pump export utility?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is raw datatype in oracle?
How to empty your oracle recycle bin?