Search Result

Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have:

Customer Table
CustId(pk)
Cust Name
Cust Address
Cust Postcode
Cust Email

Order Table
OrderID (pk)
Order Date_Time
CustID(fk)

OrderDetails
DetailsID(pk)
Quantity
OrderNo(fk)
DeliveryID(fk)

Product...

Hi,

I am trying to create a data entry form for users. I want part of this to be a list box that can have multiple selections. As it stands at the moment. I have a table for Event details called 'Event', a table for Universities called 'Universities' who may attend, and a table inbetween called 'Attending' to stop the many to many relationship by having the Event Id and University Id in. I don't know if this is correct? Could someone...

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF). These steps are descibed as follows:


Note:...