best way to create an asp databse in c# visual studio for website
I would like to create a simple pizza ordering website with database, website design is fine but I am a bit confused as to how my database should be laid out and related.

I currently have tables-with attributes:

Order-OrderID(PK), CustomerID, PizzaID,DrinkID,SideID
Pizza-PizzaID(PK),OrderID(FK), Size, Crust, Type
Customer-CustomerID(PK),OrderID(FK), Address,Contact
Drink-DrinkID(PK), Quantity, Type
Side-SideID(PK), Quantity,Type

Not sure if this is the best way to set it up and also not sure what should relate to what
Do all tables need to be connected??
Thanks in advance,
MH
best way to create an asp databse in c# visual studio for website
===

I would like to create a simple pizza ordering website with database, website design is fine but I am a bit confused as to how my database should be laid out and related.

I currently have tables-with attributes:

Order-OrderID(PK), CustomerID, PizzaID,DrinkID,SideID
Pizza-PizzaID(PK),OrderID(FK), Size, Crust, Type
Customer-CustomerID(PK),OrderID(FK), Address,Contact
Drink-DrinkID(PK), Quantity, Type
Side-SideID(PK), Quantity,Type

Not sure if this is the best way to set it up and also not sure what should relate to what
Do all tables need to be connected??
Thanks in advance,
MH