Notes

CREATE DATABASE OGRETMEN_DB3;

USE OGRETMEN_DB3;

CREATE TABLE OGRETMEN(
OGR_ID_NO INT NOT NULL,
AD VARCHAR(20) NOT NULL,
SOYAD VARCHAR(20) NOT NULL,
DOG_TAR DATE,
CINSIYET CHAR(1),
BRUT FLOAT,
BOLUM_NO SMALLINT,
BOLUM_YON_ID_NO INT NOT NULL,
E_POSTA VARCHAR(30) NOT NULL);

CREATE TABLE BOLUM(
BOL_NO SMALLINT,
BOLUM VARCHAR(30) NOT NULL,
TEL_NO VARCHAR(7) NOT NULL,
E_POSTA VARCHAR(30) NOT NULL);


INSERT INTO OGRETMEN
(OGR_ID_NO,AD,SOYAD,DOG_TAR,CINSIYET,BRUT,BOLUM_NO,BOLUM_YON_ID_NO,E_POSTA)
VALUES (112,'Ufuk','KUBİLAY','1970-06-01','E',8000,1,113,'[email protected]'),
(113,'Alper','DİLEKTAŞLI','1977-07-04','E',9000,1,113,'[email protected]'),
(114,'Beril','MERAL','1977-06-03','K',7000,2,116,'[email protected]'),
(115,'Onur','KARDEŞ','1971-08-05','E',4500,2,116,'[email protected]'),
(116,'Ayşe','ŞEN','1977-07-08','K',8000,2,116,'[email protected]'),
(117,'Deniz','US','1972-08-07','K',5800,3,117,'[email protected]'),
(118,'Erkin','TEK','1972-07-11','E',6000,4,118,'[email protected]');

INSERT INTO BOLUM(BOL_NO,BOLUM,TEL_NO,E_POSTA)
VALUES(1,'Bilgisayar Mühendisliği',8784512,'[email protected]'),
(2,'Makine Mühendisliği', 8784513,'[email protected]'),
(3,'Enerji Mühendisliği',8784514,'[email protected]'),
(4,'Matematik Mühendisliği',8784515,'[email protected]');