Create database oquv markazi 2

310-22 guruh talabasi Bosimov Bekmurodning Ma’lumotlar bazasi fanidan 2-amaliy ishi
O‘quv markazi boshqaruv dasturi uchun taxminiy MB yarating.
1.

CREATE DATABASE oquv_markazi


2.




CREATE TABLE markaz (
id INT PRIMARY KEY AUTO_INCREMENT ,
NAME VARCHAR(50),
fanlar_id INT,
uqituvchilar_id INT,
FOREIGN KEY (fanlar_id) REFERENCES fanlar(id) ON DELETE SET NULL,
FOREIGN KEY (uqituvchilar_id) REFERENCES uqituvchilar(id) ON DELETE SET NULL
);

3.

CREATE TABLE fanlar(
id INT PRIMARY KEY AUTO_INCREMENT,
yunalishlar VARCHAR(50),
status_id INT,
FOREIGN KEY (status_id) REFERENCES status_list(id) ON DELETE SET NULL
);
4.


CREATE TABLE status_list(
id INT PRIMARY key AUTO_INCREMENT ,
tariflar VARCHAR(50)
);

5.

CREATE TABLE uqituvchilar(
id INT PRIMARY KEY AUTO_INCREMENT ,
first_name VARCHAR(50),
last_name VARCHAR(50),
phone_number INT,
toifa VARCHAR(50)
);

6.
DrawSQL dagi natija: