Create database fakultet1; create table fakultet

7-topshiriq.SQLda ma’lumotlarni manipulyatsiya qilish.
Baza nomi Fakultet.
CREATE DATABASE fakultet1;


CREATE TABLE fakultet (
idfakultet INT PRIMARY KEY,
fakultet_nomi VARCHAR(30) NOT NULL,
sayt VARCHAR(34) NOT NULL,
dekan VARCHAR(45) NOT NULL,
e_mail VARCHAR(34) NOT NULL);
CREATE TABLE xodim (
idxodim INT PRIMARY KEY,
fish VARCHAR(30) NOT NULL,
yosh INT NOT NULL,
lavozim VARCHAR(45) NOT NULL,
manzil VARCHAR(34) NOT NULL);
CREATE TABLE guruh (
idguruh INT PRIMARY KEY,
nom VARCHAR(30) NOT NULL,
guruhlar _soni INT NOT NULL,
guruh_sardori VARCHAR(45) NOT NULL,
tyutor VARCHAR(630) NOT NULL);
CREATE TABLE talaba (
idtalaba INT PRIMARY KEY,
fish VARCHAR(30) NOT NULL,
yosh INT NOT NULL,
shartnoma TEXT(4500) NOT NULL,
manzil VARCHAR(67) NOT NULL);
CREATE TABLE fanlar (
id_fan INT PRIMARY KEY,
nom VARCHAR(30) NOT NULL,
soat INT NOT NULL,
yuriqnoma TEXT(4500) NOT NULL,
oqituvchi VARCHAR(67) NOT NULL);
SQL tili orqali jadvallarga yangi ma’lumotlarni qo’shish. INSERT operartori.
FAKULTET
INSERT INTO fakultet(idfakultet,fakultet_nomi,sayt,dekan,e_mail) VALUES
(1,'raqamli texnalogiya','raq.uz','Bbayarov A','RAQTEX.GMAIL.COM');
INSERT INTO fakultet(idfakultet,fakultet_nomi,sayt,dekan,e_mail) VALUES
(2,' fizika fakultet','fiz.uz','Svffjb A','fizfak.GMAIL.COM');
INSERT INTO fakultet(idfakultet,fakultet_nomi,sayt,dekan,e_mail) VALUES
(3,'biologiya fakultet','bio.uz','safarov A','bio.GMAIL.COM');
INSERT INTO fakultet(idfakultet,fakultet_nomi,sayt,dekan,e_mail) VALUES
(4,'ruslet fakultet','rusl.uz','Qkjrnfk H','RUSL.GMAIL.COM');
INSERT INTO fakultet(idfakultet,fakultet_nomi,sayt,dekan,e_mail) VALUES
(5,'tarix fak','tarix.uz','Qhjbj Hhjh','tarix.GMAIL.COM');

FANLAR
INSERT INTO fanlar(id_fan,nom,soat,yuriqnoma,oqituvchi) VALUES
(1,'algoritmlash mal struk',90,'ohvkhiuhsuhrgiru','Ximmatov I');
INSERT INTO fanlar(id_fan,nom,soat,yuriqnoma,oqituvchi) VALUES
(2,'MATIMATIK ANALIZ',123,'ohvkhiuhsuhrgiru','Usmonov S');
INSERT INTO fanlar(id_fan,nom,soat,yuriqnoma,oqituvchi) VALUES
(3,'PROGRAMMALASH',128,'aaaaaa','Abdusalomova G');
INSERT INTO fanlar(id_fan,nom,soat,yuriqnoma,oqituvchi) VALUES
(4,'MBT',98,'BBBBB','Yusupov O');
INSERT INTO fanlar(id_fan,nom,soat,yuriqnoma,oqituvchi) VALUES
(5,'FALSAFA',120,'BBBBB','Yusupov M');

GURUH
INSERT INTO guruh(idguruh,nom,guruhlar_soni,guruh_sardori,tyutor,guruh_raqami) VALUES
(1,'komp ilm',4,'Tursunov A','Bekpulatova G',302);
INSERT INTO guruh(idguruh,nom,guruhlar_soni,guruh_sardori,tyutor,guruh_raqami) VALUES
(2,'komp ilm',4,'Xudoyberdiyev S','Bekpulatova G',303);
INSERT INTO guruh(idguruh,nom,guruhlar_soni,guruh_sardori,tyutor,guruh_raqami) VALUES
(3,'komp ilm',4,'Yagafarov D','Bekpulatova G',301);
INSERT INTO guruh(idguruh,nom,guruhlar_soni,guruh_sardori,tyutor,guruh_raqami) VALUES
(4,'komp ilm',4,'Dhsx J','Bekpulatova G',304);

TALABA
INSERT INTO talaba(idtalaba,fish,yosh,shartnoma,manzil) VALUES
(1,'RAXMONOV UYGUN',23,'IKKI TOMONLAMA','PASTDARGOM');
INSERT INTO talaba(idtalaba,fish,yosh,shartnoma,manzil) VALUES
(2,'TURSUOV AZIZ',18,'IKKI TOMONLAMA','PASTDARGOM');
INSERT INTO talaba(idtalaba,fish,yosh,shartnoma,manzil) VALUES
(3,'NAZROV ELBEK',23,'IKKI TOMONLAMA','PASTDARGOM');
INSERT INTO talaba(idtalaba,fish,yosh,shartnoma,manzil) VALUES
(4,'HUDOYNAZAROV HAKIMBEK',23,'IKKI TOMONLAMA','URGUT');
INSERT INTO talaba(idtalaba,fish,yosh,shartnoma,manzil) VALUES
(5,'POLVONOV ABU',21,'IKKI TOMONLAMA','SAMARQAND');

XODIM
INSERT INTO xodim(idxodim,fish,yosh,lavozim,manzil) VALUES
(1,'POLVONOV ABU',21,'OQITUVCHI','SAMARQAND');
INSERT INTO xodim(idxodim,fish,yosh,lavozim,manzil) VALUES
(2,'YUSUPOV O',34,'KAFIDRA MUDIRI','SAMARQAND');
INSERT INTO xodim(idxodim,fish,yosh,lavozim,manzil) VALUES
(3,'YUSUPOV M',38,'OQITUVCHI','NUROBOQ');
INSERT INTO xodim(idxodim,fish,yosh,lavozim,manzil) VALUES
(4,'URINBAYIV J',39,'OQITUVCHI','QOSHRABOD');
INSERT INTO xodim(idxodim,fish,yosh,lavozim,manzil) VALUES
(5,'TURSUNOV A',32,'OQITUVCHI','POYARIQ');

Sql tili orqali ma’lumotlarni tahrirlash.UPDATE operatori orqali tahrirlash.
UPDATE fakultet SET sayt='fakultet_sayt' WHERE idfakultet=6;
UPDATE fanlar SET nom='fanlarning_nomi' WHERE id_fan=7;
UPDATE talaba SET fish='familiya_ism' WHERE idtalaba=7;

UPDATE xodim SET lavozim='xodim_lavozim' WHERE idxodim=8;

Sql tili javaldagi malumotlarni o’chirish.DELETE opertori.
DELETE FROM fakultet WHERE idfakultet>5 AND idfakultet<8;
DELETE FROM fanlar WHERE id_fan>4 AND id_fan<7;

DELETE FROM guruh WHERE idguruh>3 AND idguruh<6;

DELETE FROM talaba WHERE idtalaba>10 AND idtalaba<15;

DELETE FROM xodim WHERE idxodim>11 AND idxodim<100;