|
Amaliy ish bajardi: dbm 005 guruh talabasi Risqulov Abbosxon Tekshirdi: Djurayev Tulkinjon Toshkent 2023
|
| Sana | 31.05.2023 | | Hajmi | 370.93 Kb. | | #68287 |
Bog'liq Mustaqil ta, 1668942904 (3), ИИКТ-Мустакил ишларни тайёрлаш учун қўлланма, ilhonjon===, Oksidlanish-qaytarilish reaksiyalari., water pollution, 1678980581, Jumanboyev Abdurahmon elektronika, 1681713047, ozbekistonning yangi tarixi, Sarvar Abduqodirov CV, 1699377232, 6-amaliy ish, Antenna va radioeshittirish MUSTAQIL ISH Avazbek [Avto saqlangan]
O’ZBEKISTON RESPUBLIKASI AXBOROT TEXNOLOGIYALARI VA KOMMUNIKATSIYALARINI RIVOJLANTIRISH VAZIRLIGI
MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT AXBOROT TEXNOLOGIYALARI UNIVERSITETI
AMALIY ISH
Bajardi: DBM 005 guruh talabasi
Risqulov Abbosxon
Tekshirdi: Djurayev Tulkinjon
Toshkent - 2023
Dasturni o’rnatish
1-qadam: Terminalni oching va quyidagi buyruqni bajaring:
2-qadam: Parolingizni kiriting va yangilanish tugashini kuting. Keyin quyidagi buyruqni bajaring:
3-qadam: Yangilashni davom ettirish so'ralganda Y kiriting va ENTER tugmasini bosing. Paket omborini yangilaganingizdan so'ng, MySQL o'rnatilishiga o'tishingiz mumkin.
4-qadam: MySQL Serverni o'rnatish uchun quyidagi buyruqni bajaring:
5-qadam: Tizim sizdan o'rnatishni davom ettirishingizni so'raganda, Y ga javob bering va ENTER tugmasini bosing. Chiqish shunday bo'lishi kerak:
6-qadam: Shundan so'ng tizim MySQL paketlarini yuklab oladi va ularni siz uchun mo'ljallangan kompyuteringizga o'rnatadi.
7-qadam: Keyinchalik, MySQL muvaffaqiyatli o'rnatilganligini quyidagi buyruqni bajarish orqali tekshirishingiz kerak:
8-qadam: Chiqish kompyuteringizda o'rnatilgan MySQL versiyasini quyidagicha tasvirlaydi:
2.Ma’lumotlar bazasini loyihalash, mohiyat – aloqa diagrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalash.
CREATE TABLE Customers (
CustomerID INT NOT NULL AUTO_INCREMENT,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Address VARCHAR(100) NOT NULL,
PhoneNumber VARCHAR(20) NOT NULL,
PRIMARY KEY (CustomerID)
);
Bu yerda Customers nomli table yaratildi.
CREATE TABLE Cars (
CarID INT NOT NULL AUTO_INCREMENT,
Make VARCHAR(50) NOT NULL,
Model VARCHAR(50) NOT NULL,
Year INT NOT NULL,
Color VARCHAR(20) NOT NULL,
PRIMARY KEY (CarID)
);
Bu yerda Cars nomli table yaratildi.
CREATE TABLE Services (
ServiceID INT NOT NULL AUTO_INCREMENT,
ServiceName VARCHAR(50) NOT NULL,
ServicePrice DECIMAL(10,2) NOT NULL,
PRIMARY KEY (ServiceID)
);
Bu yerda Services nomli table yaratildi.
CREATE TABLE Appointments (
AppointmentID INT NOT NULL AUTO_INCREMENT,
CustomerID INT NOT NULL,
CarID INT NOT NULL,
ServiceID INT NOT NULL,
AppointmentDate DATE NOT NULL,
PRIMARY KEY (AppointmentID),
FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID),
FOREIGN KEY (CarID) REFERENCES Cars(CarID),
FOREIGN KEY (ServiceID) REFERENCES Services(ServiceID)
);
Bu yerda Appointments nomli table yaratildi.
CREATE TABLE Payments (
PaymentID INT NOT NULL AUTO_INCREMENT,
AppointmentID INT NOT NULL,
PaymentType VARCHAR(20) NOT NULL,
PaymentAmount DECIMAL(10,2) NOT NULL,
PRIMARY KEY (PaymentID),
FOREIGN KEY (AppointmentID) REFERENCES Appointments(AppointmentID)
);
Bu yerda Payments nomli table yaratildi.
CREATE TABLE Employees (
EmployeeID INT NOT NULL AUTO_INCREMENT,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Address VARCHAR(100) NOT NULL,
PhoneNumber VARCHAR(20) NOT NULL,
PRIMARY KEY (EmployeeID)
);
Bu yerda Employees nomli table yaratildi.
Bu yerda Customers table ga malumot qo’shildi.
INSERT INTO Customers(FirstName,LastName,Address,PhoneNumber)
VALUES ('John', 'Smith', '123 Main Street', '123-456-7890');
Bu yerda Customers table ga malumot qo’shildi.
INSERT INTO Cars(Make,Model,Year,Color)
VALUES ('Ford', 'Mustang', '2020', 'Red');
Bu yerda Cars table ga malumot qo’shildi.
INSERT INTO Services(ServiceName,ServicePrice)
VALUES ('Oil Change', '50.00');
Bu yerda Services table ga malumot qo’shildi.
INSERT INTO Appointments(AppointmentID,CustomerID,CarID,ServiceID,AppointmentDate)
VALUES ('1', '1', '1', '1', '2020-01-01');
Bu yerda Appointments table ga malumot qo’shildi.
INSERT INTO Payments(PaymentID,AppointmentID,PaymentType,PaymentAmount)
VALUES ('1', '1', 'Credit Card', '50.00');
Bu yerda Paymenttable ga malumot qo’shildi.
INSERT INTO Employees(FirstName,LastName,Address,PhoneNumber)
VALUES ('Jane', 'Doe', '456 Main Street', '456-789-0123');
Bu yerda Employeestable ga malumot qo’shildi.
INSERT INTO Assignments(AssignmentID,EmployeeID,AppointmentID)
VALUES ('1', '1', '1');
Bu yerda Assignments table ga malumot qo’shildi.
Xulosa:
Men bu mavzu orqali jadval yaratish ,o’chirish ,uni update(ya’ni yangilash) qilish , Malumot qo’shish,ochirish va Relyatsion ma’lumotlar bazasini loyihalashni o’rgandim.
|
| |
