CREATE DATABASE lab

CREATE TABLE dept (
    deptID INT PRIMARY KEY,
    deptName VARCHAR(255),
    establishmentYear INT
);

CREATE TABLE student (
    studentID INT PRIMARY KEY,
    Name VARCHAR(255),
    cgpa DECIMAL(3, 2),
    hometown VARCHAR(255),
    mobile VARCHAR(20),
    dept INT,
    FOREIGN KEY (dept) REFERENCES dept(deptID)
);

CREATE TABLE employee (
    employeeID INT PRIMARY KEY,
    eName VARCHAR(255),
    salary DECIMAL(10, 2),
    hometown VARCHAR(255),
    dept INT,
    FOREIGN KEY (dept) REFERENCES dept(deptID)
);



INSERT INTO dept (deptID, deptName, establishmentYear)
VALUES (1, 'XSE', 2023),
       (2, 'EEE', 2022);

INSERT INTO student (studentID, Name, cgpa, hometown, mobile, dept)
VALUES (101, 'RAbiul', 3.75, 'Borishal', '017256212', 1),
       (102, 'polin', 3.90, 'Bikrompur', '01458866526', 1);



INSERT INTO employee (employeeID, eName, salary, hometown, dept)
VALUES (201, 'Mamun', 60000, 'gazipura', 1),
       (202, 'Ebrahim', 75000, 'cumilla', 2);