ONLINE RETAIL APPLICATION DATABASE PROJECT

Question

Hello,

can we meet for a lesson. I would like to get help in a project that I have. My course taught me how SQL works from a book but now hands on so I am struggling to to final project.

Here is the question for my final project " A customer can register to purchase an item. The customer will provide bank account number and bank name (can have multiple account number). After registration, each customer will have a unique customerid, userid and password. A customer can purchase one or more item in different quantities. The items can of different classes based on their prices. Based on the quantity, the price of the item and discount (if any) on the purchased items, the bill will be generated. A bank account is required to settle the bill. The items can be ordered to one or more suppliers "

Answer 1

Yes, we can have an online lesson ...

You will need at the very least the following tables:

Customer

Order

Order detail

Product

Supplier

Inventory