CREATE TABLE [dbo].[Нагрузка](
	[ID] [int] NOT NULL,
	[СотрудникID] [int] NOT NULL,
	[КлассID] [nchar](5) NOT NULL,
	[ПредметID] [int] NOT NULL,
	[Часы] [int] NOT NULL,
 CONSTRAINT [PK_Нагрузка] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO [education].[dbo].[Нагрузка]
           ([ID]
           ,[СотрудникID]
           ,[КлассID]
           ,[ПредметID]
           ,[Часы])
     VALUES
           (1, '1А', 1, 0),
           (2, '2А', 2, 0)
GO

CREATE TABLE [dbo].[Дисциплины](
	[ПредметID] [int] NOT NULL,
	[Название предмета] [nchar](30) NOT NULL,
 CONSTRAINT [PK_Дисциплины_1] PRIMARY KEY CLUSTERED 
(
	[ПредметID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

INSERT INTO [education].[dbo].[Дисциплины]
           ([ПредметID]
           ,[Название предмета])
     VALUES
           (1, Хор),
           (2, МХК)
GO