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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/3836-normalisation/#findComment-13375 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.