Create a Table with a primary key column:$$

$$

$1.$ CREATE TABLE departments

$($ department$\_$id INTEGER PRIMARY KEY

$,$ department$\_$name VARCHAR$(30)$

$,$ location$\_$id INTEGER

$)$ ;

$$

$$

Create a Table with a Foreign Key : $$

$2.$ CREATE TABLE employees

$($ employee$\_$id INTEGER

$,$ first$\_$name VARCHAR$(20)$

$,$ last$\_$name VARCHAR$(25)$

$,$ email VARCHAR$(25)$

$,$ phone$\_$number VARCHAR$(20)$

$,$ hire$\_$date DATE

$,$ job$\_$id VARCHAR$(10)$

$,$ salary INTEGER

$,$ commission$\_$pct INTEGER

$,$ manager$\_$id INTEGER

$,$ department$\_$id INTEGER

$,$ constraint pk$\_$emp primary key $($employee$\_$id$)$

$,$ constraint fk$\_$deptno foreign key $($department$\_$id$)$ references departments$($department$\_$id$)$

$)$ ;

$$

$3.$ Insert Records into Tables$$

## Insert into Departments table

$$INSERT INTO departments VALUES $(20,$'Marketing',$180)$;

$$INSERT INTO departments VALUES $(30,$'Purchasing',$1700)$;

$$INSERT INTO departments VALUES $(40,$ 'Human Resources',$2400)$;

$$INSERT INTO departments VALUES $(50,$ 'Shipping',$1500)$;

$$INSERT INTO departments VALUES $(60,\text{'}$IT$\text{'},1400)$;

$$ INSERT INTO departments VALUES $(70,$ 'Public Relations',$2700)$;

$$INSERT INTO departments VALUES $(80,$ 'Sales',$2500)$;

$$INSERT INTO departments VALUES $(90,$ 'Executive',$1700)$;

$$INSERT INTO departments VALUES $(100,$ 'Finance',$1700)$;

$$INSERT INTO departments VALUES $(110,$ 'Accounting',$1700)$;

$$INSERT INTO departments VALUES $(120,$ 'Treasury' $,1700)$;

$$INSERT INTO departments VALUES $(130,$ 'Corporate Tax' $,1700)$;

$$ INSERT INTO departments VALUES $(140,$ 'Control And Credit' $,1700)$;

$$INSERT INTO departments VALUES $(150,$ 'Shareholder Services', $1700)$;

$$INSERT INTO departments VALUES $(160,$ 'Benefits', $1700)$;

$$INSERT INTO departments VALUES $(170,$ 'Payroll' $,1700)$;