Create table fakultet (id f number(2) primary key,fakultet nomi varchar

6.CREATE TABLE yaqin_qarindoshlari(id_yq NUMBER(2) PRIMARY KEY, familyasi VARCHAR(50),ismi VARCHAR(50),sharifi VARCHAR(50),tel_nomeri NUMBER(2),id_q NUMBER(2),FOREIGN KEY(id_yq) REFERENCES qarindoshlik)

7.CREATE TABLE fan(id_fa NUMBER(2) PRIMARY KEY,fan_nomi VARCHAR(50),dars_soati NUMBER(2))

8.CREATE TABLE baho(id_b NUMBER(2) PRIMARY KEY,baho NUMBER(2),sana DATE,id_t NUMBER(2),FOREIGN KEY (id_t)REFERENCES talaba,id_fa NUMBER(2),FOREIGN KEY(id_fa)REFERENCES fan)

9.CREATE TABLE fakultet(id_f NUMBER(2) PRIMARY KEY,fakultet_nomi VARCHAR(50),dekan VARCHAR(50))

INSERT INTO fakultet VALUES (1,'Iqtisodiyot','Akbarov M.I')

INSERT INTO fakultet VALUES (2,'Logistika','Tursunov Z.Sh')

INSERT INTO fakultet VALUES (3,'Qurilish','Babayev A.R')

INSERT INTO fakultet VALUES (4,'Mexanika','Sobirov Sh.B')

SELECT*FROM fakultet

CREATE TABLE yunalish (id_y NUMBER(2) PRIMARY KEY,yunalish_nomi VARCHAR(50),id_f NUMBER(1),FOREIGN KEY (id_f) REFERENCES fakultet))

INSERT INTO yunalish VALUES (1,'Informatika va AT',1)

INSERT INTO yunalish VALUES (2,'Menejment',1)

INSERT INTO yunalish VALUES (3,'Bino va inshoatlar qurilishi',3)

INSERT INTO yunalish VALUES (4,'inshoatlar eksplotatsiyasi',3)

INSERT INTO yunalish VALUES (5,'Elektrotexnika va Elektromexanika',4)

INSERT INTO yunalish VALUES (6,'Yer usti transporti',4)

INSERT INTO yunalish VALUES (7,'Xizmat ko`rsatish va servis',2)

INSERT INTO yunalish VALUES (8,'Tashishni tashkil etish va TL',2)

SELECT*FROM yunalish

CREATE TABLE guruh (id_gr NUMBER(2) PRIMARY KEY,guruh_nomi VARCHAR(50),kurator VARCHAR(50),kurs VARCHAR (2),id_y NUMBER (2),FOREIGN KEY (id_y) REFERENCES yunalish )

INSERT INTO guruh VALUES (1,'AT-32','Nazarova N.J','2',1)

INSERT INTO guruh VALUES (2,'AT-31','Akbarov M.I','2',1)

INSERT INTO guruh VALUES (3,'TIF-6','Xolmurodov B.','1',4)

INSERT INTO guruh VALUES (4,'KQ-56','Eshnazarov A.','3',3)

INSERT INTO guruh VALUES (5,'ET-712','Jumayev M.','2',5)

INSERT INTO guruh VALUES (6,'ET-700','Maxmudov.S','4',6)

INSERT INTO guruh VALUES (7,'TS-642','Umarova N.','3',8)

INSERT INTO guruh VALUES (8,'IF-64','Ashurmatov E.','2',7)

SELECT*FROM guruh

CREATE TABLE talaba(id_t NUMBER(2) PRIMARY KEY,familyasi VARCHAR(50),ismi VARCHAR(50),sharifi VARCHAR(50),tugulgan_sanasi DATE ,tugulgan_joyi VARCHAR(50),id_gr NUMBER(2),FOREIGN KEY(id_gr) REFERENCES guruh)

INSERT INTO talaba VALUES (1,'Abdullayev ','Bobur','Sobirovich','10.11.1999','Buxoro viloyati',3)

INSERT INTO talaba VALUES (2,'Qo`chqoraliyev','Abror','Baxtiyorivich','30.03.1999','Namangan viloyati',1)

INSERT INTO talaba VALUES (3,'Yaxshiboyev','Muso','Bahodirivich','20.03.1999','Samarqand viloyati',2)

INSERT INTO talaba VALUES (4,'Pardayev','Javohir','Xasanjonivich','19.06.1999','Qashqadaryo viloyati',3)

INSERT INTO talaba VALUES (5,'Sultonboyev', 'Og`abek','Baxtiyorivich ','15.10.1999','Xorazm viloyati',4)

INSERT INTO talaba VALUES (6,'Egamberdiyaev','Sattor','Ravshanivich','18.01.1999','Qoraqalpog`iston Respublikasi',5)

INSERT INTO talaba VALUES (7,'Shukirillayeva ','Mehriban','Shuhratovna','08.09.1999','Qoraqalpog`iston Respublikasi',6)

INSERT INTO talaba VALUES (8,'Fatxullayev',' Asror','Donyorivich','30.11.1994','Namangan viloyati',1)

SELECT*FROM TALABA

CREATE TABLE qarindoshlik(id_q NUMBER(2) PRIMARY KEY,qarindoshligi VARCHAR(50))

INSERT INTO qarindoshlik VALUES (1,'Otasi')

INSERT INTO qarindoshlik VALUES (2,'Onasi')

INSERT INTO qarindoshlik VALUES (3,'ukasi')

INSERT INTO qarindoshlik VALUES(4,'singlisi')

SELECT*FROM qarindoshlik

DESC QARINDOSHLIK

ALTER TABLE yaqin_qarindoshlik MODIFEY(tel_nomeri NUMBER(9))

CREATE TABLE yaqin_qarindoshlari(id_yq NUMBER(2) PRIMARY KEY, familyasi VARCHAR(50),ismi VARCHAR(50),sharifi VARCHAR(50),tel_nomeri NUMBER(9),id_q NUMBER(2),FOREIGN KEY(id_q) REFERENCES qarindoshlik)

INSERT INTO yaqin_qarindoshlari VALUES (1,'A`zamova','Dilnura','Furqatjon qizi','901992001',3)

INSERT INTO yaqin_qarindoshlari VALUES (2,'Mahamadjonov','Ro`zali','Musojon o`g`li','903439903',2)

INSERT INTO yaqin_qarindoshlari VALUES (3,'Xolmatov','Boburjon','Nodirjon o`g`li','901447214',1)

INSERT INTO yaqin_qarindoshlari VALUES (4,'Xolmatov','Biloldin','Nodirjon o`g`li','970071292',4)

SELECT*FROM yaqin_qarindoshlari

CREATE TABLE fan(id_fan NUMBER(2) PRIMARY KEY,fan_nomi VARCHAR(70),dars_soati VARCHAR(50))

INSERT INTO fan VALUES(1,'Matematika','26')

INSERT INTO fan VALUES (2,'Fizika ','26')

INSERT INTO fan VALUES (3,'Ma`lumotlar bazasi','18')

INSERT INTO fan VALUES (4,'Raqamli texnika ','22')

INSERT INTO fan VALUES (5,'Multimediya','21')

SELECT*FROM fan

CREATE TABLE baho (id_b NUMBER(2) PRIMARY KEY,baho VARCHAR(50),sana VARCHAR(50),id_t NUMBER(2),FOREIGN KEY (id_t) REFERENCES fan)

INSERT INTO baho VALUES (1,'4','15.09.2019',2,1)

INSERT INTO baho VALUES (2,'5','20.09.2019',3,4)

INSERT INTO baho VALUES (3,'4','20.10.2019',4,3)

INSERT INTO baho VALUES (4,'3','25.09.2019',5,5)

INSERT INTO baho VALUES (5,'5','10.10.2019',6,4)

INSERT INTO baho VALUES (6,'4','12.10.2019',7,5)

INSERT INTO baho VALUES (7,'2','28.10.2019',2,1)

INSERT INTO baho VALUES (8,'3','09.11.2019',3,2)

SELECT*FROM baho