So this should be a pretty simple question (but doesn't appear to be) that I'm hoping some of the database wizards out there can help me with. I'm not too long outta university with a BSC in Computing, I didn't get a full classification due to the fact that yup I failed the Data Management module. I was never very good with normalization and splitting a database down into the correct amount of tables and relationships. Anyway I've been asked to produce a simple web site (first paid project) for a fish and chips take away down the road. The guy is only paying me £100 but I still wanna do a good job.
I'm using Laravel PHP framework and PHP is my preferred language. I know how to do all the creation of a user login backend system, however creation of the database is really getting to me. The menu is as follows and I've managed thus far to break it down:-
Main - Only has 2 items on it, which I'd usually put into a sides menu if it were me but this is how he wants it done so it appears right (chips, cheesey chips)
Pies & Pasties
Pizza (only available Friday and Saturday)
and obviously 1 price for each size for example:
Large - £4.90
Medium - £3.90
1 Category has Many Menu Items
1 Menu Item has Many Sizes (Large, Medium)
1 Menu Item has Many Prices (Large Price, Medium Price)
Have I split that down right? Obviously I'm not asking for someone to do the work for me, I just need a little direction or correction on what I've produced thus far before I go to building up the table migration files for Laravel.
Any help would be much appreciated. Yes I know as a graduate I should probably already know this stuff but hey we can't always be good at every aspect.