How do I put these Tables in 3rd Normal Form? Thanks for your time

PK = primary key, FK = Foreign Key

tables
VENDOR(Vendor_ID(PK), Address)
PRICE QUOTE(Quote_Quantity(PK), Price)
PART(Item_Number(PK), Description)
PART RECEIPT(Order_Number(PK), Date, Order_Quantity(FK))

Relations
VENDOR 1:Many PRICE QUOTE
PRICE QUOTE 1:Many PART RECEIPT
PART 1:Many PRICE QUOTE

I dunno
I tend not to think in terms of 1NF, 2NF, 3NF they are more aimed at learners int he db design pathway
what did your teacher say?
what do your fellow students & pupils say

there are some excellent articles on normalisation, not least
http://www.r937.com\Relational.html
http://www.tonymarston.net/php-mysql...se-design.html

ultimately what do you think
do you think you have pushed your desing toe 3NF, as after all its your homework

I always find creating the tables and populating them with sample data a great way to spot potential areas for improvement...

I find integers way too limiting, and prefer applying fractal dimensions to my databases. My preference is for a normalization level somewhere between 2.8 and 3.1.

What's BCNF on that scale?

i find the lack of precision totally uncool
I try to achieve tolerance to two decimal places
where's your sense of pride in your work
where's that honesty in a good days work for a good days pay.....









...does this need a Mr Winky, or is it merely presumed

The normal forms for matter are solid, liquid, and gas. Plasma is arguable, but fun to play with!

-PatP

I appreciate the replies guys, I'm not a db expert. I was hoping that one of you might walk me through the process of coverting it to 3rd normal form ^_^

You should just have to add the relations to the tables, and they will be in 3rd normal form.

when is this assignment due?

i could walk you through this some time late next week...