Respublikasi oliy va o’rta-maxsus ta’lim vazirligi samarqand davlat universiteti raqamli texnologiyalar

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE
Tasnifi
Idharddware_story	int	X		X	X	Kalit maydon
name	VARCHAR2(64)			X	X	nomi
adress	VARCHAR2(64)			X		Manzili
site	VARCHAR2(50)			X		sayti

employes jadvali

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
Employe_id	NUMBER	X		X	X	Kalit maydon
name	VARCHAR(250)			X	X	Xodim nomi
adress	NUMBER		X	X	X	Xodim manzili
Telephone	NUMBER		X	X	X	Hodimlar tel_raqami
email	NUMBER			X	X	emaili

product jadvali maxsulot haqida ma`lumotlarni saqlash uchun jadval.

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
product_Id	NUMBER	X		X	X
name	VARCHAR2			X	X	Maxsulot nomi
price	NUMBER			X	X	Maxsulot narxi
type	NUMBER			X	X	Maxsulot turi

department jadvali
bo’lim haqidagi haqida ma`lumotlarni saqlash uchun jadval.

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
Department_id	NUMBER	X		X	X	Kalit maydon
employe	VARCHAR2(50)			X		xodimlari
leader	VARCHAR2(50)			X		Boshlig’i
number	VARCHAR2(50)			X		numeri

Productcount jadvali
Peshtaxta haqida ma`lumotlari saqlash uchun jadval.

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
Productcount_id	NUMBER	X		X	X	Kalit maydon
name	VARCHAR2(20)			X	X	Peshtaxta nomi
memorization	VARCHAR(100)			X	X	joylashuvi
number	VARCHAR(500)			X	X	Peshtaxta raqami

Salary jadvali
Maosh saqlash uchun jadval.

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
maosh_id	NUMBER	X		X	X	Kalit maydon
salarycount	VARCHAR2(150)			X	X	Fish

Leader jadvali
Boshliq saqlash uchun jadval.

Atribut	Ma`lumot turi	PKEY	FKEY	NOT NULL	UNIQUE	Tasnifi
leader_id	NUMBER	X		X	X	Kalit maydon
name	VARCHAR2(150)			X	X	nomi
adress	VARCHAR2(150)			X		Manzili
email	VARCHAR2(150)			X	X	emaili

2-rasm Loyihalashtirilayotgan ma`lumotlar bazasining datalogik modeli
2.3 JADVALLARNING O’ZARO BOG’LANISHI



3-rasm Hardware store va emloye jadvallari bog’lanishi

4-rasm Hardware store va leader jadvallarining bo’lanishi

5-rasm Hardware store va department jadvallari bog’lanishi

6-rasm employe va salary_hasemploye jadvallari bog’lanishi

7-rasm Salary va salary_has_employee jadvallari bog’lanishi

8-rasm Productcount va product_has_department jadvallari bog’lanishi

9-rasm Productcount va product jadvallari bog’lanishi

10-rasm Product_has_department va department jadvallari bog’lanishi

11-rasm Product_has_department va product bog’lanishi

12-rasm Product va department_has_product jadvallari bog’lanishi

2.4 SQL operatorlari yordamida jadvallarni hosil qilish va jadvallarga ma’lumotlar kiritish

1. jadval. “hardware store” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE hardware store
(Idhardware store INT(11) NOT NULL PRIMARY KEY,
hardware storename VARCHAR(45) NOT NULL, hardware storeemployee_id INT(11) NOT NULL, hardware storetel VARCHAR(45) NOT NULL,);

2. jadval. “employee_has_salary” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE employee_has_salary (employee _id employee INT(11) NOT NUL, salary _id salary INT(11) NOT NULL,);

3. jadval. “employee”jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE employee (Id employee
INT(11) NOT NULL PRIMARY KEY,
employeename VARCHAR(45) NOT NULL, employee_id INT(11),
employee_id INT(11),);

4. jadval. “leader” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE leader (
id leader INT(11) NOT NULL PRIMARY KEY, leadername VARCHAR(45) NOT NULL, leadertelephone VARCHAR(45) NOT NULL, leaderaddress VARCHAR(45) NOT NULL, leaderemail VARCHAR(45) NOT NULL,);

5. jadval. “department_has_product” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE department_has_product ( department_iddepartmentINT(11) NOT NUL, product _id product INT(11) NOT NULL,);

6. jadval. “maxsulot” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE maxsulot
maxsulot _id INT(11) NOT NUL, maxsulot VARCHAR(45) NOT NULL,
);

7. jadval. “product _has_hardware store” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE hardware store_has_employee (
hardware store_id_employeeINT(11) NOT NUL, hardware store_idemployeeINT(11) NOT NULL, );

8. jadval. “maxsulot” jadvalini CREATE operatori yordamida hosil qilish

CREATE TABLE yunalish (

idmaxsulot INT(11) NOT NULL PRIMARY KEY,
maxsulotname VARCHAR(45) NOT NULL, dokon_id INT(11) NOT NULL);

SQLda INSERT operatorlari yordamida jadvallarga yozuvlar qo’shish

“Xo’jalik mollari do’koni” jadvaliga INSERT operatori yordamida yozuv qo’shish

Xo’jalik mollari jadvalini INSERT operatori yordamida hosil qilish.

1. 
   INSERT INTO hardware store VALUES (1, 'idhardware store ' ,' hardware storename', ' hardware storesite',' hardware storenumber',' hardware storemanager');
   
2. 
   INSERT INTO hardware store VALUES (2, 'id hardware store1',' hardware storename', ' hardware storesite',' hardware storenumber',' hardware storemanager');
   
3. 
   INSERT INTO hardware store VALUES (3, 'idhardware store2',' hardware storename', ' hardware storesite',' hardware storenumber',' hardware storemanager');
   

Employee jadvalini INSERT operatori yordamida hosil qilish.

1. 
   INSERT INTO employee VALUES (1, 'idemployee1', 'employeename', 'employeesalary','employeetelephone','employeeadress');
   
2. 
   INSERT INTO employee VALUES (2, 'idemployee2', 'employeename', 'employeesalary','employeetelephone','employeeadress');
   
3. 
   INSERT INTO employee VALUES (3, 'idemployee3', 'employeename', 'employeesalary','employeetelephone','employeeadress');
   
4. 
   INSERT INTO employee VALUES (4, 'idemployee4', 'employeename', 'employeesalary','employeetelephone','employeeadress');
   
5. 
   INSERT INTO employee VALUES (5, 'idemployee5', 'employeename', 'employeesalary','employeetelephone','employeeadress');
   

Department jadvalini department operatori yordamida hosil qilish

1. 
   INSERT INTO departmentVALUES (1, 'iddepartment','departmentname', 'departmentleader','departmentnumber','departmentemployee');
   
2. 
   INSERT INTO departmentVALUES (2, 'iddepartment','departmentname', 'departmentleader','departmentnumber','departmentemployee');
   
3. 
   INSERT INTO departmentVALUES (3, 'iddepartment','departmentname', 'departmentleader','departmentnumber','departmentemployee');
   
4. 
   INSERT INTO departmentVALUES (4, 'iddepartment','departmentname', 'departmentleader','departmentnumber','departmentemployee');
   
5. 
   INSERT INTO departmentVALUES (5, 'iddepartment','departmentname', 'departmentleader','departmentnumber','departmentemployee');
   

Product jadvalini product operatori yordamida hosil qilish.

1. 
   INSERT INTO product VALUES (1, 'idproductcount','productname', 'productprise',' producttype');
   
2. 
   INSERT INTO product VALUES (2, 'idproductcount','productname', 'productprise',' producttype');
   
3. 
   INSERT INTO product VALUES (3, 'idproductcount','productname', 'productprise',' producttype');
   
4. 
   INSERT INTO product VALUES (4, 'idproductcount','productname', 'productprise',' producttype');
   
5. 
   INSERT INTO product VALUES (5, 'idproductcount','productname', 'productprise',' producttype');
   

Productcount jadvalini productcount operatori yordamida hosil qilish.

1. 
   INSERT INTO productcount
   

VALUES (1, 'idproductcount','productname', 'productprise',' producttype',' productdepartment ');

2. 
   INSERT INTO productcount
   

VALUES (2, 'idproductcount','productname', 'productprise',' producttype',' productdepartment ');

3. 
   INSERT INTO productcount
   

VALUES(3,'idproductcount','productname', 'productprise',' producttype',' productdepartment ');

4. 
   INSERT INTO productcount
   

VALUES (4, 'idproductcount','productname', 'productprise',' producttype',' productdepartment ');INSERT INTO productcount VALUES (5, 'idproductcount','productname', 'productprise',' producttype',' productdepartment ');Salary jadvalini CREATE operatori yordamida hosil qilis

Xulosa

“Xo’jalik mollari ” nomli ma’lumotlar bazasi mantiqiy modelini tuzib chiqdik va bu ma`lumotlar bazasini yaratish va boshqarish dasturini qo`llash juda kata qulayliklar yaratdi. Bu baza orqali “Xo’jalik mollari” xodimlari haqida ma’lumotlarni tezroq , aniqroq topish,saqlash uzatish va qayta ishlash imkoniyatiga ega bo’ldik.
Men bu kurs ishida ma’lumotlar bazasi texnalogiyalar fanidan bir qancha yangi ma’lumotlarga ega bo’ldim.Ma’lumotlar bazasi bilan ishlashni bilib oldim.Bunda asosan SQL(structured Query Language)-bu so’rov tili ko’plab opertorlardan tashkil topgan bo’lib bu orqali ma’lumotlar bazasiga murojaat qilishni o’rgandim.SQL tili boshqa tillarga qaraganda qulay va oddiyligini,unga so’rovlarni to’g’ri kiritsa natija to’g’ri chiqadi.Sql tilini va unda ko’plab operatorlarni bilib oldim.Sqlda MASALAN, INSERT,DROP TABLE,CREATE TABLE,DELETE va boshqa operatorlar ustida ishlashni o’rgandim.Sql tilida jadvallar yaratib jadvalga ma’lumotlar kiritishni va ustida ishlashni mashq qildim.Sql tili barcha ma’lumotlar bazasini boshqarish tizimlari uchun umumiy til hisoblanadi.

Foydalanilgan adabiyotlar:

1.SQL Computer programming for Beginners: The Practical Step by Step Guide, to Master the Fundamentals of SQL Database Programming Made Simple and Stress-Free, that Will Get You Hired

2.“Ma’lumotlar bazasini boshqarish tizimlar” fani bo’yicha elektron o’quv qo’llanma, TATU FF.

3.Ayupov R.X., Ismoilov S.I., Azlarov A.X., “MS Access 2002 - ma’lumotlar majmuasini boshqarish tizimi”(o’quv qo’llanma) Toshkent.: Toshkent Moliya instituti, 2004.

4. Guliamova M.K., & Aliev R.M. (2021). Database Concept, Relevance and Expert Systems. Scientific and Educational Areas Under Modern Challenges, 2021. –PP. 125–127. Чебоксары: SCC “Interaktiv plus”.

5.Куликов С.C. Работа с MySQL, MS SQL Server и Oracle в примерах // практ. пособие. – 2021. – С. 602.

Калинин М.С. Создание и администрирование виртуальной модели базы данных. // статья в сборнике трудов конференции. 2015. – С. 153–156.

6. Мартишин С.А., Симонов В.Л. Проектирование и реализация баз данных в СУБД MySQL с использованием MySQL Workbench. // Учебное пособие. –2012.

7. Guliamova M.K., & Aliev R.M. (2021). Database Concept, Relevance and

8.Expert Systems. Scientific and Educational Areas Under Modern Challenges, 2021.

– PP. 125–127. Чебоксары: SCC “Interaktiv plus”.

9.Tokhirov E., Aliev R. Improving the braking distance of the train before level crossing // InterConf. – 2020.

Internet saytlari

1. 
   www.ictcouncil.gov.uz
   
2. 
   www.ecsoman.edu.ru
   
3. 
   www.Lex.uz
   
4. 
   www.sql.ru
   
5. 
   www.sql-tutorial.ru