PHP Code:
CUSTOMER
+----------------------+
| customer_number (PK) |
+----------------------+
| name |
| address |
| phone_number |
| credit_rating |
+----------+-----------+
|
customer |
places |
order | order
| placed
| by
| customer
|
ORDER ^
+----------------------+
| order_no (PK) |
+----------------------+
| customer_number (FK) |
| order_date |
| shipping_address |
| credit_card_type |
| credit_card_number |
+----------------------+