Jump to content


Photo

Normalisation


  • Please log in to reply
1 reply to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 01 March 2006 - 03:54 PM

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.

#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 01 March 2006 - 07:27 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users