1.
Create DATABASE shajib;

CREATE Table dept(
    deptID int,
    deptName Varchar(50),
    establishmentYear int,
    Constraint D_pk PRIMARY KEY (deptID)
    );


CREATE TABLE Student (
    studentID int,
    Name Varchar(50),
    CGPA int,
    Hometown Varchar(50),
    Mobile int,
    dept int,
    PRIMARY KEY (studentID),
    FOREIGN KEY (dept) REFERENCES dept(deptID)
);


CREATE TABLE employee (
    employeeID int,
    eName Varchar(50),
    salary int,
    Hometown Varchar(50),
    dept int,
    PRIMARY KEY (employeeID),
    FOREIGN KEY (dept) REFERENCES dept(deptID)
);




INSERT INTO dept VALUES(11, 'cse', 2000);
INSERT INTO dept VALUES(11, 'eee', 2005);         ERROR
INSERT INTO dept VALUES(null, 'cse', 2000);       ERROR
INSERT INTO dept VALUES(18, 'eee', 2001);














                         2.

Create DATABASE Library;


CREATE Table Borrower(
    borrowerID int,
    borrowerName Varchar(50),
    borrowerType Varchar(50),
    Constraint b_pk PRIMARY KEY (borrowerID)
    );



CREATE Table Book(
    bookID int,
    bookTitle Varchar(50),
    Author Varchar(50),
    Price int,
    PRIMARY KEY (bookID)
    );


CREATE Table Rented(
    Bor_ID int,
    Boo_ID int,
    Date Varchar(50),
    PRIMARY KEY (Bor_ID,Boo_ID),
    FOREIGN KEY (Bor_ID) REFERENCES borrower(borrowerID),
    FOREIGN KEY (Boo_ID) REFERENCES book(bookID)
    );