first time on this forum so sorry if i make mistakes ..
My problem is .. I have done a final year project for a local pizza shop. It has some basic functions such as customer registration, shopping catalogue and ordering online. The website is linked to a MySQL database and it has done with PHP. The problem with the client is that he wants to update the prices himself via a content management system. So i have done it as well. My project was done and my tutor was happy. In my database design, apart from other tables such as customers and staffs, it has two tables that made up the Menu Catalogue. It's Menu table and Menu Catagory table which has 1 to many relationship. In Menu Catagory table it has 2 fields which are Category and Description. In Menu table it has 4 fields which are Name, Category, Description and Price. I used few sample menus for the project so it was fine but when i actually try to do it for the client i know my design is totally wrong. The shop sells pizza, kebabs, burgers, etc has arond 15 categories. For pizzas, they have 19 pizzas and each pizza has 4 different sizes and different prices. Depending on this design, i have to put 4 time in the table for each pizza. So finally i have 19 x 4 = 76 lines on the menu page. It is too messy to look and the page needs to be too long.
So, please suggest me of a new design for this. Do i need 15 seperate tables for 15 categories ? or how can i solve this problem. thanks so much,Laurence.