Create a restaurant POS database. Populate tables. All primary keys must be auto-generated. Show all code for createing tables. Include foreign key constraints.

Waiters, cooks, hosts, managers, customers, tables

invoices, payments, payment types, tips

inventory, specials, gift cards, loyalty cards

Capitalize SQL commands

Use indentation and blank lines for readibility

use consistent naming convention

inventory

The customer should be able to produce reports about what products sold each month.