give you an idea. The user will be asked for there name, what they would like to order and what table in the restaurant they would like to sit at. If the user puts table 5 for a party of 3 but i only have 1 seat available then it will have the user pick another table. Just need a function for the table selection process. I attached the sql for the database
