I had to write a valid TSQL query that does all the following in a transaction and will rollback if any system error is thrown.

• Create the following tables Customer, Order and Address where Customer can have many Orders and many Addresses. Order can only have one Address. Customer will have a column called CustomerNum of type NVARCHAR(3).
• Develop a SQL function that provides a unique, incremented CustomerNum in the form...