Guruh talabasi Ixtiyorov Diyorbekning ma’lumotlar bazasi fanidan

310-22 guruh talabasi Ixtiyorov Diyorbekning ma’lumotlar bazasi fanidan
2-amaliy ishi

1. 
   Noutbuklar savdosi bilan shug’ullanuvchi do’konlar tarmog’i uchun taxminiy MB yarating
   

CREATE TABLE noutbuklar_dokoni(
id INT PRIMARY KEY AUTO_INCREMENT,
dokon_raqami INT,
noutbuklar_id INT,
monitor_id INT,
blok_id INT,
FOREIGN KEY (blok_id) REFERENCES blok(id) ON DELETE SET NULL,
FOREIGN KEY (monitor_id) REFERENCES monitor(id) ON DELETE SET NULL,
FOREIGN KEY (noutbuklar_id) REFERENCES noutbuklar(id) ON DELETE SET NULL
);

2.

CREATE TABLE noutbuklar(
id INT PRIMARY KEY AUTO_INCREMENT,
nomi VARCHAR(50),
ishlab_chiqarilgan_yili DATE,
kompany VARCHAR(50),
protsessori VARCHAR (250)
);

3.

CREATE TABLE monitor(
id INT PRIMARY KEY AUTO_INCREMENT,
turlari VARCHAR(50),
company VARCHAR (50),
model VARCHAR (50)
);

4.

CREATE TABLE blok(
id INT PRIMARY KEY AUTO_INCREMENT,
nomi VARCHAR(50),
company VARCHAR(50),
protsessori VARCHAR(50),
videocard VARCHAR(50)
);

5. drawSQL dagi natijasi: