Hi ! I'm new to sql currently using server 2008 R2 and I was hoping that you guys can check if the tables are normalized because I always had the assumption that my work has its flaws or I'm just being paranoid.
If the tables are not normalized please tell which one and why is it wrong thanks much appreciated
So far it these are the tables that I got in 3NF.
The only thing to consider might be OrderProduct table. If more than one Supplier provides quantities for the same PO, will you enter a separate row for every Supplier in that table? If so, you may be OK. If not, then SupplierCode needs moved to a separate table.
Hi sorry for the late reply thanks btw and I think no about the suppliers on a same PO but will note that in case.
3 more big tables to go, could I just reply you here and not to post another thread?
Sounds fine to me. Not much traffic here, I expect most of the regulars read all threads that get new posts, so won't dismiss your additional material as "Not my thread"!!
Multiple supplier addresses, per supplier?
Do you have Suppliers and Customers who are the same? (Not a common situation, granted). Solution to that can be to have an "Companies" table, and then the Supplier and Customer tables just have a link to the Companies table (and possibly the Address is a sub-table off that, if you want many-addresses per Company).
Not a normalisation issue, (and maybe you have this and are just not showing the additional columns in your snapshot) but I think you will need a UnitPrice (or TotalPrice) on the OrderProduct table - to indicate what price was paid, to that Supplier, for that product on that day.
Do you break-bulk? If so you may need some help with both units and prices - e.g. on products where you can buy in a Pallet, or a Carton, or a Single Item and sell it in any of those units (including breaking a Pallet to Cartons or Single items or, indeed, remaking a Pallet from all the single units that have accumulated on the warehouse floor over the years!)
sorry for the late reply and thanks btw will note it
I think no from the large tables given there are fixed addresses for suppliers and yes I was I removed the TotalPrice because it can be derived from the given so it is okay not to include it on normalization am I right?
Uhm I don't think that we need to include about break-bulks but thanks for reminding.
And these are the other 3 that I've worked on I rushed it so I can post it here for checking, It is same of the PurchaseOrder that is in 3NF.