Hi,
So I am creating a simple project app that requires me to store and retrieve customer data but I have trouble splitting the data tables into smaller ones. I am using Excel as the datasource and I will try to explain the details that I need using a fast food example.
A customer can have many orders but an order can only have one customer. Customers have the selection to choose either one, or a combination of one of the following in their orders:
- Burgers
- Fries
- Drinks
If a customer chooses Burgers, I will need to record the serial number, cooking temp, brand and extra remarks(if any) of their ingredients. For example if there are 4 ingredients in a burger, the data for each ingredient will have to be stored. The same goes for Fries and Drinks, but with only 1(fixed) ingredient in each.
Also, is it possible to have a toggle in the [orders] tab to indicate what the customer have purchased? For example, Customer A purchased Burgers + Fries, so in a new order the toggle for Burgers and Fries will be switched on, and I will be able to insert new data only into those 2 sections, with the Drinks option blanked out because the toggle is switched off.
I have all the unsorted data in paper form, but I have trouble figuring out how to separate it into different tables in Excel. I have tried splitting the data myself but the Primary and Foreign keys are giving me headaches. Any help from anyone will be much appreciated. Thanks in advance!
