below is the ERD created based on the problem statement.

Requirement

Create the database (data insertion and table creation) based on the ERD above.

no such thing as reference needed. This is the complete question.

Restaurant Management system, this system basically runs between customers and management in a restaurant. The customer interacts with generally one waiter and places their order, while the waiter takes multiple customers in a day. The customer places an order with the waiter, the waiter generates an invoice with the details of the customer, their order and table number, which is sent to the kitchen. Once the order is prepared the runner uses the invoice to serve the food. The waiter usually asks again if the customers want to order anything more, this process can go on till the customer decides he does not want any more food. All the invoices generated by the customer are part of a much larger entity called order. The order is essentially the bill generated in the end by the restaurant for the customer. Now we know the customer, waiter and invoice will be present in the order table. The relationship between customer and order is one to one. The relationship between the waiter and order is one to many the relationship between invoice and order is one to many. Waiter ID Name Customer ID Table No. Name Waiter Customer 1 M Invoice ID M Invoice M Order Invoice ID Item Customer ID Waiter ID Total Order ID