The relationship model in database 

Shipments

S#	P#	QTY
S1	P1	300
S2	P2	200
S3	P3	500

Parts

P#	PNAME	COLOR	WEIGHT	CITY	COUNTRY
P1	Nut	Red	12	London	Great Britain
P2	Bolt	Green	17	Paris	France
P3	Screw	Blue	17	Rome	Italy
P4	Screw	Red	14	London	Great Britain
P5	Cam	Blue	12	Paris	France

 a) Is it allowed to move the columns in Parts so that they are in a different order? Why or why not? b) Is it allowed to change the city for P1 from London to London, Athens? Why or why not not? c) Make an Equi Join on the above relationships and report the answer. d) The Relationship Parts is only in 2NF, why? e) Why is it not allowed for a primary key to be ZERO?