create a script using T-sql for a (Flower Shop) to add 4 records to create table employee with (employee ID, LastName, FirstName and State). Add products with ( Product ID, OrderID, FlowerName, FlowerColor, Price). Create Customers with (customerID, Em[ployeeID, OrderID, L:astName, FirstName, City State, Zip, Creditlimit). Create Transactions with (transaction ID, OrderID, ProductName, ProductColor, Quanity, Cost) and create inventory with (inventoryID, FlowerName, FlowerColor, StockNumber). Add constraints and syntax to create all the foreign keys. Add Null constraints on a field within one table of the database. Create user accounts for 4 employees. Employees must have a password of 9999. And be able to connect to database. One user must be given permission to create a new user.