0

Hi

i am going to code a resturant booking system and i need help.. Can you give me idea on how i can design my database? i would like this system to take table reservation, tables orders, take aways, crud of menus etc..

u have any idea how to do the ERD of this database? Pls help i am so confused!

2
Contributors
4
Replies
5
Views
6 Years
Discussion Span
Last Post by xanawa
0

As example: Just ask yourself what a table order needs.
Nr. of persons?
Date and time of arrival of the party?
Special wishes: only veg food, comes with dog, needs big chair etc.
Etc.

All these are candidates for a column in this DBtable.

Edited by ddanbe: n/a

0

I know what data i need i am just confused on how to split the database into tables.. cause some data is going to cause data redundasy and i am afaraid that i would have a wrong erd.. l8er on i will post the data i have in mind

0

yesterday i figered it out and the erd is ready thank you so much for your help

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.