Admin Edit Category Delete Category Add Category Category Master Category Detail Category Detail Category Detail Category Name
45
E-R Diagram
Restaurant_Id
Restaurant_Name Address
RESTAURANT Has CATEGORY Category_Id Description Category_Name Price Has Booking CUSTOMER User_Id Password Gender Email_Id First_Name Address
MENU ITEM Category_Id Menu_Id Menu_Name Price Description Order Generate BILL Pay Bill_Id Date Booking_Id Total_Amount
ER Diagram
1 1 M M 1 1 1 1 1 146
Schema Diagram
Areamaster PK AreaId AreaName Menumaster PK MenuId FK1,I1 CategoryId MenuName Price Description BillDetails PK BillId TotalAmount Date FK1,I1 BookingId Specialmaster PK SpecialId SpecialName Rates Description StartingDate EndingDate Offermaster PK OfferId OfferName Rates Description StartingDate EndingDate BookingDetails PK BookingId FK1,I1 UserId RestaurantId Date PeopleSize CancelStatus UserAccessAccount PK Accesscounter FK1,I1 UserId Userdetails PK UserId FirstName LastName Gender BirthDate Email_id Address City Pincode Phone UserName Password UserType RestaurantDetail PK RestaurantDetailId FK3,I3 RestaurantId FK2,I2 OfferId FK4,I4 SpecialId FK1,I1 MenuId CancellationDetails PK CancellationId FK1,I1 BookingId Categorymaster PK CategoryId CategoryName Description Restaurantmaster PK RestaurantId FK1,I1 AreaId RestaurantName Address Cuisine PeopleSize Feedback PK FeedbackId FK1,I1 UserId Suggestion MenuBookingDetails PK MenuBookingId FK1,I1 BookingId MenuId MenuName Price Quantity TotalPrice RestaurantSuggestion PK SuggestionId FK1,I1 UserId RestaurantName Area Description47
Data Dictionary
User Detail Table:-
Field Name Data Type Width Attributes Description
UserId int 4 Primary Key User Id No.
FirstName varchar 50 Not Null FullName of the User LastName varchar 50 NotNull LastName of User Gender char 10 Not Null Sex Of the User Birthdate date/time 50 Not Null Birthdate of the User EmailId varchar 50 Not Null Email Address of the User. Address varchar 100 Not Null Address of the User.
City char 50 NotNull CityName
Pincode Numeric 9 NotNull Pincode Number Phone Numeric 9 Not Null Phone no of the User. UserName varchar 50 Not Null UserName of the User. Password varchar 50 Not Null Password of the User. Type of User char 20 Not Null Type of the User
Categorymaster Table:-
Field Name Data type Width Attributes Descripton
Category Id Int 4 Primary Key Category Id No. Category Name varchar 50 Not Null Name of the Category Description varchar 100 Allow Null Description of the
Category
MaxPrice Numeric 9 Allow Null Maximum Price Of Category
Menumaster Table:-
Field Name Data Type Width Attributes Description
MenuId Int 4 Primary Key Menu No. Of the Menu
CategoryId Int 4 Not Null(Fk) Category No. Of the Menu
MenuName Varchar 50 Not Null Name of the Menu
Description Varchar 100 Allow Null Description of the Menu
48
Price Numeric 9 Not Null The Price of the Menu
Booking Details Table:-
Field Data Type Width Attributes Description
BookingId Int 4 Primary Key Booking ID No UserId Int 4 Not Null(Fk) User No of the
User
RestaurantId Int 4 Not Null(Fk) RestaurantId of the Restaurant Date Date/Time 8 Not Null Booking Date of
the user PeopleSize Numeric 9 Not Null No. of People
Booked For Table CancelStatus Char 1 Not Null Booking Status of
the user
Bill Details Table:-
Field Name Data Type Width Attributes Description
BillId Int 4 Primary Key Bill No Of the User
BookingId Int 4 Not Null(Fk) Booking No. Of the User.
Date DateTime 8 Not Null DateTime of the Booking
TotalAmount Numeric 9 Not Null TotalAmount of the bookedMenu
Offermaster Table:- Field Name Data
Type
49
SpecialmasterTable:- Field Name Data
Type
Width Attributes Description
SpecialId Int 4 Primary Key SpecialNo Of the Menu
Special Name Varchar 50 Not Null The Special Name
Rate Numeric 9 Not Null The Rate of the
Special
Description Varchar 100 Allow Null The Description of the Special StratingDate Date/Time 8 Allow Null Display date of
the Special for particular day Ending Date DateTime 8 Allow Null Ending Date of
the Special
UserAccessCounterDetails:-
Field Name Data Type Width Attributes Description
AccessCountId Int 4 Primary key This give the no of times user access the webpages
UserId Int 4 NotNull(Fk) UserId of User
Restaurantmaster Table:-
Field Name Data Type Width Attributes Description
RestaurantId Int 4 Primary Key Restaurant No OfferId Int 4 Primary Key OfferNo Of the
Menu
Offer Name varchar 50 Not Null The Offer Name
Rate Numeric 9 Not Null The Rate of the
Offer
Description Varchar 100 Allow Null The Description of the Offer StratingDate Date/Time 8 Allow Null Display date of
the offer for particular day Ending Date DateTime 8 Allow Null Ending Date of
50
AreaId Int 4 Not Null(Fk) Area No. Of the Restaurant RestaurantName DateTime 8 Not Null Name of the
Restaurant Address Numeric 9 Not Null Address of the
Restaurant Cuisine Char 50 Not Null Cuisine of the
Restaurant
Areamaster Table :-
CancellationdetailsTable :-
Field Name Data Type Width Attributes Description
CancellationId Int 4 Primary Key CancellationNo BookingId Int 4 NotNull(Fk) Booking No
FeedBack Table :-
Field Name Data Type Width Attributes Description
FeedbackId Int 4 Primary Key FeedbackNo
UserId Int 4 NotNull(Fk) UserNo
Comments varchar 1000 NotNull Comments &Suggestion by User
RestaurantSuggestion Table:-
Field Name Data
Type
Width Attributes Description
RestaurantSuggestionId Int 4 Primary Key RestaurantSuggestion No
UserId Int 4 NotNull(Fk) User No
RestaurantName varchar 50 NotNull Name of Restaurant suggest by user Comments varchar 250 AllowNull Comments about
Field Name Data Type Width Attributes Description
AreaId Int 4 Primary Key Area No
51
Restaurant
MenuBookingDetail Table :- Field Name Data
Type
Width Attributes Description
MenuBookingId Int 4 Primary Key OfferNo Of the Menu
BookingId int 4 Not Null(Fk) The BookingNo
MenuId Int 4 Not Null(Fk) MenuNo
MenuName varchar 50 Not Null Name of the Menu
Price Numeric 9 Not Null Price of the Menu Quantity Numeric 9 Not Null Quantity of Menu TotalPrice Numeric 9 NotNull Total of Price of
Menu per Quantity
Restaurantdetail Master Table :-
Field Name Data
Type
Width Attributes Description
RestaurantdetailId Int 4 Primary Key Restaurantdetail No
MenuId Int 4 NotNull(Fk) Menu No
RestaurantId Int 4 NotNull(Fk) RestaurantNo OfferId Int 4 AllowNull(Fk) OfferNo SpecialId Int 4 AllowNull(Fk) SpecialNo
52