This could be done a million different ways. At a minimum, you would probably need the following tables:
Users
Products
Orders
OrderItems
Payments
Table1 (transactionID*, transactionDate, transactionTime)
Table2 (transactionID*, itemID*, itemCount)
Table3 (itemID*, itemDescription, itemPrice)
Could you tell me table names and entities that should be in Mobile Shop Database Management System? Please Help.
