Restaurant management system

• Simple database supporting a catering company
• The project was carried out as part of the "Basics of databases" course at AGH UST in a 3-person team.
• A detailed description can be found here (in Polish)
• A documentation can be found here (in Polish mostly)

General informations

• Take-away and on-site ordering service.
• Table reservation for at least two people.
• Offer for individual customers and companies.
• Generating invoices (for a single order or for the whole month).

Menu

• At least half of the dishes in the menu is changed at least once every two weeks.
• On selected days you can order seafood.
• Menu is set the day before.

Reservation

• Possible with the minimum value (WZ) of the order and WK previous orders
• Must be approved by the employee
• For companies: per company or for specific company employee (by name)

Discounts

• One-time or long-perm discount
• Available under certain conditions (for instance number of orders)
• Only available for individual customer

Reports

• Monthly and weekly reports
• Reports are available for both companies and individual customers
• Related to discount, number of orders, statistics etc

Functionality

• Functions
• Procedurs
• Tables and Indexes
• Triggers

Diagrams

PNG here
SVG here