1. Create SQL code to create all the tables including primary and foreign keys 2. Create 3 queries and one must include a join. Some ideas include: A query to find all items that cost more than $10. A query to find all items with a name that begins with 'S' A query to find the average number of items on hand A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 2 RegionName North South East West Central SuppName Cost Company Wallflower SuppPhone 111-222-7895 222-333-1236 regionID 101 105 A query to find all items with low inventory A query to find all items in the Central region All suppliers from the North region All items supplied by Wallflower These are just some examples - feel free to create any queries you would like. The tables are below: Region RegionID 101 102 103 104 105 Supplier SuppID 1 2 3 4 Item ItemID 1001 1002 1003 1004 1005 RegionName North South East West Central SuppName Cost Company Wallflower Sam Central Glamazon Item Description Lamp Shoes Shirt Table Socks SuppPhone 111-222-7895 222-333-1236 333-444-4569 444-555-1597 ItemPrice 15.00 30.00 20.00 50.00 5.00 regionID 101 105 105 103 ItemOnHand 10 5 12 13 20 SuppID 1 3 2 4 2