--1.1
CREATE TABLE FU_COMPANIES
(
        companyID INT PRIMARY KEY,
        companyName VARCHAR(31),
        companyStartDate DATE
)

--1.2
INSERT INTO FU_COMPANIES VALUES (1,'FPT Software', '1998/01/13')
INSERT INTO FU_COMPANIES VALUES (3,'Intelligent Software', '2004/07/01')
INSERT INTO FU_COMPANIES VALUES (5,'Vietname Korean Exchange', '1995/01/20')
INSERT INTO FU_COMPANIES VALUES (1,'Clip Intermedia', '2000/01/20')

DELETE FROM FU_COMPANIES WHERE companyName='Intelligent Software'

--1.3
CREATE TABLE FU_DEPARTMENTS(
	departmentID INT PRIMARY KEY,
	departmentName VARCHAR(31),
	departmentAnniversaryDate DATE
)

--1.4

INSERT INTO FU_DEPARTMENTS VALUES (2, 'Engineering Dept', '1990/03/08')
INSERT INTO FU_DEPARTMENTS VALUES (4, 'Sale Dept', '1990/08/03')
INSERT INTO FU_DEPARTMENTS VALUES (6, 'Human Resource Dept', '1990/11/20')
INSERT INTO FU_DEPARTMENTS VALUES (2, 'Accounting', '1990/11/02')

DELETE FROM FU_DEPARTMENTS WHERE departmentName='Sale Dept'

--1.5
DELETE FROM FU_COMPANIES
DELETE FROM FU_DEPARTMENTS

ALTER TABLE FU_DEPARTMENTS
ADD companyID INT FOREIGN KEY REFERENCES FU_COMPANIES(companyID)

INSERT INTO FU_DEPARTMENTS VALUES (2, 'Engineering Dept', '08/03/1990', 1)
INSERT INTO FU_COMPANIES VALUES (1, 'FPT Software', '13/01/1998')
INSERT INTO FU_DEPARTMENTS VALUES (4, 'Sale Dept', '03/08/1990',1)

TRUNCATE TABLE FU_COMPANIES
TRUNCATE TABLE FU_DEPARTMENTS
TRUNCATE TABLE FU_COMPANIES

DROP TABLE FU_COMPANIES
DROP TABLE FU_DEPARTMENTS
DROP TABLE FU_COMPANIES