dsadasdas

CREATE TABLE CourseGroup(
	[course] [varchar](10) NULL,
	[course_group] [smallint] NULL,
	[course_type] [varchar](1) NULL
);

CREATE TABLE Grades(
	[semester] [tinyint] NULL,
	[year] [smallint] NULL,
	[semester_type] [varchar](1) NULL,
	[academic_year] [tinyint] NULL,
	[course] [varchar](10) NULL,
	[teacher_id] [bigint] NULL,
	[grade] [real] NULL,
	[exam] [varchar](1) NULL,
	[student_id] [bigint] NULL
);

CREATE TABLE Students(
	[spec] [varchar](3) NULL,
	[sub_spec] [varchar](3) NULL,
	[sub_spec2] [varchar](3) NULL,
	[gender] [varchar](1) NULL,
	[student_id] [bigint] NULL
);

CREATE TABLE Teachers(
	[teacher_id] [bigint] NULL,
	[gender] [varchar](1) NULL,
	[faculty] [smallint] NULL,
	[institute] [varchar](5) NULL,
	[title_id] [smallint] NULL
);

CREATE TABLE TeacherTitle(
	[title_id] [smallint] NULL,
	[title] [varchar](10) NULL,
	[title_long] [varchar](30) NULL
);