Search results

Hi Nick, thanks for your reply, this is what I've currently done, could you please advise if I am on the right track. For 1NF I did: TABLE 1: SANDWICH CODE [-PRIMARY KEY-] SANDWICH DESCRIPTION TOTAL PRICE _________________________________________ TABLE 2: ORDER NO [-PRIMARY KEY-] SANDWICH...

Hi, could someone give me some advice regarding normalised forms and the ER diagram. I understand that the first step to do is to delete repititive data, but what about all this foreign key etc? So for example if I had to normalise the data below, I can turn the 4 rows of data to 2 rows by...