-- -- Show data in makes table -- MAKER_ID MAKER_NM START_YR END_YR ----------- ------------------------- -------- ------ 1 Chevrolet 1912 NULL 2 Dodge 1915 NULL 3 Ford 1903 NULL 4 Lincoln 1917 NULL 5 Mercury 1938 2011 (5 rows affected) -- -- Insert a new record -- (1 rows affected) -- -- Update a existing record -- (1 rows affected) -- -- Show data in makes table -- MAKER_ID MAKER_NM START_YR END_YR ----------- ------------------------- -------- ------ 1 Chevrolet 1912 NULL 2 Dodge 1915 NULL 3 Henry Ford 1903 NULL 4 Lincoln 1917 NULL 5 Mercury 1938 2011 9 Plymouth 1928 2001 (6 rows affected) -- -- Update a existing record -- (1 rows affected) -- -- Delete the new record -- (1 rows affected) -- -- Show data in makes table -- MAKER_ID MAKER_NM START_YR END_YR ----------- ------------------------- -------- ------ 1 Chevrolet 1912 NULL 2 Dodge 1915 NULL 3 Ford 1903 NULL 4 Lincoln 1917 NULL 5 Mercury 1938 2011 (5 rows affected)