ЯсноПонятно24

CREATE DATABASE Academy;

CREATE TABLE Teachers ( teacher_id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), salary DECIMAL(10, 2), hire_date DATE );

CREATE TABLE Groups ( group_id INT PRIMARY KEY, group_name VARCHAR(50), faculty_id INT, department_id INT, FOREIGN KEY (faculty_id) REFERENCES Faculties(faculty_id), FOREIGN KEY (department_id) REFERENCES Departments(department_id) );

CREATE TABLE Faculties ( faculty_id INT PRIMARY KEY, faculty_name VARCHAR(50) );

CREATE TABLE Departments ( department_id INT PRIMARY KEY, department_name VARCHAR(50) );

INSERT INTO Faculties (faculty_id, faculty_name) VALUES (1, 'Faculty of Science'); INSERT INTO Faculties (faculty_id, faculty_name) VALUES (2, 'Faculty of Arts');

INSERT INTO Departments (department_id, department_name) VALUES (1, 'Mathematics'); INSERT INTO Departments (department_id, department_name) VALUES (2, 'History');

-- Добавьте дополнительные данные о преподавателях, группах и т.д. по необходимости

-- Пример добавления данных о преподавателе INSERT INTO Teachers (teacher_id, first_name, last_name, salary, hire_date) VALUES (1, 'John', 'Doe', 50000.00, '2020-01-01');

-- Пример добавления данных о группе INSERT INTO Groups (group_id, group_name, faculty_id, department_id) VALUES (1, 'Group A', 1, 1);

-- Пример запроса данных о преподавателях и их группах SELECT Teachers.first_name, Teachers.last_name, Groups.group_name FROM Teachers JOIN Groups ON Teachers.teacher_id = Groups.group_id;