(Solved) : Customer Register Online Retail Application Purchase Item Customer Provide Bank Account Nu Q29431557 . . . .

A customer can register to the Online Retail Application topurchase an item. The customer will provide bank account number andbank name (customer can have multiple account number). Afterregistration, each customer will have a unique customerid, andpassword. Customer can purchase one or more items with differentquantities. The items categorized to different classes based upontheir prices. After purchasing items by the customer, a bill willbe generated including the quantity, price of the item and discount(if any) on the purchased items. A bank account is required tosettle the bill. One or more suppliers can ship the same item.

As a database developer, you are