Oracle database system

Cafe Admin System – Oracle Database Project

A database management system designed for a café to streamline and manage daily operations. The project was built using Oracle Database and includes:

Customers Management: storing customer information and order history.

Menu Management: handling menu items, categories, and prices.

Orders & Billing: tracking customer orders, generating bills, and calculating totals automatically.

Reservations: managing table bookings and schedules.

Staff Management: recording employee data and roles.

Automation: implemented SQL queries, triggers, and stored procedures to automate tasks like updating sales records and calculating invoices.

Security: applied role-based access for admins, cashiers, and staff.

This system helps café managers easily monitor sales, track reservations, and improve overall efficiency in daily operations.