SQLize | PHPize | SQLtest

## create tables CREATE TABLE Department ( DepartmentID INT(7) PRIMARY KEY, Dept_Name VARCHAR(30) NOT NULL, ManagerID INT(7) NULL ); CREATE TABLE Employee ( EmployeeID INT(7) PRIMARY KEY, E_FName VARCHAR(20) NOT NULL, E_LName VARCHAR(30) NOT NULL, E_Salary FLOAT(8, 2 ) NOT NULL, E_BirthDate DATE NOT NULL, E_HireDate DATE NOT NULL, DepartmentID INT(7) NULL, FOREIGN KEY (DepartmentID) REFERENCES Department(DepartmentID) ON DELETE SET NULL ); ALTER TABLE Department ADD CONSTRAINT FOREIGN KEY (ManagerID) REFERENCES Employee (EmployeeID) ON DELETE SET NULL; #INSERT TO TABLES INSERT INTO Department (DepartmentID, Dept_Name, ManagerID) VALUES (501, 'Ticketing', NULL), (502, 'Food Service', NULL), (503, 'Gift Shop', NULL), (504, 'Maintenance', NULL), (505, 'Security', NULL); INSERT INTO Employee (EmployeeID, E_FName, E_LName, E_Salary, E_BirthDate, E_HireDate, DepartmentID) VALUES (301, 'Rozan', 'Maghrbi', 5000.00, '1990-05-15', '2013-11-1', 501), (302, 'Sara', 'Ghamdi', 6000.00, '1985-12-10', '2016-08-15', 502), (303, 'Khailed', 'Zahrani', 5500.00, '1992-07-20', '2017-04-10', 503), (304, 'Majeed', 'Fahad', 7000.00, '1988-02-03', '2018-01-22', 504), (305, 'Mohammed', 'Qahtani', 4800.00, '1995-09-25', '2019-07-01', 505), (306, 'Tuleen', 'Amoudi', 5300.00, '1993-08-12', '2020-03-15', 503), (307, 'Reyouf', 'Alotibe', 4900.00, '1987-11-05', '2021-05-22', 504), (308, 'Norah', 'Fahad', 5700.00, '1991-02-28', '2022-01-30', 505);