Create a star schema for Pine Valley Furniture Company. The four tables are below. SQL.

.

Order T OrdelD, rderDate, CustomerlR 1001, '21/Oct/10', 1 1002, '21/Oct/10', 8 1003, '22/Oct/10', 15 1004, '22/Oct/10', 5 1005, '24/Oct/10', 3 1006, '24/Oct/10', 2 1007, '27/Oct/10', 11 1008, '30/Oct/10', 12 1009, '05/Nov/10', 4 1010, '05/Nov/10', 1 Product 1, 'End Table', 'Cherry', 175,1 2, 'Coffee Table, 'Natural Ash', 200, 2 3, 'Computer Desk', 'Natural Ash', 375, 2 4, 'Entertainment Center", 'Natural Maple', 650, 3 5, 'Writers Desk', 'Cherry, 325,1 6, '8-Drawer Desk', 'White Ash', 750, 2 7, 'Dining Table', 'Natural Ash', 800, 2 8, 'Computer Desk', 'Walnut', 250, 3