- 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)
- 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).
- 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.
- 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)
- One-time or long-perm discount
- Available under certain conditions (for instance number of orders)
- Only available for individual customer
- Monthly and weekly reports
- Reports are available for both companies and individual customers
- Related to discount, number of orders, statistics etc

SVG here