Write a trigger that will on creation of new employee, create and test employee who is supervised by new employee. For the value of test employee use 'Test FName' and 'Test LName'.

 

PID dbo. Hem bigint var (250) dec (10,2) Desuption Price Total Quantity bigint Supplier 10 bigint do. Customer bigint Firs Name Last Name var (50) FL-Employee-Employee dbo. Employee FK_Orderline -To-Item FirstName LastName Supervisior (1) dbo. Order Line Header D ItemID Quantity Bought Quated Price FK_Order Header - Customer FK-OrdeLine-To- -Order Header bigunt bigant not dec (192) dbo. Ordertleader 10 Customer D Sales Person!!) Date Purchase bigint vac -(50) FK-Order Heade - Employee var (30) bigint bigint bigiat bigint datetime