OriginalSunny Posted March 1, 2006 Share Posted March 1, 2006 Hi, could someone please let me know if the tables i have created are normalised:order_item(stockID,orderID,Quantity,Price)order(orderID,datePayment,cost,custUsername,submitted)stock(stockID,modelNum,colour,price,stockAmt,prodDesc,tarrif,phonePic,tarrifPic)stock_item(modelnum,prodname)I am pretty sure they are normalised however the only thing i can think is that "phonepic" and "tarrifpic" in the stock table both rely on "modelnum" and "tarrif" so do i need to make two new tables for them???Thanks. Link to comment https://forums.phpfreaks.com/topic/3836-normalisation/ Share on other sites More sharing options...
wickning1 Posted March 1, 2006 Share Posted March 1, 2006 Yes, if the phonePic value depends completely on what modelNum is, you should have another tablemodel_pic (modelNum, phonePic).Likewise for tarrif.It's still a design decision, you don't have to fully normalize. Link to comment https://forums.phpfreaks.com/topic/3836-normalisation/#findComment-13375 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.