3 мustaqil ta’lim ish hisoboti Fan “Ma’lumotlar bazasi”

Amaliyot ishida tanlangan variyant asosida, tayyor tizim loyihasini ishlab chiqish va loyihani yakunlash.
Vazifalar: Quyidagi ma’lumotlar bazalarini relyatsion ko’rinishi hamda mysql ma’lumotlar bazasi orqali code ko’rinishida yaratish.

6- rasm Java Script da bog’lash

7- rasm Java Scriptda Kodlar ketma-ketligi

8- rasm SQL bilan bog’lash
CREATE DATABASE Clinc;
CREATE TABLE Role(
id int not null AUTO_INCREMENT,
role_name varchar(55),
PRIMARY KEY(id)
);
CREATE TABLE employees(
id int not null AUTO_INCREMENT,
role_id int,
name varchar(45),
surname varchar(50),
middle_name varchar(45),
phone_number varchar(18),
address varchar(80),
img varchar(45),
FOREIGN KEY(role_id) REFERENCES role(id),
PRIMARY KEY(id)
);

CREATE TABLE Department(

id int not null AUTO_INCREMENT,
employees_id int,
department_name varchar(45),
FOREIGN KEY(employees_id) REFERENCES employees(id),
PRIMARY KEY(id)
);

13. 
    rasm.Malumotlar bazasi ustida amallar
    

CREATE TABLE duty_schedule(
id int not null AUTO_INCREMENT,
employees_id int,
day date,
time_start time,
time_end time,
FOREIGN KEY(employees_id) REFERENCES employees(id),
PRIMARY KEY(id)
);

13. 
    rasm.Malumotlar bazasi ustida amallar
    

CREATE TABLE Patent(
id int NOT null AUTO_INCREMENT,
name varchar(45),
surname varchar(45),
phone_number varchar(18),
medical_history varchar(200),
img varchar(45),
registration_time datetime,
PRIMARY KEY(id)
);

13. 
    rasm.Malumotlar bazasi ustida amallar
    

CREATE TABLE Patient_history(
id int not null AUTO_INCREMENT,
patent_id int,
FOREIGN KEY(patent_id) REFERENCES patent(id),
PRIMARY KEY(id)
);

•