Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

Normalisation

Recommended Posts

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.

Share this post


Link to post
Share on other sites
Yes, if the phonePic value depends completely on what modelNum is, you should have another table
model_pic (modelNum, phonePic).

Likewise for tarrif.

It's still a design decision, you don't have to fully normalize.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.