$1-$ Admin: Stores information about the restaurant manager.

$-$ Admin$\_$ID $($Primary key$)$

$-$ Name

$-$ Username

$-$ Password

$-$ Email

$-$ Phone Number

$2-$ Staff: Stores information about the restaurant staff.

$-$ Staff$\_$ID $($primary key$)$

$-$ Name

$-$ Position

$-$ Contact$\_$Number

$-$ Email

$3-$ Customer: Stores information about the customers.

$-$ CustID $($primary key$)$

$-$ Name

$-$ ContactNum

$-$ Email

$4-$ MenuItems: Stores information about individual items in the menu.

$-$ Item$\_$ID $($primary key$)$

$-$ Name

$-$ Description

$-$ Price

$5-$ Dish: Stores information about the dishes offered by the restaurants.

$-$ Dish$\_$ID $($primary key$)$

$-$ Name

$-$ Description

$-$ Price

$-$ Chef$\_$id $($foreign key referencing Staff.staff$\_$id$)*$

$6-$ Beverage: Stores information about the beverages offered by the restaurant.

$-$ Beverage$\_$id $($primary key$)$

$-$ Name

$-$ Description

$-$ Price

$7-$ Sweet: Stores information about the sweets or desserts offered by the restaurant.

$-$ Sweet$\_$ID $($primary key$)$

$-$ Name

$-$ Description

$-$ Price

$8-$ Reservation: Stores information about the customer reservations.

$-$ Reservation$\_$ID $($primary key$)$

$-$ CustID $($foreign key referencing Customer.customer$\_$id$)$

$-$ Table$\_$ID $($foreign key referencing Table.table$\_$id$)$

$-$ Reservation$\_$Date

$-$ Reservation$\_$time

$-$ GuestsNum

$9-$ Table: Stores information about the tables available in the restaurant.

$-$ Table$\_$ID $($primary key$)$

$-$ Capacity

$10-$ Order: Stores information about customer orders.

$-$ Order$\_$ID $($primary key$)$

$-$ CustID $($foreign key referencing Customer.customer$\_$id$)$

$-$ Table$\_$ID $($foreign key referencing Table.table$\_$id$)$

$-$ Order$\_$Date

$-$ Order$\_$Time

$-$ Quantity

$11-$ Payment: Stores information about the customer payments for their orders.

$-$ Payment$\_$ID $($primary key$)$

$-$ OrderID $($foreign key referencing Order.order$\_$id$)$

$-$ Amount

$-$ Payment$\_$Date

$-$ Payment$\_$Time

drew the ER digram