Assignment Points: 40 1. Using the TAL database create a sequence number starting with 10000000 with a max value of 1000000000 and will increase by 5, use the nocache option. 2. Create a trigger on the orderline table that will update the onhand gty of the item table based on an order line item being inserted, updated or deleted. When the order line is created then the onhand gty in the item table will be decremented by the number ordered. When the orderline table is updated then the onhand gty of the item will be incremented or decremented based on the number ordered. When the orderline is deleted then increment the onhand qty in the item table. 3. Create 2 audit tables based on the orderline and item table. Entries for these 2 tables will be added to when the orderline and item table are inserted updated and deleted (Triggers will do this). 4. Using the Tal database create 2 indexes for each table, one to help provide performance and the other to enforce uniqueness