Верно ли написан код?и помогите написать какой нибудь запрос с помощью create....
Create table faculty (
Faculty_name text,
Faculty_code int,
Faculty_id int,
Primary key (faculty_id));
Create table specialty (
Specialty_name text;
Specialty_code int;
Faculty_code int,
Specialty_id int,
Primary key (Specialty_id));
Create table student (
Student_name text;
Student_surname text;
Student_code int;
Specialty_code int,
Student_id int,
Primary key(student_id));
Create table university (
Faculty_id int,
Specialty_id int,
University_id int,
Primary key(university_id));
Insert into faculty value(“Гуманитарный”,1);
Insert into specialty value(1,“Организация работы с молодежью”,620-1,1);
Insert into student value(“Макаренко”,”Екатерина”,”Сергеевна”,1);
Insert into university value (1,1,1);