Create table fakultet (id f number(2) primary key,fakultet nomi varchar

1. 
   CREATE TABLE fakultet (id_f NUMBER(2) PRIMARY KEY,fakultet_nomi VARCHAR(50),dekan VARCHAR(50))
   

2. 
   CREATE TABLE yunalish(id_y NUMBER(2) PRIMARY KEY,yunalish_nomi VARCHAR2(50),id_f NUMBER(2),FOREIGN KEY(id_f) REFERENCES fakultet)
   

3.CREATE TABLE guruh(id_gr NUMBER(5) PRIMARY KEY,guruh_nomi VARCHAR(50),kurator VARCHAR(50),kurs VARCHAR(50),id_y NUMBER(2),FOREIGN KEY (id_y) REFERENCES yunalish)