7163558630

ER-DIAGRAM

□ custoniers	▼									Ul products ^v
custamerjd INT										' product_.no INT
^customer firsln	me VARCHAR(40)			orders	▼			orderdetails		0 product name VARCHAR(100)
• customerjastname VARCHAR (40)				order _no IN				orders_order_no INT		' product_desarptjon TBCT
Ocustomer_addre	VARCHAR(65)		-W	4 customers_o	jstcmerjd INT	H-K		' Products_product_.no INT	H-H	O productjjrice OEaM«.(10,2)
O customer_phooe INT(łO)				- order_satus VARCHAR(4S)				0 puanbty INT		' product_stock INT
> customer_emałt	VARCHAR(55)				►			►		OminjstocklNT
zipcode_»p_code INT(4)										> categcry_categoryjd INT
										*•
			□	order_status	has orders	T

order_satus_order_sBtusJd INT

Vores ER-diagram illustrerer hvordan vores database er bygget op med de forskellige entiteter og attributterne. og dette diagram er lavet pa 3 normalform.