DATABASE

2. Write SQL code to insert values (ALL RECORDS) in tables as shown in Figure 3. Worksheet Query Builder select * from staff Worksheet Query Builder select * from place 4 Script Output Query Result SQL Al Rows Fetched: 11 in 0.003 seconds STAFFID FNAME LNAME SALARY 1 95 Are Abdulla 2400 2 96 ASO ALI 2100 3 97 SARA SAMAN 2100 98 Karwan Osman 2100 99 SAZ Bwar 2900 6 100 Steven King 24000 7 101 Neena Kochhar 17000 102 Lex De Haan 17000 103 Alexander Hunold 9000 104 Bruce Ernst 6000 105 David Austin 4800 Script Output Query Result SQL All Rows Fetched: 10 in 0.003 seconds PLACEID CITY COUNTRY_ID 1 900 Malaysia MY 2 800 IRAQ IQ 3 1000 Roma IT 1100 Venice IT 1200 Tokyo 1300 Hiroshima 1400 Southlake US 1500 South San Francisco US 1600 South Brunswick US 1700 Seattle US MANAGER_ID BRANCHID (null) (null) (null) 30 104 30 105 (null) 105 100 (null) 90 100 90 100 90 102 60 103 60 103 60 5 4 5 JP JP 6 8 7 8 9 10 11 9 10 Worksheet Query Builder select * from branch Figure 3: Tables contents Script Output Query Result SQL Al Rows Fetched: 6 in 0.128 seconds BRANCHID BRANCHNAME MANAGER_ID PLACEID 10 Administration 200 1700 30 Purchasing 114 1700 50 shipping 121 1500 60 IT 103 1400 90 Executive 100 1700 100 Finance 108 1700 2 3 4 5 6