CREATE TABLE dept(
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

INSERT INTO dept
VALUES
(101, "eng"),
(102, "maths");

-- SELECT*FROM dept;

UPDATE dept 
SET id=111
WHERE id=101;

SELECT*FROM dept;

CREATE TABLE teacher(
    id INT PRIMARY KEY,
    name VARCHAR(50),
    dept_id INT,
    FOREIGN KEY(dept_id)REFERENCES dept(id)
    ON UPDATE CASCADE
    ON DELETE CASCADE
    
);


INSERT INTO teacher
VALUES
(101, "adam", 101),
(102, "eve", 102);

SELECT*FROM teacher;