CREATE TABLE  student (
  ID int primary key,
    NAME varchar(100),
    DEPT VARCHAR (100)
    );
    
    CREATE TABLE COURSE (
        C_NO INT PRIMARY KEY,
        TITLE VARCHAR (100),
        CREDIT INT
        );
   CREATE TABLE TAKE (
        C_NO INT,
        ID INT,
       Date DATE,
      PRIMARY KEY (C_NO, ID),
       FOREIGN KEY (C_NO) REFERENCES  COURSE(C_NO),
         FOREIGN KEY (ID) REFERENCES  STUDENT(ID)
        );
        
  CREATE TABLE TEACH ( 
      T_ID INT,
      C_NO INT,
      PRIMARY KEY (T_ID, C_NO),
      FOREIGN KEY (T_ID) REFERENCES  TEACHER(T_ID),
      FOREIGN KEY (C_NO) REFERENCES  COURSE(C_NO)
      );
      
     INSERT INTO student (ID, NAME, DEPT) VALUES (61, 'ABDULLAH', 'CSE');
INSERT INTO student (ID, NAME, DEPT) VALUES (62, 'ADIB', 'CSE');
INSERT INTO student (ID, NAME, DEPT) VALUES (63, 'BORSHA', 'EEE');
INSERT INTO student(ID, NAME, DEPT) VALUES (64, 'NABIHA', 'EEE');
INSERT INTO student (ID, NAME, DEPT) VALUES (65, 'SHAHEED', 'BBA');

INSERT INTO COURSE (C_NO, TITLE, CREDIT) VALUES (511, 'JAVA', 3.00);
INSERT INTO COURSE (C_NO, TITLE, CREDIT) VALUES (512, 'C++', 3.00);
INSERT INTO COURSE (C_NO, TITLE, CREDIT) VALUES (513, 'ELECTRONIC DEVICE', 3.00);
INSERT INTO COURSE (C_NO, TITLE, CREDIT) VALUES (514, 'DLD', 3.00 );
INSERT INTO COURSE (C_NO, TITLE, CREDIT) VALUES (515, 'ACCOUNTING', 2.00 );

INSERT INTO TEACHER (T_ID, T_NAME, T_DEPT) VALUES (71, 'GIAN', 'CSE');
INSERT INTO TEACHER (T_ID, T_NAME, T_DEPT) VALUES (72, 'MOMIN', 'CSE');
INSERT INTO TEACHER (T_ID, T_NAME, T_DEPT) VALUES (73, 'RAYHAN', 'EEE');
INSERT INTO TEACHER (T_ID, T_NAME, T_DEPT) VALUES (74, 'ANIKA', 'EEE');
INSERT INTO TEACHER (T_ID, T_NAME, T_DEPT) VALUES (75, 'MIM', 'BBA');

INSERT INTO TAKE (C_NO, ID, DATE) VALUES (411, 41, '2024-1-12');
INSERT INTO TAKE (C_NO, ID, DATE) VALUES (412, 42, '2024-1-13');
INSERT INTO TAKE (C_NO, ID, DATE) VALUES (413, 43, '024-1-12');
INSERT INTO TAKE (C_NO, ID, DATE) VALUES (414, 44, '2024-1-11');
INSERT INTO TAKE (C_NO, ID, DATE) VALUES (415, 45, '2024-1-14');

INSERT INTO TEACH (T_ID,C_NO) VALUES (21, 511);
INSERT INTO TEACH (T_ID,C_NO) VALUES (22, 512);
INSERT INTO TEACH (T_ID,C_NO) VALUES (23, 513);
INSERT INTO TEACH (T_ID,C_NO) VALUES (24, 514);
INSERT INTO TEACH (T_ID,C_NO) VALUES (25, 515);