3nf?

[dd/mm/yy]

hey all

I was just wondering if somebody would be able to just check these tables over to ensure this is in 3rd Normal Form. To the best of my knowledge it is.... always worth a check with some more experienced people though.

Customers – CustomerID, Forename, Surname, HouseNum, Street, Town, City, Postcode, Telephone
Orders – OrderID, CustomerID, DateOpened, DateClosed
Ordered_Products – OrderID, ProductID, Quantity
Products – ProductID, Name, Features, Cost

thanks a lot

dd/mm/yy

 

[Mile-O]

Looks good. The only thing I'd suggest is changing the field called Name in Products to Product as Name is a reserved word in Access.

I'd probably change the names of those tables, too, to tblCustomers, tblOrders, tblOrdersToProducts, tblProducts. Eliminating spaces and special characters - such as the underscore - from a table or field's names reduced problems with SQL later on. Prefixing the table with tbl let's you know, when looking at SQL, that you are selecting, etc. from a table. Typically, you find people who have tables and queries with the same name and, when doing SQL, Access doesn't know which one to refer to. So, prefix your objects - it's safer,

• Table - tbl
• Query - qry
• Forms - frm
• Reports - rpt
• Macros - mcr
• Modules - bas

The same goes for objects: textbox (txt), combobox (cbo), button (cmd), label (lbl), listbox (lst).

 

[dd/mm/yy]

hi mile-o-phile

sorry, i already have the "tbl" prefix on the tables i had just copied the info from some documentation i had... my bad!

thanks for the info about Name being a reserved word - didnt think of that. and also taking out the _ character makes sense as well so i think ill change that as you suggested.

thanks for the help

dd/mm/yy