Hi there,
I want to setup a restaurant portal for my local area.
But I already have some problems setting up / structuring the tables.
So far I've got
-a restaurant table ( just the names and address )
-category table ( i.e. italian, german, ... )
-area table
-relation table ( mainly for linking the restaurant tbl and category tbl )
But wouldn't it be a better idea to directly put the category data in the restaurant table ( redundancy? ). What happens if the relations table gets damaged ? Then I wouldn't know anymore which restaurant name belongs to which category.
thanx for any tips / guides
I want to setup a restaurant portal for my local area.
But I already have some problems setting up / structuring the tables.
So far I've got
-a restaurant table ( just the names and address )
-category table ( i.e. italian, german, ... )
-area table
-relation table ( mainly for linking the restaurant tbl and category tbl )
But wouldn't it be a better idea to directly put the category data in the restaurant table ( redundancy? ). What happens if the relations table gets damaged ? Then I wouldn't know anymore which restaurant name belongs to which category.
thanx for any tips / guides