CUSTOMER
Primary keys Foreign keys	Customer Number	First name	Last Name	Phone
Records (data)	1122	Sonny	Cookster	569-563-1245
	1133	Jacob	Smithster	563-289-5631
	5000	Sue	Sutherland	999-568-5454
	ORDER
	Order Number	Customer Number	Order Date
	2002	1122	11/1/2020
	2014	1133	11/10/2020
	2004	1122	12/11/2020
	2003	5000	10/3/2020
	3000	1133	11/2/2020
	ORDER LINE ITEM
	Order Number	Item Number	Quantity	Shipped?
	2002	9966	1	Y
	2014	9966	2	Y
	2004	9978	1	N
	2003	9870	1	N
	3000	9978	20	Y
	ITEM
	Item Number	Title	Distributor Number	Price
	9870	Blue hat	004	$ 10.50
	9966	Red hat	006	$ 15.70
	9968	Black hat	004	$ 31.00
	9978	White hat	008	$ 9.99

Instructions based on figure

1. Create a new database and name it Hat City.

2.Include in the Hat City database a table (entity) for Customer, Order, Line Item, and Item