Question

Thumbs up for the Correct answer with all steps

For the questions below, write the SQL statement and also answer the question if requested. You need to show the execution result of each SQL statement. 1. Create a sequence object (named with SalespersonIDSeq) which starts with 11, is increased by 1 with nocycle 2. Insert two new salesperson records below into Salesperson _T table. number generated using SalespersonIDSeq object For SalespersonID, use a sequence <SalespersonName: Brandon Young, SalespersonCity: Fort Wayne, SalespersonState: IN SalespersonZip: 46805 > < SalespersonName: Bailey Whitehill, SalespersonCity: Fort Wayne, SalespersonState: IN SalespersonZip: 46814 > 3. Create a view (named with Salesperson _IN) of sales persons who work in Indiana (IN). The view shows only SalespersonID, SalespersonName, SalespersonCity, and SalespersonState information. When creating the view, use WITH CHECK OPTION 4. Change the city (SalespersonCity) of Brandon Young to Indianapolis', and query to check it the corresponding record is correctly changed. 5. Next, change the state (SalespersonState) of Brandon Young to I If you have an error in this update,

Answer 1

1. CREATE SEQUENCE SalespersonIDSeq

As INT

START WITH 11

INCREMENT BY 1

NO CYCLE;

2. INSERT INTO Salesperson_T(SalespersonID, SalespersonName, SalespersonCity, SalespersonState, SalespersonZIP)

VALUES

(NEXT VALUE FOR SalespersonIDSeq, 'Brandon Young', 'Forte Wayne', 'IN',46805),

(NEXT VALUE FOR SalespersonIDSeq, 'Bailey Whitehill', 'Forte Wayne', 'IN',46814);

3. CREATE VIEW Salesperson_IN

AS

SELECT SalespersonID, SalespersonName, SalespersonCity, SalespersonState

FROM Salesperson_T

WITH CHECK OPTION;