DATABASE

1. Write SQL code to create the tables with column names and types from Figure 2. STAFF COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 STAFFID NUMBER (6,0) No (null) 2 FNAME VARCHAR2 (20 BYTE) Yes (null) 3 LNAME VARCHAR2 (25 BYTE) No (null) 4 SALARY NUMBER (8,2) Yes (null) 5 MANAGER ID NUMBER (6,0) Yes (null) 6 BRANCHID NUMBER (4,0) Yes (null) BRANCH COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 BRANCHID NUMBER (4,0) (null) 2 BRANCHNAME VARCHAR2 (30 BYTE) NO (null) 3 MANAGER ID NUMBER (6,0) Yes (null) 4 PLACEID NUMBER (4,0) Yes (null) NO PLACE COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT 1 PLACEID NUMBER (4,0) NO (null) 2 CITY VARCHAR2 (30 BYTE) No (null) 3 COUNTRY ID CHAR (2 BYTE) Yes (null) Figure 2: Schema Tables