Yangi axborot texnologiyalarining yaratilishi va ularning jamiyat turli

4-jadval. “customers” jadvalini CREATE operatori yordamida hosil qilish 
CREATE TABLE customers ( 
id customers INT(3) NOT NULL PRIMARY KEY, 
customername VARCHAR(55) NOT NULL, 
customeraddress VARCHAR(55) NOT NULL, 
customertelphone VARCHAR(15) NOT NULL, 
customersite VARCHAR(15) NOT NULL, 
customertemail VARCHAR(15) NOT NULL, 
); 
5-jadval. “customers_has_product” jadvalini CREATE operatori yordamida 
hosil qilish 
CREATE TABLE Onlineshop_has_Depertment ( 
customers_idcustomersINT(3) NOT NULL PRIMARY KEY, 
product_idproduct INT(3) NOT NULL, 
product_producttype_idproducttype INT(3) NOT NULL 
); 
6-jadval. “product” jadvalini CREATE operatori yordamida hosil qilish 
CREATE TABLE product ( 
Idproduct INT(3) NOT NULL PRIMARY KEY, 
productname VARCHAR(15) NOT NULL, 
product_producttype_idproducttype INT(3) NOT NULL 
); 

---

7-jadval. “product_has_Order” jadvalini CREATE operatori yordamida hosil 
qilish 
CREATE TABLE product_has_Order ( 
product_idproduct INT(3) NOT NULL PRIMARY KEY, 
product_producttype_idproducttype INT(3) NOT NULL, 
Order_idOrderINT(3) NOT NULL 
); 
8-jadval. “producttype” jadvalini CREATE operatori yordamida hosil qilish 
CREATE TABLE producttype ( 
idproducttype INT(3) NOT NULL PRIMARY KEY, 
producttypename VARCHAR(55) NOT NULL, 
productimageVARCHAR(55) NOT NULL, 
productprice VARCHAR(15) NOT NULL 
); 
9-jadval. “manufacture” jadvalini CREATE operatori yordamida hosil qilish 
CREATE TABLE manufacture ( 
idmanufacture INT(3) NOT NULL PRIMARY KEY, 
manufacturename VARCHAR(55) NOT NULL, 
manufacturedateVARCHAR(55) NOT NULL, 
product_idproduct INT(3) NOT NULL, 
product_producttype_idproducttype INT(3) NOT NULL 
);