a. CREATE TABLE Personal (
PersID INTEGER NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE,
Foreign Key(PostID) References post(PostID));

b.
CREATE TABLE Personal
ADD COLUMNS(
PersID INT NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone TEXT(15),
Salary VARCHAR(25),
HireDate DATE,
FireDate DATE);

c. ALTER TABLE Personal
ADD FOREIGN KEY(PersId) LEFT REFERENCES Participation(PersId)
d. CREATE TABLE Personal (
PersID INTEGER REQUIRED,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);

e.
INSERT TABLE Personal (
PersID INTEGER NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);


f.

CREATE TABLE Personal (
PersID INTEGER NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);

g. CREATE TABLE Personal (
PersID INTEGER,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);



h. CREATE TABLE Personal (
PersID INTEGER,
FName VARCHAR(25),
HireDate DATE,
FireDate DATE);

i. ALTER TABLE Personal (
PersID INTEGER NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);



j.
ALTER TABLE personal ADD department VARCHAR;

k. CREATE TABLE Personal
ADD COLUMNS(
PersID INT NOT NULL PRIMARY KEY,
FName VARCHAR(25) NOT NULL,
LName VARCHAR(25) NOT NULL,
Phone VARCHAR(15),
Salary REAL,
HireDate DATE,
FireDate DATE);