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 assign a tablespace to a users in oracle?
What is parameterized cursor in oracle?
How to get maxsal , minsal, ename department wise in single query
What is meant by recursive hints ?
Can a property clause itself be based on a property clause ?
How to convert numbers to characters in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
what is the syntax of ALTER command?
How to pass parameters to procedures?
What is the oracle implicit cursor?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Explain about functional dependency and its relation with table design?