Database Design for Restaurant Reservation System Project

    0
    322

    This Database Design for Restaurant Reservation System Project is an application for reserving tables for the customer in the restaurant. User can be allowed to take reservation quickly and easily .

    With the complete reservation system, under user and administrator control. the customer can choose their reservation as per there preference and time. The administrator doesn’t have to maintain a guest book anymore.

    Melting Pot Reservation System Database Design

    This Database Design Project for Restaurant Reservation System used to store and retrieve information and conduct transaction related to rental, or other activities. Melting Pot Reservation System will be in the flow of the administrator and customer transaction.

    This system work by processing secure reservation made through a melting pot system. The data is then pass onto a back end system which can be access by melting pot administrator.

    Reservation System for Restaurant Database Design Project

    The purpose of this system is to build . This system helps customer with the reservation management. In the existing system, the process is conducted manually that are wasting time and energy.

    This Database Design Project also makes its easy to change the status of a reservation once a customer walk in. the customer mentions the day, time and number of people accompanying as a standard procedure for reserving a table.

    FEATURES of Reservation System for Restaurant Database Design Project

    • This System used to store and retrieve information and conduct transaction related to rental, or other activities.
    • This system is built to have an easier way to save information to the database and secure the information as well.
    • Access the details in smooth operations.
    • To have a transaction to the costumer appropriately and productively.

    DATABASE DICTIONARIES

    Melting Pot Reservation System provided with the entire Database details such as Field Name, Description, Data types, Character length.

     

    Table 1. tblcustomer

    Field NameDescriptionTypelength
    CUST_ID(pk)Customer idint11
    cust_FnameFirst nameVarchar50
    Cust_LnameLast nameVarchar50
    Cust_addressAddressVarchar50
    Cust_PhoneMobile numberVarchar50

     

     

    Table2. tblreservation

    Field NameDescriptionTypelength
    Res_Id(pk)Reservation idInt11
    Cust_IdCustomer Idint11
    FullNameFullName of customervarchar50
    AddressAddressVarchar50
    Res_eventReservation eventvarchar50
    Contact_noContact numbervarchar50
    No_of_personNumber of personvarchar50
    res_DateReservation Datevarchar50
    Res_TimeReservation Timevarchar50

    Table3. tblcashier

    Field NameDescriptionTypelength
    C_ID(pk)Cashier idInt11
    Employee_IdEmployee IdInt11
    First_NameFirst NameVarchar50
    Last_NameLast NameVarchar50
    AddressAddressVarchar50
    Phone_noPhone numberVarchar50
    EmailEmailVarchar50

     

    Tableno.4 tblpayments

    Field NameDescriptionTypelength
    Payments_noPayments numberInt11
    Cust_IdCustomer idInt11
    Name_of_customerCustomer nameVarchar50
    Name_of_cashierCashier nameVarchar50
    Total_amountTotal amountVarchar50

     

    Tableno.5 tblemployee

    Field NameDescriptionTypelength
    Employee_IdEmployee IdInt11
    Employee_FnameFirst NameVarchar50
    Employee_LnameLast NameVarchar50
    Employee_AddressAddressVarchar50
    PositionPositionVarchar50
    Hire_DateHire DateVarchar50
    SalarySalaryInt11

    ENTITY RELATIONSHIP DIAGRAM  

    ERD shows the system entity relationship in each entity and their suppose functions in each relationship.

    Figure 1. Melting Pot Reservation System

                This Project for Restaurant Reservation System Database Design entity relationship are the entity of the MELTING POT RESERVATION SYSTEM, which are presented by tables, the tables are made to need the required specification of the system and provide a much more specific details of the entities within the system.

    Download Melting Pot Reservation System PDF HERE. lhca System Description

    Conclusion

    This Database Design for Restaurant Reservation System Project is built to have an easier way to save information to the database and secure the information as well. This System for Restaurant Reservation Database Design is built also to help the administrator of this system to access the details in smooth operations and have a transaction to the costumer appropriately and productively.

    For More Database Design Examples

    Inquiries

    If you have any questions or suggestions about Restaurant Reservation System Database Design Project , please let me know by dropping your comment below.

    Looking for more source code? Type your keyword here here!

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here

    This site uses Akismet to reduce spam. Learn how your comment data is processed.