Mashinalarga texnik xizmat ko’rsatish bazasini loyihalash va yaratish

Bajarilgan ishlar tarixi

Atribut	Ma`lumot turi	NOT NULL	Tasnifi
k_Id	BIGSERIAL	x	Kalit maydon
kind_service	VARCHAR(6 4)	x	Qilingan ishlar
price_service	FLOAT(20)	x	Xizmat narxi

Xizmat ko`rsatadigan bo`limlar

Atribut	Ma`lumot turi	NOT NULL	Tasnifi
s_id	BIGSERIAL	x	Kalit maydon
section_number	FLOAT(20)	x	Bo`lim raqami
amount_emplyoer	FLOAT(20)	x	Ishchilar soni

Ishchi

Atribut	Ma`lumot turi	NOT NULL	Tasnifi
e_id	BIGSERIAL	x	Kalit maydon
name_emplyoer	VARCHAR2(6 4)	X	Ishchi ismi
fname_emplyoer	VARCHAR2(6 4)	X	Ishchi familiyasi
bday_emplyoer	DATE	X	Ishchi tug’ilgan kuni
service_fee	FLOAT(64)	X	Xizmat haqi

4. Mashinalarga texnik xizmat ko’rsatish bazasini SQL yordamida yaratish va unga ulanish

CREATE DATABASE texnik_xizmat;

\c texnik_xizmat;

Kelgan mijozlar jadvalini yaratish
CREATE TABLE client (
c_id BIGSERIAL NOT NULL PRIMARY KEY,
client_name VARCHAR(64) NOT NULL,
Amount_payment FLOAT(10) NOT NULL);

Kelgan mijozlar jadvaliga ma’lumot kiritish
INSERT INTO client (client_name,
Amount_payment);
VALUES (‘malumot’,malumot);

Bajarilgan ishlar tarixi jadvalini yaratish
CREATE TABLE service_h (
h_id BIGSERIAL NOT NULL PRIMARY KEY,
service_name VARCHAR(64) NOT NULL,
Amount_payment FLOAT(10) NOT NULL);

Bajarilgan ishlar tarixi jadvaliga ma’lumot kiritish
INSERT INTO service_h (service_name,
Amount_payment);
VALUES (‘malumot’,malumot);
Ishchi jadvalini yaratish
CREATE TABLE emplyoer (
e_id BIGSERIAL NOT NULL PRIMARY KEY,
name_emplyoer VARCHAR(64) NOT NULL,
fname_emplyoer VARCHAR(64) NOT NULL,
bday_emplyoer DATE NOT NULL,
service_fee FLOAT(20) NOT NULL
);

Ishchi jadvaliga ma’lumot kiritish
INSERT INTO emplyoer (name_emplyoer, fname_emplyoer,
bday_emplyoer,
service_fee);
VALUES (‘malumot’,’malumot’,malumot, malumot);

Xizmat kursatish bo’limlari jadvalini yaratish
CREATE TABLE section (
s_id BIGSERIAL NOT NULL PRIMARY KEY,
section_number FLOAT(10) NOT NULL,
amount_emplyoer FLOAT(10) NOT NULL);

Xizmat kursatish bo’limlari jadvaliga ma’lumot kiritish
INSERT INTO faculty (service_name,Amount_payment);

Mashinalarga texnik xizmat ko’rsatish bazasi:

Bazadagi jadvallar:


IZOHLAR
Atribut-maydonning nomi.
Ma`lumot turi-maydonning yozuvining ma`lumoti turi.
NOTNULL-maydonni qiymati bo`sh yoki bo`sh bo`lmasligi ko`rsatiladi.
Tasnifi-maydon atributi haqida tasnif beriladi.

Foydalanilgan adabiyotlar:
1.Malumotlar bazasi (Sh.Nazarov, Sh.Ne’matov, R.Qobulov) 2007.
2. Malumotlar bazasini boshqarish sistemasi (A.Sattorov) 2000.

4. Крис Фиайли "SQL" (2013)

5. Энтони Молинаро "SQL. Сборник рецептов" (2009)
Internet manbalari:

1. 
   https://ru.wikipedia.org/
   
2. 
   https://www.w3schools.com/
   
3. 
   http://www.ziyonet.uz/