· 5 years ago · May 17, 2020, 05:04 PM
1USE [master]
2GO
3/****** Object: Database [Shakhovtsev] Script Date: 24.04.2020 20:53:04 ******/
4CREATE DATABASE [Shakhovtsev]
5 CONTAINMENT = NONE
6 ON PRIMARY
7( NAME = N'Shakhovtsev', FILENAME = N'C:\SQL\Shakhovtsev.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
8 LOG ON
9( NAME = N'Shakhovtsev_log', FILENAME = N'C:\SQL\Shakhovtsev_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
10 WITH CATALOG_COLLATION = DATABASE_DEFAULT
11GO
12ALTER DATABASE [Shakhovtsev] SET COMPATIBILITY_LEVEL = 140
13GO
14IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
15begin
16EXEC [Shakhovtsev].[dbo].[sp_fulltext_database] @action = 'enable'
17end
18GO
19ALTER DATABASE [Shakhovtsev] SET ANSI_NULL_DEFAULT OFF
20GO
21ALTER DATABASE [Shakhovtsev] SET ANSI_NULLS OFF
22GO
23ALTER DATABASE [Shakhovtsev] SET ANSI_PADDING OFF
24GO
25ALTER DATABASE [Shakhovtsev] SET ANSI_WARNINGS OFF
26GO
27ALTER DATABASE [Shakhovtsev] SET ARITHABORT OFF
28GO
29ALTER DATABASE [Shakhovtsev] SET AUTO_CLOSE OFF
30GO
31ALTER DATABASE [Shakhovtsev] SET AUTO_SHRINK OFF
32GO
33ALTER DATABASE [Shakhovtsev] SET AUTO_UPDATE_STATISTICS ON
34GO
35ALTER DATABASE [Shakhovtsev] SET CURSOR_CLOSE_ON_COMMIT OFF
36GO
37ALTER DATABASE [Shakhovtsev] SET CURSOR_DEFAULT GLOBAL
38GO
39ALTER DATABASE [Shakhovtsev] SET CONCAT_NULL_YIELDS_NULL OFF
40GO
41ALTER DATABASE [Shakhovtsev] SET NUMERIC_ROUNDABORT OFF
42GO
43ALTER DATABASE [Shakhovtsev] SET QUOTED_IDENTIFIER OFF
44GO
45ALTER DATABASE [Shakhovtsev] SET RECURSIVE_TRIGGERS OFF
46GO
47ALTER DATABASE [Shakhovtsev] SET DISABLE_BROKER
48GO
49ALTER DATABASE [Shakhovtsev] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
50GO
51ALTER DATABASE [Shakhovtsev] SET DATE_CORRELATION_OPTIMIZATION OFF
52GO
53ALTER DATABASE [Shakhovtsev] SET TRUSTWORTHY OFF
54GO
55ALTER DATABASE [Shakhovtsev] SET ALLOW_SNAPSHOT_ISOLATION OFF
56GO
57ALTER DATABASE [Shakhovtsev] SET PARAMETERIZATION SIMPLE
58GO
59ALTER DATABASE [Shakhovtsev] SET READ_COMMITTED_SNAPSHOT OFF
60GO
61ALTER DATABASE [Shakhovtsev] SET HONOR_BROKER_PRIORITY OFF
62GO
63ALTER DATABASE [Shakhovtsev] SET RECOVERY SIMPLE
64GO
65ALTER DATABASE [Shakhovtsev] SET MULTI_USER
66GO
67ALTER DATABASE [Shakhovtsev] SET PAGE_VERIFY CHECKSUM
68GO
69ALTER DATABASE [Shakhovtsev] SET DB_CHAINING OFF
70GO
71ALTER DATABASE [Shakhovtsev] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
72GO
73ALTER DATABASE [Shakhovtsev] SET TARGET_RECOVERY_TIME = 60 SECONDS
74GO
75ALTER DATABASE [Shakhovtsev] SET DELAYED_DURABILITY = DISABLED
76GO
77EXEC sys.sp_db_vardecimal_storage_format N'Shakhovtsev', N'ON'
78GO
79ALTER DATABASE [Shakhovtsev] SET QUERY_STORE = OFF
80GO
81USE [Shakhovtsev]
82GO
83/****** Object: UserDefinedFunction [dbo].[Avg_mark_student] Script Date: 24.04.2020 20:53:04 ******/
84SET ANSI_NULLS ON
85GO
86SET QUOTED_IDENTIFIER ON
87GO
88CREATE FUNCTION [dbo].[Avg_mark_student] (@id_stud INT)
89
90RETURNS REAL
91AS
92BEGIN
93 DECLARE @avg_mark REAL
94 SELECT @avg_mark = AVG(CAST(Mark AS REAL)) FROM Exam WHERE Id_Student = @id_stud
95 RETURN @avg_mark
96END
97GO
98/****** Object: UserDefinedFunction [dbo].[Fun2] Script Date: 24.04.2020 20:53:04 ******/
99SET ANSI_NULLS ON
100GO
101SET QUOTED_IDENTIFIER ON
102GO
103CREATE FUNCTION [dbo].[Fun2] (@group VARCHAR(20))
104RETURNS @res TABLE (FioStud VARCHAR(25), Avg_Mark REAL)
105AS
106BEGIN
107 INSERT INTO @res SELECT Fio, AVG(CAST(Mark AS REAL))
108 FROM Exam JOIN Student ON Exam.Id_Student = Student.Id_Student
109 WHERE NameGroup = @group GROUP BY Fio
110 RETURN
111END
112GO
113/****** Object: UserDefinedFunction [dbo].[func2_3_v2] Script Date: 24.04.2020 20:53:04 ******/
114SET ANSI_NULLS ON
115GO
116SET QUOTED_IDENTIFIER ON
117GO
118CREATE FUNCTION [dbo].[func2_3_v2] (@group VARCHAR(50))
119RETURNS @tab TABLE (ExamName VARCHAR(50))
120AS
121BEGIN
122 DECLARE @count INT
123 INSERT INTO @tab SELECT Subject FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group) GROUP BY Subject
124 RETURN
125END
126GO
127/****** Object: UserDefinedFunction [dbo].[func2_4] Script Date: 24.04.2020 20:53:04 ******/
128SET ANSI_NULLS ON
129GO
130SET QUOTED_IDENTIFIER ON
131GO
132CREATE FUNCTION [dbo].[func2_4] (@group VARCHAR(50))
133RETURNS @tab TABLE (count SMALLINT)
134AS
135BEGIN
136 INSERT INTO @tab SELECT COUNT(*) FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group) GROUP BY Subject
137 RETURN
138END
139GO
140/****** Object: UserDefinedFunction [dbo].[func3] Script Date: 24.04.2020 20:53:04 ******/
141SET ANSI_NULLS ON
142GO
143SET QUOTED_IDENTIFIER ON
144GO
145CREATE FUNCTION [dbo].[func3] (@group VARCHAR(20))
146RETURNS @tab TABLE (ExamName VARCHAR(50))
147AS
148BEGIN
149 INSERT INTO @tab SELECT DISTINCT Subject FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group)
150 RETURN
151END
152GO
153/****** Object: UserDefinedFunction [dbo].[func4_v2] Script Date: 24.04.2020 20:53:04 ******/
154SET ANSI_NULLS ON
155GO
156SET QUOTED_IDENTIFIER ON
157GO
158CREATE FUNCTION [dbo].[func4_v2] (@group VARCHAR(50))
159RETURNS @tab TABLE (count SMALLINT)
160AS
161BEGIN
162 INSERT INTO @tab SELECT COUNT (*) FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group) GROUP BY Subject
163 RETURN
164END
165GO
166/****** Object: UserDefinedFunction [dbo].[funkyfunc3] Script Date: 24.04.2020 20:53:04 ******/
167SET ANSI_NULLS ON
168GO
169SET QUOTED_IDENTIFIER ON
170GO
171CREATE FUNCTION [dbo].[funkyfunc3] (@group VARCHAR(50))
172RETURNS @tab TABLE (ExamName VARCHAR(50))
173AS
174BEGIN
175 INSERT INTO @tab SELECT DISTINCT Subject FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group)
176 RETURN
177END
178GO
179/****** Object: UserDefinedFunction [dbo].[funkyfunc4] Script Date: 24.04.2020 20:53:04 ******/
180SET ANSI_NULLS ON
181GO
182SET QUOTED_IDENTIFIER ON
183GO
184CREATE FUNCTION [dbo].[funkyfunc4] (@group VARCHAR(50))
185RETURNS @tab TABLE (count SMALLINT)
186AS
187BEGIN
188 INSERT INTO @tab SELECT COUNT(DISTINCT Subject) FROM Exam WHERE Id_Student IN (SELECT Id_Student FROM Student WHERE NameGroup = @group)
189 RETURN
190END
191GO
192/****** Object: UserDefinedFunction [dbo].[laba2_primer3] Script Date: 24.04.2020 20:53:04 ******/
193SET ANSI_NULLS ON
194GO
195SET QUOTED_IDENTIFIER ON
196GO
197CREATE FUNCTION [dbo].[laba2_primer3] (@group VARCHAR(20))
198RETURNS @res TABLE (FioStud VARCHAR(25), Avg_Mark REAL)
199AS
200BEGIN
201 INSERT INTO @res SELECT Fio, AVG(CAST(Mark AS REAL))
202 FROM Exam JOIN Student ON Exam.Id_Student = Student.Id_Student
203 WHERE NameGroup = @group GROUP BY Fio
204 RETURN
205END
206GO
207/****** Object: UserDefinedFunction [dbo].[laba2_zadanie33] Script Date: 24.04.2020 20:53:04 ******/
208SET ANSI_NULLS ON
209GO
210SET QUOTED_IDENTIFIER ON
211GO
212CREATE FUNCTION [dbo].[laba2_zadanie33] (@predmet VARCHAR(50), @gruppa VARCHAR(50))
213RETURNS @tab TABLE (fio VARCHAR(50))
214AS
215BEGIN
216 INSERT INTO @tab SELECT FIO From Lecturer WHERE Id_Lect IN (SELECT Id_Lect FROM Exam WHERE Subject = @predmet AND Id_Student IN (SELECT Id_Student FROM StudGroup WHERE NameGroup = @gruppa))
217 RETURN
218END
219GO
220/****** Object: UserDefinedFunction [dbo].[proc2_4_v2] Script Date: 24.04.2020 20:53:04 ******/
221SET ANSI_NULLS ON
222GO
223SET QUOTED_IDENTIFIER ON
224GO
225CREATE FUNCTION [dbo].[proc2_4_v2](@group VARCHAR(50))
226RETURNS INT
227AS
228BEGIN
229 DECLARE @count INT
230 SET @count = (SELECT COUNT(*) FROM func2_3_v2(@group))
231 RETURN @count
232END
233GO
234/****** Object: Table [dbo].[Student] Script Date: 24.04.2020 20:53:04 ******/
235SET ANSI_NULLS ON
236GO
237SET QUOTED_IDENTIFIER ON
238GO
239CREATE TABLE [dbo].[Student](
240 [Id_Student] [smallint] NOT NULL,
241 [FIO] [varchar](50) NOT NULL,
242 [Birthday] [date] NOT NULL,
243 [Gender] [char](1) NULL,
244 [NameGroup] [varchar](10) NOT NULL,
245 [Stip] [int] NULL,
246 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
247(
248 [Id_Student] ASC
249)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
250) ON [PRIMARY]
251GO
252/****** Object: View [dbo].[ListOfGroup] Script Date: 24.04.2020 20:53:04 ******/
253SET ANSI_NULLS ON
254GO
255SET QUOTED_IDENTIFIER ON
256GO
257CREATE VIEW [dbo].[ListOfGroup]
258AS
259SELECT TOP (100) PERCENT NameGroup AS Группа, Id_Student AS [Шифр студента], FIO AS [Фамилия студента]
260FROM dbo.Student
261ORDER BY Группа, [Фамилия студента]
262GO
263/****** Object: Table [dbo].[Exam] Script Date: 24.04.2020 20:53:04 ******/
264SET ANSI_NULLS ON
265GO
266SET QUOTED_IDENTIFIER ON
267GO
268CREATE TABLE [dbo].[Exam](
269 [Id_Student] [smallint] NOT NULL,
270 [Subject] [varchar](50) NOT NULL,
271 [Mark] [smallint] NOT NULL,
272 [Exam_Date] [date] NOT NULL,
273 [Id_Lect] [smallint] NOT NULL,
274 CONSTRAINT [PK_Exam] PRIMARY KEY CLUSTERED
275(
276 [Id_Student] ASC,
277 [Subject] ASC
278)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
279) ON [PRIMARY]
280GO
281/****** Object: View [dbo].[Exam_A-12-01] Script Date: 24.04.2020 20:53:04 ******/
282SET ANSI_NULLS ON
283GO
284SET QUOTED_IDENTIFIER ON
285GO
286CREATE VIEW [dbo].[Exam_A-12-01]
287AS
288SELECT TOP (100) PERCENT dbo.ListOfGroup.[Фамилия студента], COUNT(*) AS [Сдано на 5], MAX(dbo.Exam.Mark) AS [Лучшая оценка]
289FROM dbo.ListOfGroup INNER JOIN
290 dbo.Exam ON dbo.ListOfGroup.[Шифр студента] = dbo.Exam.Id_Student
291WHERE (dbo.ListOfGroup.Группа = 'А-12-01') AND (dbo.Exam.Mark > 44)
292GROUP BY dbo.ListOfGroup.[Фамилия студента], dbo.Exam.Mark
293ORDER BY dbo.Exam.Mark
294GO
295/****** Object: Table [dbo].[Lecturer] Script Date: 24.04.2020 20:53:04 ******/
296SET ANSI_NULLS ON
297GO
298SET QUOTED_IDENTIFIER ON
299GO
300CREATE TABLE [dbo].[Lecturer](
301 [Id_Lect] [smallint] NOT NULL,
302 [FIO] [varchar](50) NOT NULL,
303 [Stage] [smallint] NULL,
304 [Kafedra] [varchar](50) NOT NULL,
305 CONSTRAINT [PK_Lecturer] PRIMARY KEY CLUSTERED
306(
307 [Id_Lect] ASC
308)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
309) ON [PRIMARY]
310GO
311/****** Object: View [dbo].[LectExam] Script Date: 24.04.2020 20:53:04 ******/
312SET ANSI_NULLS ON
313GO
314SET QUOTED_IDENTIFIER ON
315GO
316CREATE VIEW [dbo].[LectExam]
317AS
318SELECT Id_Lect AS Код, FIO AS Фамилия, Stage AS Стаж
319FROM dbo.Lecturer
320WHERE (Kafedra = 'ИС') AND (Id_Lect IN
321 (SELECT DISTINCT Id_Lect
322 FROM dbo.Exam))
323GO
324/****** Object: View [dbo].[3_1A] Script Date: 24.04.2020 20:53:04 ******/
325SET ANSI_NULLS ON
326GO
327SET QUOTED_IDENTIFIER ON
328GO
329CREATE VIEW [dbo].[3_1A]
330AS
331SELECT NameGroup AS [Номер группы], MAX(Stip) AS [Максимальная стипендия]
332FROM dbo.Student
333GROUP BY NameGroup
334GO
335/****** Object: View [dbo].[3_1Б] Script Date: 24.04.2020 20:53:04 ******/
336SET ANSI_NULLS ON
337GO
338SET QUOTED_IDENTIFIER ON
339GO
340CREATE VIEW [dbo].[3_1Б]
341AS
342SELECT TOP (100) PERCENT dbo.[3_1A].[Номер группы], dbo.Student.FIO AS ФИО
343FROM dbo.[3_1A] INNER JOIN
344 dbo.Student ON dbo.[3_1A].[Номер группы] = dbo.Student.NameGroup AND dbo.[3_1A].[Максимальная стипендия] = dbo.Student.Stip
345ORDER BY dbo.[3_1A].[Номер группы]
346GO
347/****** Object: View [dbo].[3_2А] Script Date: 24.04.2020 20:53:04 ******/
348SET ANSI_NULLS ON
349GO
350SET QUOTED_IDENTIFIER ON
351GO
352CREATE VIEW [dbo].[3_2А]
353AS
354SELECT dbo.Lecturer.FIO AS [ФИО преподавателя], dbo.Exam.Subject AS Предмет, dbo.Student.NameGroup AS [Номер группы]
355FROM dbo.Lecturer INNER JOIN
356 dbo.Exam ON dbo.Lecturer.Id_Lect = dbo.Exam.Id_Lect INNER JOIN
357 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student
358GROUP BY dbo.Lecturer.FIO, dbo.Exam.Subject, dbo.Student.NameGroup
359GO
360/****** Object: View [dbo].[3_2Б] Script Date: 24.04.2020 20:53:04 ******/
361SET ANSI_NULLS ON
362GO
363SET QUOTED_IDENTIFIER ON
364GO
365CREATE VIEW [dbo].[3_2Б]
366AS
367SELECT dbo.[3_2А].[ФИО преподавателя], COUNT(dbo.[3_2А].[Номер группы]) AS [Количество экзаменов]
368FROM dbo.[3_2А] INNER JOIN
369 dbo.Lecturer ON dbo.[3_2А].[ФИО преподавателя] = dbo.Lecturer.FIO
370WHERE (dbo.Lecturer.Kafedra = 'ИС')
371GROUP BY dbo.[3_2А].[ФИО преподавателя]
372GO
373/****** Object: Table [dbo].[StudGroup] Script Date: 24.04.2020 20:53:04 ******/
374SET ANSI_NULLS ON
375GO
376SET QUOTED_IDENTIFIER ON
377GO
378CREATE TABLE [dbo].[StudGroup](
379 [NameGroup] [varchar](10) NOT NULL,
380 [Kurs] [smallint] NULL,
381 [Kafedra] [varchar](10) NULL,
382 CONSTRAINT [PK_StudGroup] PRIMARY KEY CLUSTERED
383(
384 [NameGroup] ASC
385)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
386) ON [PRIMARY]
387GO
388/****** Object: View [dbo].[3_3А] Script Date: 24.04.2020 20:53:04 ******/
389SET ANSI_NULLS ON
390GO
391SET QUOTED_IDENTIFIER ON
392GO
393CREATE VIEW [dbo].[3_3А]
394AS
395SELECT dbo.Student.NameGroup AS Группа, dbo.Student.FIO AS ФИО
396FROM dbo.Student INNER JOIN
397 dbo.StudGroup ON dbo.Student.NameGroup = dbo.StudGroup.NameGroup
398WHERE (dbo.StudGroup.Kurs = 2)
399GROUP BY dbo.Student.NameGroup, dbo.Student.FIO
400GO
401/****** Object: View [dbo].[3_3Б] Script Date: 24.04.2020 20:53:04 ******/
402SET ANSI_NULLS ON
403GO
404SET QUOTED_IDENTIFIER ON
405GO
406CREATE VIEW [dbo].[3_3Б]
407AS
408SELECT Exam_Date AS Дата, Subject AS Предмет, COUNT(Id_Student) AS [Количество студентов], AVG(Mark) AS [Средний балл]
409FROM dbo.Exam
410GROUP BY Exam_Date, Subject
411GO
412/****** Object: View [dbo].[3_4А] Script Date: 24.04.2020 20:53:04 ******/
413SET ANSI_NULLS ON
414GO
415SET QUOTED_IDENTIFIER ON
416GO
417CREATE VIEW [dbo].[3_4А]
418AS
419SELECT FIO AS ФИО, Stage AS Стаж
420FROM dbo.Lecturer
421WHERE (Stage > 10)
422GO
423/****** Object: View [dbo].[3_4Б] Script Date: 24.04.2020 20:53:04 ******/
424SET ANSI_NULLS ON
425GO
426SET QUOTED_IDENTIFIER ON
427GO
428CREATE VIEW [dbo].[3_4Б]
429AS
430SELECT dbo.[3_4А].ФИО, dbo.Exam.Subject AS Предмет, dbo.Exam.Exam_Date AS [Дата экзамена]
431FROM dbo.Lecturer INNER JOIN
432 dbo.Exam ON dbo.Lecturer.Id_Lect = dbo.Exam.Id_Lect INNER JOIN
433 dbo.[3_4А] ON dbo.Lecturer.FIO = dbo.[3_4А].ФИО
434GROUP BY dbo.Exam.Subject, dbo.Exam.Exam_Date, dbo.[3_4А].ФИО, dbo.[3_4А].Стаж
435GO
436/****** Object: View [dbo].[3_5А] Script Date: 24.04.2020 20:53:04 ******/
437SET ANSI_NULLS ON
438GO
439SET QUOTED_IDENTIFIER ON
440GO
441CREATE VIEW [dbo].[3_5А]
442AS
443SELECT dbo.StudGroup.NameGroup AS Группа, dbo.Exam.Subject AS Экзамен
444FROM dbo.Exam INNER JOIN
445 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student INNER JOIN
446 dbo.StudGroup ON dbo.Student.NameGroup = dbo.StudGroup.NameGroup
447WHERE (dbo.StudGroup.Kurs = 2)
448GROUP BY dbo.StudGroup.NameGroup, dbo.Exam.Subject
449GO
450/****** Object: View [dbo].[3_6А] Script Date: 24.04.2020 20:53:04 ******/
451SET ANSI_NULLS ON
452GO
453SET QUOTED_IDENTIFIER ON
454GO
455CREATE VIEW [dbo].[3_6А]
456AS
457SELECT dbo.Student.FIO AS ФИО, dbo.Student.NameGroup AS Группа, dbo.Exam.Mark AS Оценка
458FROM dbo.Exam INNER JOIN
459 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student
460WHERE (dbo.Exam.Subject = 'Сети')
461GROUP BY dbo.Student.FIO, dbo.Student.NameGroup, dbo.Exam.Mark
462GO
463/****** Object: View [dbo].[3_6Б] Script Date: 24.04.2020 20:53:04 ******/
464SET ANSI_NULLS ON
465GO
466SET QUOTED_IDENTIFIER ON
467GO
468CREATE VIEW [dbo].[3_6Б]
469AS
470SELECT TOP (100) PERCENT Группа AS Expr1, COUNT(Оценка) AS Expr2
471FROM dbo.[3_6А]
472WHERE (Оценка > 44)
473GROUP BY Группа, Оценка
474ORDER BY Expr1
475GO
476/****** Object: View [dbo].[3_7А] Script Date: 24.04.2020 20:53:04 ******/
477SET ANSI_NULLS ON
478GO
479SET QUOTED_IDENTIFIER ON
480GO
481CREATE VIEW [dbo].[3_7А]
482AS
483SELECT dbo.Student.FIO AS ФИО, dbo.Exam.Subject AS Предмет, dbo.Exam.Mark AS Оценка, dbo.Exam.Exam_Date AS [Дата экзамена]
484FROM dbo.Exam INNER JOIN
485 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student
486WHERE (dbo.Exam.Exam_Date BETWEEN CONVERT(DATETIME, '2019-01-01 00:00:00', 102) AND CONVERT(DATETIME, '2019-06-02 00:00:00', 102)) AND (dbo.Student.NameGroup = 'А-12-01')
487GROUP BY dbo.Student.FIO, dbo.Exam.Subject, dbo.Exam.Mark, dbo.Exam.Exam_Date, dbo.Student.NameGroup
488GO
489/****** Object: View [dbo].[3_7Б] Script Date: 24.04.2020 20:53:04 ******/
490SET ANSI_NULLS ON
491GO
492SET QUOTED_IDENTIFIER ON
493GO
494CREATE VIEW [dbo].[3_7Б]
495AS
496SELECT ФИО, COUNT([Дата экзамена]) AS Expr1
497FROM dbo.[3_7А]
498GROUP BY ФИО
499GO
500/****** Object: View [dbo].[3_8А] Script Date: 24.04.2020 20:53:04 ******/
501SET ANSI_NULLS ON
502GO
503SET QUOTED_IDENTIFIER ON
504GO
505CREATE VIEW [dbo].[3_8А]
506AS
507SELECT dbo.Exam.Subject AS Предмет, dbo.Student.NameGroup AS Группа, COUNT(dbo.Exam.Id_Student) AS [Количество сдавших экзамен]
508FROM dbo.Exam INNER JOIN
509 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student
510GROUP BY dbo.Exam.Subject, dbo.Student.NameGroup
511GO
512/****** Object: View [dbo].[3_8Б] Script Date: 24.04.2020 20:53:04 ******/
513SET ANSI_NULLS ON
514GO
515SET QUOTED_IDENTIFIER ON
516GO
517CREATE VIEW [dbo].[3_8Б]
518AS
519SELECT NameGroup AS Группа, COUNT(Id_Student) AS [Количество студентов]
520FROM dbo.Student
521GROUP BY NameGroup
522GO
523/****** Object: View [dbo].[3_8В] Script Date: 24.04.2020 20:53:04 ******/
524SET ANSI_NULLS ON
525GO
526SET QUOTED_IDENTIFIER ON
527GO
528CREATE VIEW [dbo].[3_8В]
529AS
530SELECT dbo.[3_8Б].Группа, dbo.[3_8А].Предмет, dbo.[3_8Б].[Количество студентов] - dbo.[3_8А].[Количество сдавших экзамен] AS [Количество не сдавших]
531FROM dbo.[3_8А] INNER JOIN
532 dbo.[3_8Б] ON dbo.[3_8А].Группа = dbo.[3_8Б].Группа
533GO
534/****** Object: View [dbo].[3_9А] Script Date: 24.04.2020 20:53:04 ******/
535SET ANSI_NULLS ON
536GO
537SET QUOTED_IDENTIFIER ON
538GO
539CREATE VIEW [dbo].[3_9А]
540AS
541SELECT dbo.Student.FIO AS ФИО, dbo.StudGroup.Kurs AS Курс
542FROM dbo.Student INNER JOIN
543 dbo.StudGroup ON dbo.Student.NameGroup = dbo.StudGroup.NameGroup
544WHERE (dbo.Student.Stip IS NULL) AND (dbo.StudGroup.Kurs = 3)
545GROUP BY dbo.Student.FIO, dbo.StudGroup.Kurs
546GO
547/****** Object: View [dbo].[3_9Б] Script Date: 24.04.2020 20:53:04 ******/
548SET ANSI_NULLS ON
549GO
550SET QUOTED_IDENTIFIER ON
551GO
552CREATE VIEW [dbo].[3_9Б]
553AS
554SELECT TOP (100) PERCENT dbo.[3_9А].ФИО, COUNT(dbo.Exam.Id_Student) AS [Сдано экзаменов], AVG(dbo.Exam.Mark) AS [Средний балл]
555FROM dbo.Exam INNER JOIN
556 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student INNER JOIN
557 dbo.[3_9А] ON dbo.Student.FIO = dbo.[3_9А].ФИО
558GROUP BY dbo.[3_9А].ФИО
559GO
560/****** Object: View [dbo].[3_10А] Script Date: 24.04.2020 20:53:04 ******/
561SET ANSI_NULLS ON
562GO
563SET QUOTED_IDENTIFIER ON
564GO
565CREATE VIEW [dbo].[3_10А]
566AS
567SELECT TOP (100) PERCENT dbo.Student.NameGroup AS Группа, COUNT(dbo.Student.FIO) AS [Получающих стипендию]
568FROM dbo.Student INNER JOIN
569 dbo.StudGroup ON dbo.Student.NameGroup = dbo.StudGroup.NameGroup
570WHERE (dbo.StudGroup.Kurs = 3) AND (NOT (dbo.Student.Stip IS NULL))
571GROUP BY dbo.Student.NameGroup
572ORDER BY Группа
573GO
574/****** Object: View [dbo].[3_11А] Script Date: 24.04.2020 20:53:04 ******/
575SET ANSI_NULLS ON
576GO
577SET QUOTED_IDENTIFIER ON
578GO
579CREATE VIEW [dbo].[3_11А]
580AS
581SELECT dbo.StudGroup.NameGroup AS Группа, dbo.Student.FIO AS ФИО, AVG(dbo.Exam.Mark) AS [Средний балл]
582FROM dbo.Student INNER JOIN
583 dbo.StudGroup ON dbo.Student.NameGroup = dbo.StudGroup.NameGroup INNER JOIN
584 dbo.Exam ON dbo.Student.Id_Student = dbo.Exam.Id_Student
585WHERE (dbo.StudGroup.Kafedra = 'ПМ')
586GROUP BY dbo.Student.FIO, dbo.StudGroup.NameGroup
587GO
588/****** Object: View [dbo].[3_11Б] Script Date: 24.04.2020 20:53:04 ******/
589SET ANSI_NULLS ON
590GO
591SET QUOTED_IDENTIFIER ON
592GO
593CREATE VIEW [dbo].[3_11Б]
594AS
595SELECT Группа, COUNT(ФИО) AS [Количество студентов со средним баллом < 45]
596FROM dbo.[3_11А]
597GROUP BY Группа
598HAVING (AVG([Средний балл]) < 45)
599GO
600/****** Object: View [dbo].[3_12А] Script Date: 24.04.2020 20:53:04 ******/
601SET ANSI_NULLS ON
602GO
603SET QUOTED_IDENTIFIER ON
604GO
605CREATE VIEW [dbo].[3_12А]
606AS
607SELECT dbo.Student.NameGroup AS Группа, dbo.Exam.Subject AS Предмет, AVG(dbo.Exam.Mark) AS [Средний балл]
608FROM dbo.Exam INNER JOIN
609 dbo.Student ON dbo.Exam.Id_Student = dbo.Student.Id_Student
610WHERE (dbo.Student.NameGroup = 'А-12-01')
611GROUP BY dbo.Student.NameGroup, dbo.Exam.Subject
612GO
613/****** Object: View [dbo].[3_12Б] Script Date: 24.04.2020 20:53:04 ******/
614SET ANSI_NULLS ON
615GO
616SET QUOTED_IDENTIFIER ON
617GO
618CREATE VIEW [dbo].[3_12Б]
619AS
620SELECT Предмет, MIN([Средний балл]) AS [Мин балл]
621FROM dbo.[3_12А]
622GROUP BY Предмет
623GO
624/****** Object: UserDefinedFunction [dbo].[Fun1] Script Date: 24.04.2020 20:53:04 ******/
625SET ANSI_NULLS ON
626GO
627SET QUOTED_IDENTIFIER ON
628GO
629CREATE FUNCTION [dbo].[Fun1] (@group VARCHAR(20))
630RETURNS TABLE
631AS
632RETURN SELECT Fio, AVG(CAST(Mark AS REAL)) AS [Средний балл]
633FROM Exam JOIN Student ON Exam.Id_Student = Student.Id_Student
634WHERE NameGroup = @group GROUP BY Fio
635GO
636/****** Object: UserDefinedFunction [dbo].[laba2_primer2] Script Date: 24.04.2020 20:53:04 ******/
637SET ANSI_NULLS ON
638GO
639SET QUOTED_IDENTIFIER ON
640GO
641CREATE FUNCTION [dbo].[laba2_primer2] (@group VARCHAR(20))
642RETURNS TABLE
643AS
644RETURN SELECT Fio, AVG(CAST(Mark AS REAL)) AS [Cредний балл]
645 FROM Exam JOIN Student ON Exam.Id_Student = Student.Id_Student
646 WHERE NameGroup = @group GROUP BY Fio
647GO
648/****** Object: StoredProcedure [dbo].[NewExam] Script Date: 24.04.2020 20:53:04 ******/
649SET ANSI_NULLS ON
650GO
651SET QUOTED_IDENTIFIER ON
652GO
653
654CREATE PROCEDURE [dbo].[NewExam]
655 -- Add the parameters for the stored procedure here
656 @id_stud INT, @subject VARCHAR(20), @mark INT, @ex_date DATE, @id_lect INT, @count_exam INT OUTPUT
657AS
658BEGIN
659 INSERT INTO Exam VALUES (@id_stud, @subject, @mark, @ex_date, @id_lect)
660 SELECT @count_exam = COUNT(*) FROM Exam WHERE Id_Student = @id_stud
661END
662GO
663/****** Object: StoredProcedure [dbo].[proc1] Script Date: 24.04.2020 20:53:04 ******/
664SET ANSI_NULLS ON
665GO
666SET QUOTED_IDENTIFIER ON
667GO
668CREATE PROCEDURE [dbo].[proc1] AS
669BEGIN
670 IF EXISTS (SELECT * FROM Student WHERE FIO = 'Овчинников')
671 UPDATE Student SET NameGroup = 'А-12-02' WHERE FIO = 'Овчинников'
672END
673GO
674/****** Object: StoredProcedure [dbo].[proc2] Script Date: 24.04.2020 20:53:04 ******/
675SET ANSI_NULLS ON
676GO
677SET QUOTED_IDENTIFIER ON
678GO
679CREATE PROCEDURE [dbo].[proc2] AS
680BEGIN
681 IF NOT EXISTS (SELECT * FROM Exam WHERE Id_Student = (SELECT Id_Student FROM Student WHERE
682 FIO = 'Овчинников') AND Subject = 'Сети')
683 INSERT INTO Exam VALUES (3, 'Сети', 30, '17/01/2016', 124)
684 ELSE
685 UPDATE Exam SET Mark = 30 WHERE Id_Student = (SELECT Id_Student FROM Student WHERE
686 FIO = 'Овчинников' AND Subject = 'Сети')
687END
688GO
689/****** Object: StoredProcedure [dbo].[proc2_1] Script Date: 24.04.2020 20:53:04 ******/
690SET ANSI_NULLS ON
691GO
692SET QUOTED_IDENTIFIER ON
693GO
694CREATE PROCEDURE [dbo].[proc2_1] AS
695BEGIN
696 IF EXISTS (SELECT * FROM Student WHERE FIO = 'Овчинников' AND NameGroup != 'А-12-02')
697 UPDATE Student SET NameGroup = 'А-12-02' WHERE FIO = 'Овчинников'
698END
699GO
700/****** Object: StoredProcedure [dbo].[proc2_1_v2] Script Date: 24.04.2020 20:53:04 ******/
701SET ANSI_NULLS ON
702GO
703SET QUOTED_IDENTIFIER ON
704GO
705CREATE PROCEDURE [dbo].[proc2_1_v2] @fio VARCHAR(50), @gruppa VARCHAR(50)
706AS
707BEGIN
708 IF EXISTS (SELECT * FROM Student WHERE FIO = @fio)
709 UPDATE Student SET NameGroup = @gruppa WHERE FIO = @fio
710 IF NOT EXISTS (SELECT * FROM StudGroup WHERE NameGroup = @gruppa) PRINT 'такой группы нетууууууу'
711 IF NOT EXISTS (SELECT * FROM Student WHERE FIO = @fio) PRINT 'нету такого студентаааааа'
712END
713GO
714/****** Object: StoredProcedure [dbo].[proc2_2] Script Date: 24.04.2020 20:53:04 ******/
715SET ANSI_NULLS ON
716GO
717SET QUOTED_IDENTIFIER ON
718GO
719CREATE PROCEDURE [dbo].[proc2_2] (@fio VARCHAR (50), @predmet VARCHAR(50), @ocenka SMALLINT, @data DATE, @fioprepod VARCHAR(50))
720AS
721BEGIN
722DECLARE @id SMALLINT
723DECLARE @prepid SMALLINT
724SET @id = (SELECT Id_Student FROM Student WHERE FIO = @fio)
725SET @prepid = (SELECT Id_Lect FROM Lecturer WHERE FIO = @fioprepod)
726IF NOT EXISTS (SELECT * FROM Exam WHERE Id_Student = @id AND Subject = @predmet)
727INSERT INTO Exam VALUES (@id, @predmet, @ocenka, @data, @prepid)
728ELSE
729UPDATE Exam SET Mark = @ocenka, Exam_Date = @data, Id_Lect = @prepid WHERE Id_Student = @id
730END
731GO
732/****** Object: StoredProcedure [dbo].[proc2_5_v2] Script Date: 24.04.2020 20:53:04 ******/
733SET ANSI_NULLS ON
734GO
735SET QUOTED_IDENTIFIER ON
736GO
737CREATE PROCEDURE [dbo].[proc2_5_v2]
738@procent SMALLINT, @minimum SMALLINT
739AS
740BEGIN
741 UPDATE Student SET Stip = 100 WHERE Id_Student IN (SELECT Id_Student FROM Exam WHERE Mark NOT IN (25,34) GROUP BY Id_Student)
742END
743
744
745
746
747--(Stip + (Stip*20/100))
748GO
749/****** Object: StoredProcedure [dbo].[proc2_5_v3] Script Date: 24.04.2020 20:53:04 ******/
750SET ANSI_NULLS ON
751GO
752SET QUOTED_IDENTIFIER ON
753GO
754CREATE PROCEDURE [dbo].[proc2_5_v3]
755@procent SMALLINT, @minimum SMALLINT
756AS
757BEGIN
758 DECLARE @tab TABLE (fio VARCHAR(50))
759 INSERT INTO @tab SELECT Id_Student FROM Exam GROUP BY Id_Student HAVING MIN(Mark) >= 35
760 --UPDATE Student SET Stip = 100 WHERE Id_Student IN (SELECT Id_Student FROM Exam WHERE Mark NOT IN (25,34) GROUP BY Id_Student)
761 SELECT * FROM @tab
762END
763
764
765
766--(Stip + (Stip*20/100))
767GO
768/****** Object: StoredProcedure [dbo].[proc2_v2] Script Date: 24.04.2020 20:53:04 ******/
769SET ANSI_NULLS ON
770GO
771SET QUOTED_IDENTIFIER ON
772GO
773CREATE PROCEDURE [dbo].[proc2_v2] (@fio VARCHAR(50))
774AS
775BEGIN
776 DECLARE @id SMALLINT
777 SET @id = (SELECT Id_Student FROM Student WHERE FIO = @fio)
778 IF NOT EXISTS (SELECT * FROM Exam WHERE Id_Student = (SELECT Id_Student FROM Student WHERE
779 FIO = @fio) AND Subject = 'Сети')
780 INSERT INTO Exam VALUES (@id, 'Сети', 30, '17/01/2016', 124)
781 ELSE
782 UPDATE Exam SET Mark = 30 WHERE Id_Student = (SELECT Id_Student FROM Student WHERE
783 FIO = @fio AND Subject = 'Сети')
784END
785GO
786/****** Object: StoredProcedure [dbo].[proc2_v3] Script Date: 24.04.2020 20:53:04 ******/
787SET ANSI_NULLS ON
788GO
789SET QUOTED_IDENTIFIER ON
790GO
791CREATE PROCEDURE [dbo].[proc2_v3] (@fio VARCHAR (50), @predmet VARCHAR(50), @ocenka SMALLINT, @data DATE, @idprepod SMALLINT)
792AS
793BEGIN
794DECLARE @id SMALLINT
795SET @id = (SELECT Id_Student FROM Student WHERE FIO = @fio)
796IF NOT EXISTS (SELECT * FROM Exam WHERE Id_Student = @id AND Subject = @predmet)
797INSERT INTO Exam VALUES (@id, @predmet, @ocenka, @data, @idprepod)
798ELSE
799UPDATE Exam SET Mark = @ocenka, Exam_Date = @data, Id_Lect = @idprepod WHERE Id_Student = @id
800END
801
802GO
803/****** Object: StoredProcedure [dbo].[proc5] Script Date: 24.04.2020 20:53:04 ******/
804SET ANSI_NULLS ON
805GO
806SET QUOTED_IDENTIFIER ON
807GO
808CREATE PROCEDURE [dbo].[proc5] (@percent FLOAT, @minimum SMALLINT)
809AS
810BEGIN
811 UPDATE Student SET Stip = Stip * @percent WHERE Id_Student IN (SELECT DISTINCT Id_Student FROM Exam WHERE Mark NOT IN (25,35))
812 UPDATE Student SET Stip = @minimum WHERE Stip IS NULL
813END
814GO
815/****** Object: StoredProcedure [dbo].[proc6] Script Date: 24.04.2020 20:53:04 ******/
816SET ANSI_NULLS ON
817GO
818SET QUOTED_IDENTIFIER ON
819GO
820CREATE PROCEDURE [dbo].[proc6] (@percent FLOAT, @minimum SMALLINT)
821AS
822BEGIN
823 UPDATE Student SET Stip = Stip * @percent WHERE Id_Student IN (SELECT DISTINCT Id_Student FROM Exam WHERE Mark NOT IN (25,35))
824 UPDATE Student SET Stip = @minimum WHERE Stip IS NULL
825END
826GO
827EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
828Begin DesignProperties =
829 Begin PaneConfigurations =
830 Begin PaneConfiguration = 0
831 NumPanes = 4
832 Configuration = "(H (1[41] 4[20] 2[6] 3) )"
833 End
834 Begin PaneConfiguration = 1
835 NumPanes = 3
836 Configuration = "(H (1 [50] 4 [25] 3))"
837 End
838 Begin PaneConfiguration = 2
839 NumPanes = 3
840 Configuration = "(H (1 [50] 2 [25] 3))"
841 End
842 Begin PaneConfiguration = 3
843 NumPanes = 3
844 Configuration = "(H (4 [30] 2 [40] 3))"
845 End
846 Begin PaneConfiguration = 4
847 NumPanes = 2
848 Configuration = "(H (1 [56] 3))"
849 End
850 Begin PaneConfiguration = 5
851 NumPanes = 2
852 Configuration = "(H (2 [66] 3))"
853 End
854 Begin PaneConfiguration = 6
855 NumPanes = 2
856 Configuration = "(H (4 [50] 3))"
857 End
858 Begin PaneConfiguration = 7
859 NumPanes = 1
860 Configuration = "(V (3))"
861 End
862 Begin PaneConfiguration = 8
863 NumPanes = 3
864 Configuration = "(H (1[56] 4[18] 2) )"
865 End
866 Begin PaneConfiguration = 9
867 NumPanes = 2
868 Configuration = "(H (1 [75] 4))"
869 End
870 Begin PaneConfiguration = 10
871 NumPanes = 2
872 Configuration = "(H (1[66] 2) )"
873 End
874 Begin PaneConfiguration = 11
875 NumPanes = 2
876 Configuration = "(H (4 [60] 2))"
877 End
878 Begin PaneConfiguration = 12
879 NumPanes = 1
880 Configuration = "(H (1) )"
881 End
882 Begin PaneConfiguration = 13
883 NumPanes = 1
884 Configuration = "(V (4))"
885 End
886 Begin PaneConfiguration = 14
887 NumPanes = 1
888 Configuration = "(V (2))"
889 End
890 ActivePaneConfig = 0
891 End
892 Begin DiagramPane =
893 Begin Origin =
894 Top = 0
895 Left = 0
896 End
897 Begin Tables =
898 Begin Table = "Student"
899 Begin Extent =
900 Top = 6
901 Left = 38
902 Bottom = 180
903 Right = 208
904 End
905 DisplayFlags = 280
906 TopColumn = 0
907 End
908 Begin Table = "StudGroup"
909 Begin Extent =
910 Top = 6
911 Left = 246
912 Bottom = 119
913 Right = 416
914 End
915 DisplayFlags = 280
916 TopColumn = 0
917 End
918 End
919 End
920 Begin SQLPane =
921 End
922 Begin DataPane =
923 Begin ParameterDefaults = ""
924 End
925 Begin ColumnWidths = 9
926 Width = 284
927 Width = 1500
928 Width = 1500
929 Width = 1500
930 Width = 1500
931 Width = 1500
932 Width = 1500
933 Width = 1500
934 Width = 1500
935 End
936 End
937 Begin CriteriaPane =
938 Begin ColumnWidths = 12
939 Column = 1440
940 Alias = 2565
941 Table = 1170
942 Output = 720
943 Append = 1400
944 NewValue = 1170
945 SortType = 1350
946 SortOrder = 1410
947 GroupBy = 1350
948 Filter = 1350
949 Or = 1350
950 Or = 1350
951 Or = 1350
952 End
953 End
954End
955' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_10А'
956GO
957EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_10А'
958GO
959EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
960Begin DesignProperties =
961 Begin PaneConfigurations =
962 Begin PaneConfiguration = 0
963 NumPanes = 4
964 Configuration = "(H (1[41] 4[20] 2[12] 3) )"
965 End
966 Begin PaneConfiguration = 1
967 NumPanes = 3
968 Configuration = "(H (1 [50] 4 [25] 3))"
969 End
970 Begin PaneConfiguration = 2
971 NumPanes = 3
972 Configuration = "(H (1 [50] 2 [25] 3))"
973 End
974 Begin PaneConfiguration = 3
975 NumPanes = 3
976 Configuration = "(H (4 [30] 2 [40] 3))"
977 End
978 Begin PaneConfiguration = 4
979 NumPanes = 2
980 Configuration = "(H (1 [56] 3))"
981 End
982 Begin PaneConfiguration = 5
983 NumPanes = 2
984 Configuration = "(H (2 [66] 3))"
985 End
986 Begin PaneConfiguration = 6
987 NumPanes = 2
988 Configuration = "(H (4 [50] 3))"
989 End
990 Begin PaneConfiguration = 7
991 NumPanes = 1
992 Configuration = "(V (3))"
993 End
994 Begin PaneConfiguration = 8
995 NumPanes = 3
996 Configuration = "(H (1[56] 4[18] 2) )"
997 End
998 Begin PaneConfiguration = 9
999 NumPanes = 2
1000 Configuration = "(H (1 [75] 4))"
1001 End
1002 Begin PaneConfiguration = 10
1003 NumPanes = 2
1004 Configuration = "(H (1[66] 2) )"
1005 End
1006 Begin PaneConfiguration = 11
1007 NumPanes = 2
1008 Configuration = "(H (4 [60] 2))"
1009 End
1010 Begin PaneConfiguration = 12
1011 NumPanes = 1
1012 Configuration = "(H (1) )"
1013 End
1014 Begin PaneConfiguration = 13
1015 NumPanes = 1
1016 Configuration = "(V (4))"
1017 End
1018 Begin PaneConfiguration = 14
1019 NumPanes = 1
1020 Configuration = "(V (2))"
1021 End
1022 ActivePaneConfig = 0
1023 End
1024 Begin DiagramPane =
1025 Begin Origin =
1026 Top = 0
1027 Left = 0
1028 End
1029 Begin Tables =
1030 Begin Table = "Student"
1031 Begin Extent =
1032 Top = 30
1033 Left = 231
1034 Bottom = 208
1035 Right = 401
1036 End
1037 DisplayFlags = 280
1038 TopColumn = 0
1039 End
1040 Begin Table = "StudGroup"
1041 Begin Extent =
1042 Top = 44
1043 Left = 18
1044 Bottom = 157
1045 Right = 188
1046 End
1047 DisplayFlags = 280
1048 TopColumn = 0
1049 End
1050 Begin Table = "Exam"
1051 Begin Extent =
1052 Top = 38
1053 Left = 476
1054 Bottom = 203
1055 Right = 646
1056 End
1057 DisplayFlags = 280
1058 TopColumn = 0
1059 End
1060 End
1061 End
1062 Begin SQLPane =
1063 End
1064 Begin DataPane =
1065 Begin ParameterDefaults = ""
1066 End
1067 Begin ColumnWidths = 9
1068 Width = 284
1069 Width = 1500
1070 Width = 1500
1071 Width = 1500
1072 Width = 1500
1073 Width = 1500
1074 Width = 1500
1075 Width = 1500
1076 Width = 1500
1077 End
1078 End
1079 Begin CriteriaPane =
1080 Begin ColumnWidths = 12
1081 Column = 1440
1082 Alias = 900
1083 Table = 1170
1084 Output = 720
1085 Append = 1400
1086 NewValue = 1170
1087 SortType = 1350
1088 SortOrder = 1410
1089 GroupBy = 1350
1090 Filter = 1350
1091 Or = 1350
1092 Or = 1350
1093 Or = 1350
1094 End
1095 End
1096End
1097' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_11А'
1098GO
1099EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_11А'
1100GO
1101EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1102Begin DesignProperties =
1103 Begin PaneConfigurations =
1104 Begin PaneConfiguration = 0
1105 NumPanes = 4
1106 Configuration = "(H (1[30] 4[31] 2[12] 3) )"
1107 End
1108 Begin PaneConfiguration = 1
1109 NumPanes = 3
1110 Configuration = "(H (1 [50] 4 [25] 3))"
1111 End
1112 Begin PaneConfiguration = 2
1113 NumPanes = 3
1114 Configuration = "(H (1 [50] 2 [25] 3))"
1115 End
1116 Begin PaneConfiguration = 3
1117 NumPanes = 3
1118 Configuration = "(H (4 [30] 2 [40] 3))"
1119 End
1120 Begin PaneConfiguration = 4
1121 NumPanes = 2
1122 Configuration = "(H (1 [56] 3))"
1123 End
1124 Begin PaneConfiguration = 5
1125 NumPanes = 2
1126 Configuration = "(H (2 [66] 3))"
1127 End
1128 Begin PaneConfiguration = 6
1129 NumPanes = 2
1130 Configuration = "(H (4 [50] 3))"
1131 End
1132 Begin PaneConfiguration = 7
1133 NumPanes = 1
1134 Configuration = "(V (3))"
1135 End
1136 Begin PaneConfiguration = 8
1137 NumPanes = 3
1138 Configuration = "(H (1[56] 4[18] 2) )"
1139 End
1140 Begin PaneConfiguration = 9
1141 NumPanes = 2
1142 Configuration = "(H (1 [75] 4))"
1143 End
1144 Begin PaneConfiguration = 10
1145 NumPanes = 2
1146 Configuration = "(H (1[66] 2) )"
1147 End
1148 Begin PaneConfiguration = 11
1149 NumPanes = 2
1150 Configuration = "(H (4 [60] 2))"
1151 End
1152 Begin PaneConfiguration = 12
1153 NumPanes = 1
1154 Configuration = "(H (1) )"
1155 End
1156 Begin PaneConfiguration = 13
1157 NumPanes = 1
1158 Configuration = "(V (4))"
1159 End
1160 Begin PaneConfiguration = 14
1161 NumPanes = 1
1162 Configuration = "(V (2))"
1163 End
1164 ActivePaneConfig = 0
1165 End
1166 Begin DiagramPane =
1167 Begin Origin =
1168 Top = 0
1169 Left = 0
1170 End
1171 Begin Tables =
1172 Begin Table = "3_11А"
1173 Begin Extent =
1174 Top = 6
1175 Left = 38
1176 Bottom = 119
1177 Right = 224
1178 End
1179 DisplayFlags = 280
1180 TopColumn = 0
1181 End
1182 End
1183 End
1184 Begin SQLPane =
1185 End
1186 Begin DataPane =
1187 Begin ParameterDefaults = ""
1188 End
1189 Begin ColumnWidths = 9
1190 Width = 284
1191 Width = 1500
1192 Width = 4695
1193 Width = 1500
1194 Width = 1500
1195 Width = 1500
1196 Width = 1500
1197 Width = 1500
1198 Width = 1500
1199 End
1200 End
1201 Begin CriteriaPane =
1202 Begin ColumnWidths = 12
1203 Column = 1440
1204 Alias = 900
1205 Table = 1170
1206 Output = 720
1207 Append = 1400
1208 NewValue = 1170
1209 SortType = 1350
1210 SortOrder = 1410
1211 GroupBy = 1350
1212 Filter = 1350
1213 Or = 1350
1214 Or = 1350
1215 Or = 1350
1216 End
1217 End
1218End
1219' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_11Б'
1220GO
1221EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_11Б'
1222GO
1223EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1224Begin DesignProperties =
1225 Begin PaneConfigurations =
1226 Begin PaneConfiguration = 0
1227 NumPanes = 4
1228 Configuration = "(H (1[42] 4[20] 2[8] 3) )"
1229 End
1230 Begin PaneConfiguration = 1
1231 NumPanes = 3
1232 Configuration = "(H (1 [50] 4 [25] 3))"
1233 End
1234 Begin PaneConfiguration = 2
1235 NumPanes = 3
1236 Configuration = "(H (1 [50] 2 [25] 3))"
1237 End
1238 Begin PaneConfiguration = 3
1239 NumPanes = 3
1240 Configuration = "(H (4 [30] 2 [40] 3))"
1241 End
1242 Begin PaneConfiguration = 4
1243 NumPanes = 2
1244 Configuration = "(H (1 [56] 3))"
1245 End
1246 Begin PaneConfiguration = 5
1247 NumPanes = 2
1248 Configuration = "(H (2 [66] 3))"
1249 End
1250 Begin PaneConfiguration = 6
1251 NumPanes = 2
1252 Configuration = "(H (4 [50] 3))"
1253 End
1254 Begin PaneConfiguration = 7
1255 NumPanes = 1
1256 Configuration = "(V (3))"
1257 End
1258 Begin PaneConfiguration = 8
1259 NumPanes = 3
1260 Configuration = "(H (1[56] 4[18] 2) )"
1261 End
1262 Begin PaneConfiguration = 9
1263 NumPanes = 2
1264 Configuration = "(H (1 [75] 4))"
1265 End
1266 Begin PaneConfiguration = 10
1267 NumPanes = 2
1268 Configuration = "(H (1[66] 2) )"
1269 End
1270 Begin PaneConfiguration = 11
1271 NumPanes = 2
1272 Configuration = "(H (4 [60] 2))"
1273 End
1274 Begin PaneConfiguration = 12
1275 NumPanes = 1
1276 Configuration = "(H (1) )"
1277 End
1278 Begin PaneConfiguration = 13
1279 NumPanes = 1
1280 Configuration = "(V (4))"
1281 End
1282 Begin PaneConfiguration = 14
1283 NumPanes = 1
1284 Configuration = "(V (2))"
1285 End
1286 ActivePaneConfig = 0
1287 End
1288 Begin DiagramPane =
1289 Begin Origin =
1290 Top = 0
1291 Left = 0
1292 End
1293 Begin Tables =
1294 Begin Table = "Exam"
1295 Begin Extent =
1296 Top = 6
1297 Left = 38
1298 Bottom = 177
1299 Right = 208
1300 End
1301 DisplayFlags = 280
1302 TopColumn = 0
1303 End
1304 Begin Table = "Student"
1305 Begin Extent =
1306 Top = 6
1307 Left = 246
1308 Bottom = 173
1309 Right = 416
1310 End
1311 DisplayFlags = 280
1312 TopColumn = 0
1313 End
1314 End
1315 End
1316 Begin SQLPane =
1317 End
1318 Begin DataPane =
1319 Begin ParameterDefaults = ""
1320 End
1321 Begin ColumnWidths = 9
1322 Width = 284
1323 Width = 1500
1324 Width = 1500
1325 Width = 1500
1326 Width = 1500
1327 Width = 1500
1328 Width = 1500
1329 Width = 1500
1330 Width = 1500
1331 End
1332 End
1333 Begin CriteriaPane =
1334 Begin ColumnWidths = 12
1335 Column = 1440
1336 Alias = 900
1337 Table = 1170
1338 Output = 720
1339 Append = 1400
1340 NewValue = 1170
1341 SortType = 1350
1342 SortOrder = 1410
1343 GroupBy = 1350
1344 Filter = 1350
1345 Or = 1350
1346 Or = 1350
1347 Or = 1350
1348 End
1349 End
1350End
1351' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_12А'
1352GO
1353EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_12А'
1354GO
1355EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1356Begin DesignProperties =
1357 Begin PaneConfigurations =
1358 Begin PaneConfiguration = 0
1359 NumPanes = 4
1360 Configuration = "(H (1[41] 4[20] 2[10] 3) )"
1361 End
1362 Begin PaneConfiguration = 1
1363 NumPanes = 3
1364 Configuration = "(H (1 [50] 4 [25] 3))"
1365 End
1366 Begin PaneConfiguration = 2
1367 NumPanes = 3
1368 Configuration = "(H (1 [50] 2 [25] 3))"
1369 End
1370 Begin PaneConfiguration = 3
1371 NumPanes = 3
1372 Configuration = "(H (4 [30] 2 [40] 3))"
1373 End
1374 Begin PaneConfiguration = 4
1375 NumPanes = 2
1376 Configuration = "(H (1 [56] 3))"
1377 End
1378 Begin PaneConfiguration = 5
1379 NumPanes = 2
1380 Configuration = "(H (2 [66] 3))"
1381 End
1382 Begin PaneConfiguration = 6
1383 NumPanes = 2
1384 Configuration = "(H (4 [50] 3))"
1385 End
1386 Begin PaneConfiguration = 7
1387 NumPanes = 1
1388 Configuration = "(V (3))"
1389 End
1390 Begin PaneConfiguration = 8
1391 NumPanes = 3
1392 Configuration = "(H (1[56] 4[18] 2) )"
1393 End
1394 Begin PaneConfiguration = 9
1395 NumPanes = 2
1396 Configuration = "(H (1 [75] 4))"
1397 End
1398 Begin PaneConfiguration = 10
1399 NumPanes = 2
1400 Configuration = "(H (1[66] 2) )"
1401 End
1402 Begin PaneConfiguration = 11
1403 NumPanes = 2
1404 Configuration = "(H (4 [60] 2))"
1405 End
1406 Begin PaneConfiguration = 12
1407 NumPanes = 1
1408 Configuration = "(H (1) )"
1409 End
1410 Begin PaneConfiguration = 13
1411 NumPanes = 1
1412 Configuration = "(V (4))"
1413 End
1414 Begin PaneConfiguration = 14
1415 NumPanes = 1
1416 Configuration = "(V (2))"
1417 End
1418 ActivePaneConfig = 0
1419 End
1420 Begin DiagramPane =
1421 Begin Origin =
1422 Top = 0
1423 Left = 0
1424 End
1425 Begin Tables =
1426 Begin Table = "3_12А"
1427 Begin Extent =
1428 Top = 6
1429 Left = 38
1430 Bottom = 119
1431 Right = 224
1432 End
1433 DisplayFlags = 280
1434 TopColumn = 0
1435 End
1436 End
1437 End
1438 Begin SQLPane =
1439 End
1440 Begin DataPane =
1441 Begin ParameterDefaults = ""
1442 End
1443 Begin ColumnWidths = 9
1444 Width = 284
1445 Width = 1500
1446 Width = 1500
1447 Width = 1500
1448 Width = 1500
1449 Width = 1500
1450 Width = 1500
1451 Width = 1500
1452 Width = 1500
1453 End
1454 End
1455 Begin CriteriaPane =
1456 Begin ColumnWidths = 12
1457 Column = 1440
1458 Alias = 1185
1459 Table = 1170
1460 Output = 720
1461 Append = 1400
1462 NewValue = 1170
1463 SortType = 1350
1464 SortOrder = 1410
1465 GroupBy = 1350
1466 Filter = 1350
1467 Or = 1350
1468 Or = 1350
1469 Or = 1350
1470 End
1471 End
1472End
1473' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_12Б'
1474GO
1475EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_12Б'
1476GO
1477EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1478Begin DesignProperties =
1479 Begin PaneConfigurations =
1480 Begin PaneConfiguration = 0
1481 NumPanes = 4
1482 Configuration = "(H (1[41] 4[20] 2[9] 3) )"
1483 End
1484 Begin PaneConfiguration = 1
1485 NumPanes = 3
1486 Configuration = "(H (1 [50] 4 [25] 3))"
1487 End
1488 Begin PaneConfiguration = 2
1489 NumPanes = 3
1490 Configuration = "(H (1 [50] 2 [25] 3))"
1491 End
1492 Begin PaneConfiguration = 3
1493 NumPanes = 3
1494 Configuration = "(H (4 [30] 2 [40] 3))"
1495 End
1496 Begin PaneConfiguration = 4
1497 NumPanes = 2
1498 Configuration = "(H (1 [56] 3))"
1499 End
1500 Begin PaneConfiguration = 5
1501 NumPanes = 2
1502 Configuration = "(H (2 [66] 3))"
1503 End
1504 Begin PaneConfiguration = 6
1505 NumPanes = 2
1506 Configuration = "(H (4 [50] 3))"
1507 End
1508 Begin PaneConfiguration = 7
1509 NumPanes = 1
1510 Configuration = "(V (3))"
1511 End
1512 Begin PaneConfiguration = 8
1513 NumPanes = 3
1514 Configuration = "(H (1[56] 4[18] 2) )"
1515 End
1516 Begin PaneConfiguration = 9
1517 NumPanes = 2
1518 Configuration = "(H (1 [75] 4))"
1519 End
1520 Begin PaneConfiguration = 10
1521 NumPanes = 2
1522 Configuration = "(H (1[66] 2) )"
1523 End
1524 Begin PaneConfiguration = 11
1525 NumPanes = 2
1526 Configuration = "(H (4 [60] 2))"
1527 End
1528 Begin PaneConfiguration = 12
1529 NumPanes = 1
1530 Configuration = "(H (1) )"
1531 End
1532 Begin PaneConfiguration = 13
1533 NumPanes = 1
1534 Configuration = "(V (4))"
1535 End
1536 Begin PaneConfiguration = 14
1537 NumPanes = 1
1538 Configuration = "(V (2))"
1539 End
1540 ActivePaneConfig = 0
1541 End
1542 Begin DiagramPane =
1543 Begin Origin =
1544 Top = 0
1545 Left = 0
1546 End
1547 Begin Tables =
1548 Begin Table = "Student"
1549 Begin Extent =
1550 Top = 6
1551 Left = 38
1552 Bottom = 189
1553 Right = 208
1554 End
1555 DisplayFlags = 280
1556 TopColumn = 0
1557 End
1558 End
1559 End
1560 Begin SQLPane =
1561 End
1562 Begin DataPane =
1563 Begin ParameterDefaults = ""
1564 End
1565 Begin ColumnWidths = 9
1566 Width = 284
1567 Width = 1500
1568 Width = 2625
1569 Width = 1500
1570 Width = 1500
1571 Width = 1500
1572 Width = 1500
1573 Width = 1500
1574 Width = 1500
1575 End
1576 End
1577 Begin CriteriaPane =
1578 Begin ColumnWidths = 12
1579 Column = 1440
1580 Alias = 2100
1581 Table = 1170
1582 Output = 720
1583 Append = 1400
1584 NewValue = 1170
1585 SortType = 1350
1586 SortOrder = 1410
1587 GroupBy = 1350
1588 Filter = 1350
1589 Or = 1350
1590 Or = 1350
1591 Or = 1350
1592 End
1593 End
1594End
1595' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_1A'
1596GO
1597EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_1A'
1598GO
1599EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1600Begin DesignProperties =
1601 Begin PaneConfigurations =
1602 Begin PaneConfiguration = 0
1603 NumPanes = 4
1604 Configuration = "(H (1[41] 4[20] 2[8] 3) )"
1605 End
1606 Begin PaneConfiguration = 1
1607 NumPanes = 3
1608 Configuration = "(H (1 [50] 4 [25] 3))"
1609 End
1610 Begin PaneConfiguration = 2
1611 NumPanes = 3
1612 Configuration = "(H (1 [50] 2 [25] 3))"
1613 End
1614 Begin PaneConfiguration = 3
1615 NumPanes = 3
1616 Configuration = "(H (4 [30] 2 [40] 3))"
1617 End
1618 Begin PaneConfiguration = 4
1619 NumPanes = 2
1620 Configuration = "(H (1 [56] 3))"
1621 End
1622 Begin PaneConfiguration = 5
1623 NumPanes = 2
1624 Configuration = "(H (2 [66] 3))"
1625 End
1626 Begin PaneConfiguration = 6
1627 NumPanes = 2
1628 Configuration = "(H (4 [50] 3))"
1629 End
1630 Begin PaneConfiguration = 7
1631 NumPanes = 1
1632 Configuration = "(V (3))"
1633 End
1634 Begin PaneConfiguration = 8
1635 NumPanes = 3
1636 Configuration = "(H (1[56] 4[18] 2) )"
1637 End
1638 Begin PaneConfiguration = 9
1639 NumPanes = 2
1640 Configuration = "(H (1 [75] 4))"
1641 End
1642 Begin PaneConfiguration = 10
1643 NumPanes = 2
1644 Configuration = "(H (1[66] 2) )"
1645 End
1646 Begin PaneConfiguration = 11
1647 NumPanes = 2
1648 Configuration = "(H (4 [60] 2))"
1649 End
1650 Begin PaneConfiguration = 12
1651 NumPanes = 1
1652 Configuration = "(H (1) )"
1653 End
1654 Begin PaneConfiguration = 13
1655 NumPanes = 1
1656 Configuration = "(V (4))"
1657 End
1658 Begin PaneConfiguration = 14
1659 NumPanes = 1
1660 Configuration = "(V (2))"
1661 End
1662 ActivePaneConfig = 0
1663 End
1664 Begin DiagramPane =
1665 Begin Origin =
1666 Top = 0
1667 Left = 0
1668 End
1669 Begin Tables =
1670 Begin Table = "3_1A"
1671 Begin Extent =
1672 Top = 6
1673 Left = 38
1674 Bottom = 102
1675 Right = 270
1676 End
1677 DisplayFlags = 280
1678 TopColumn = 0
1679 End
1680 Begin Table = "Student"
1681 Begin Extent =
1682 Top = 6
1683 Left = 360
1684 Bottom = 184
1685 Right = 530
1686 End
1687 DisplayFlags = 280
1688 TopColumn = 0
1689 End
1690 End
1691 End
1692 Begin SQLPane =
1693 End
1694 Begin DataPane =
1695 Begin ParameterDefaults = ""
1696 End
1697 Begin ColumnWidths = 9
1698 Width = 284
1699 Width = 1500
1700 Width = 1500
1701 Width = 1500
1702 Width = 1500
1703 Width = 1500
1704 Width = 1500
1705 Width = 1500
1706 Width = 1500
1707 End
1708 End
1709 Begin CriteriaPane =
1710 Begin ColumnWidths = 11
1711 Column = 1440
1712 Alias = 900
1713 Table = 1170
1714 Output = 720
1715 Append = 1400
1716 NewValue = 1170
1717 SortType = 1350
1718 SortOrder = 1410
1719 GroupBy = 1350
1720 Filter = 1350
1721 Or = 1350
1722 Or = 1350
1723 Or = 1350
1724 End
1725 End
1726End
1727' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_1Б'
1728GO
1729EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_1Б'
1730GO
1731EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1732Begin DesignProperties =
1733 Begin PaneConfigurations =
1734 Begin PaneConfiguration = 0
1735 NumPanes = 4
1736 Configuration = "(H (1[41] 4[20] 2[12] 3) )"
1737 End
1738 Begin PaneConfiguration = 1
1739 NumPanes = 3
1740 Configuration = "(H (1 [50] 4 [25] 3))"
1741 End
1742 Begin PaneConfiguration = 2
1743 NumPanes = 3
1744 Configuration = "(H (1 [50] 2 [25] 3))"
1745 End
1746 Begin PaneConfiguration = 3
1747 NumPanes = 3
1748 Configuration = "(H (4 [30] 2 [40] 3))"
1749 End
1750 Begin PaneConfiguration = 4
1751 NumPanes = 2
1752 Configuration = "(H (1 [56] 3))"
1753 End
1754 Begin PaneConfiguration = 5
1755 NumPanes = 2
1756 Configuration = "(H (2 [66] 3))"
1757 End
1758 Begin PaneConfiguration = 6
1759 NumPanes = 2
1760 Configuration = "(H (4 [50] 3))"
1761 End
1762 Begin PaneConfiguration = 7
1763 NumPanes = 1
1764 Configuration = "(V (3))"
1765 End
1766 Begin PaneConfiguration = 8
1767 NumPanes = 3
1768 Configuration = "(H (1[56] 4[18] 2) )"
1769 End
1770 Begin PaneConfiguration = 9
1771 NumPanes = 2
1772 Configuration = "(H (1 [75] 4))"
1773 End
1774 Begin PaneConfiguration = 10
1775 NumPanes = 2
1776 Configuration = "(H (1[66] 2) )"
1777 End
1778 Begin PaneConfiguration = 11
1779 NumPanes = 2
1780 Configuration = "(H (4 [60] 2))"
1781 End
1782 Begin PaneConfiguration = 12
1783 NumPanes = 1
1784 Configuration = "(H (1) )"
1785 End
1786 Begin PaneConfiguration = 13
1787 NumPanes = 1
1788 Configuration = "(V (4))"
1789 End
1790 Begin PaneConfiguration = 14
1791 NumPanes = 1
1792 Configuration = "(V (2))"
1793 End
1794 ActivePaneConfig = 0
1795 End
1796 Begin DiagramPane =
1797 Begin Origin =
1798 Top = 0
1799 Left = 0
1800 End
1801 Begin Tables =
1802 Begin Table = "Lecturer"
1803 Begin Extent =
1804 Top = 6
1805 Left = 38
1806 Bottom = 156
1807 Right = 208
1808 End
1809 DisplayFlags = 280
1810 TopColumn = 0
1811 End
1812 Begin Table = "Exam"
1813 Begin Extent =
1814 Top = 6
1815 Left = 246
1816 Bottom = 167
1817 Right = 423
1818 End
1819 DisplayFlags = 280
1820 TopColumn = 0
1821 End
1822 Begin Table = "Student"
1823 Begin Extent =
1824 Top = 6
1825 Left = 454
1826 Bottom = 185
1827 Right = 659
1828 End
1829 DisplayFlags = 280
1830 TopColumn = 0
1831 End
1832 End
1833 End
1834 Begin SQLPane =
1835 End
1836 Begin DataPane =
1837 Begin ParameterDefaults = ""
1838 End
1839 Begin ColumnWidths = 9
1840 Width = 284
1841 Width = 1500
1842 Width = 1500
1843 Width = 1500
1844 Width = 1500
1845 Width = 1500
1846 Width = 1500
1847 Width = 1500
1848 Width = 1500
1849 End
1850 End
1851 Begin CriteriaPane =
1852 Begin ColumnWidths = 12
1853 Column = 1440
1854 Alias = 900
1855 Table = 1170
1856 Output = 720
1857 Append = 1400
1858 NewValue = 1170
1859 SortType = 1350
1860 SortOrder = 1410
1861 GroupBy = 1350
1862 Filter = 1350
1863 Or = 1350
1864 Or = 1350
1865 Or = 1350
1866 End
1867 End
1868End
1869' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_2А'
1870GO
1871EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_2А'
1872GO
1873EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
1874Begin DesignProperties =
1875 Begin PaneConfigurations =
1876 Begin PaneConfiguration = 0
1877 NumPanes = 4
1878 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
1879 End
1880 Begin PaneConfiguration = 1
1881 NumPanes = 3
1882 Configuration = "(H (1 [50] 4 [25] 3))"
1883 End
1884 Begin PaneConfiguration = 2
1885 NumPanes = 3
1886 Configuration = "(H (1 [50] 2 [25] 3))"
1887 End
1888 Begin PaneConfiguration = 3
1889 NumPanes = 3
1890 Configuration = "(H (4 [30] 2 [40] 3))"
1891 End
1892 Begin PaneConfiguration = 4
1893 NumPanes = 2
1894 Configuration = "(H (1 [56] 3))"
1895 End
1896 Begin PaneConfiguration = 5
1897 NumPanes = 2
1898 Configuration = "(H (2 [66] 3))"
1899 End
1900 Begin PaneConfiguration = 6
1901 NumPanes = 2
1902 Configuration = "(H (4 [50] 3))"
1903 End
1904 Begin PaneConfiguration = 7
1905 NumPanes = 1
1906 Configuration = "(V (3))"
1907 End
1908 Begin PaneConfiguration = 8
1909 NumPanes = 3
1910 Configuration = "(H (1[56] 4[18] 2) )"
1911 End
1912 Begin PaneConfiguration = 9
1913 NumPanes = 2
1914 Configuration = "(H (1 [75] 4))"
1915 End
1916 Begin PaneConfiguration = 10
1917 NumPanes = 2
1918 Configuration = "(H (1[66] 2) )"
1919 End
1920 Begin PaneConfiguration = 11
1921 NumPanes = 2
1922 Configuration = "(H (4 [60] 2))"
1923 End
1924 Begin PaneConfiguration = 12
1925 NumPanes = 1
1926 Configuration = "(H (1) )"
1927 End
1928 Begin PaneConfiguration = 13
1929 NumPanes = 1
1930 Configuration = "(V (4))"
1931 End
1932 Begin PaneConfiguration = 14
1933 NumPanes = 1
1934 Configuration = "(V (2))"
1935 End
1936 ActivePaneConfig = 0
1937 End
1938 Begin DiagramPane =
1939 Begin Origin =
1940 Top = 0
1941 Left = 0
1942 End
1943 Begin Tables =
1944 Begin Table = "3_2А"
1945 Begin Extent =
1946 Top = 6
1947 Left = 38
1948 Bottom = 119
1949 Right = 255
1950 End
1951 DisplayFlags = 280
1952 TopColumn = 0
1953 End
1954 Begin Table = "Lecturer"
1955 Begin Extent =
1956 Top = 6
1957 Left = 287
1958 Bottom = 149
1959 Right = 457
1960 End
1961 DisplayFlags = 280
1962 TopColumn = 0
1963 End
1964 End
1965 End
1966 Begin SQLPane =
1967 End
1968 Begin DataPane =
1969 Begin ParameterDefaults = ""
1970 End
1971 Begin ColumnWidths = 9
1972 Width = 284
1973 Width = 1500
1974 Width = 2685
1975 Width = 1500
1976 Width = 1500
1977 Width = 1500
1978 Width = 1500
1979 Width = 1500
1980 Width = 1500
1981 End
1982 End
1983 Begin CriteriaPane =
1984 Begin ColumnWidths = 12
1985 Column = 1440
1986 Alias = 900
1987 Table = 1170
1988 Output = 720
1989 Append = 1400
1990 NewValue = 1170
1991 SortType = 1350
1992 SortOrder = 1410
1993 GroupBy = 1350
1994 Filter = 1350
1995 Or = 1350
1996 Or = 1350
1997 Or = 1350
1998 End
1999 End
2000End
2001' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_2Б'
2002GO
2003EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_2Б'
2004GO
2005EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2006Begin DesignProperties =
2007 Begin PaneConfigurations =
2008 Begin PaneConfiguration = 0
2009 NumPanes = 4
2010 Configuration = "(H (1[41] 4[20] 2[7] 3) )"
2011 End
2012 Begin PaneConfiguration = 1
2013 NumPanes = 3
2014 Configuration = "(H (1 [50] 4 [25] 3))"
2015 End
2016 Begin PaneConfiguration = 2
2017 NumPanes = 3
2018 Configuration = "(H (1 [50] 2 [25] 3))"
2019 End
2020 Begin PaneConfiguration = 3
2021 NumPanes = 3
2022 Configuration = "(H (4 [30] 2 [40] 3))"
2023 End
2024 Begin PaneConfiguration = 4
2025 NumPanes = 2
2026 Configuration = "(H (1 [56] 3))"
2027 End
2028 Begin PaneConfiguration = 5
2029 NumPanes = 2
2030 Configuration = "(H (2 [66] 3))"
2031 End
2032 Begin PaneConfiguration = 6
2033 NumPanes = 2
2034 Configuration = "(H (4 [50] 3))"
2035 End
2036 Begin PaneConfiguration = 7
2037 NumPanes = 1
2038 Configuration = "(V (3))"
2039 End
2040 Begin PaneConfiguration = 8
2041 NumPanes = 3
2042 Configuration = "(H (1[56] 4[18] 2) )"
2043 End
2044 Begin PaneConfiguration = 9
2045 NumPanes = 2
2046 Configuration = "(H (1 [75] 4))"
2047 End
2048 Begin PaneConfiguration = 10
2049 NumPanes = 2
2050 Configuration = "(H (1[66] 2) )"
2051 End
2052 Begin PaneConfiguration = 11
2053 NumPanes = 2
2054 Configuration = "(H (4 [60] 2))"
2055 End
2056 Begin PaneConfiguration = 12
2057 NumPanes = 1
2058 Configuration = "(H (1) )"
2059 End
2060 Begin PaneConfiguration = 13
2061 NumPanes = 1
2062 Configuration = "(V (4))"
2063 End
2064 Begin PaneConfiguration = 14
2065 NumPanes = 1
2066 Configuration = "(V (2))"
2067 End
2068 ActivePaneConfig = 0
2069 End
2070 Begin DiagramPane =
2071 Begin Origin =
2072 Top = 0
2073 Left = 0
2074 End
2075 Begin Tables =
2076 Begin Table = "Student"
2077 Begin Extent =
2078 Top = 6
2079 Left = 38
2080 Bottom = 170
2081 Right = 208
2082 End
2083 DisplayFlags = 280
2084 TopColumn = 0
2085 End
2086 Begin Table = "StudGroup"
2087 Begin Extent =
2088 Top = 6
2089 Left = 246
2090 Bottom = 119
2091 Right = 416
2092 End
2093 DisplayFlags = 280
2094 TopColumn = 0
2095 End
2096 End
2097 End
2098 Begin SQLPane =
2099 End
2100 Begin DataPane =
2101 Begin ParameterDefaults = ""
2102 End
2103 Begin ColumnWidths = 9
2104 Width = 284
2105 Width = 1500
2106 Width = 1500
2107 Width = 1500
2108 Width = 1500
2109 Width = 1500
2110 Width = 1500
2111 Width = 1500
2112 Width = 1500
2113 End
2114 End
2115 Begin CriteriaPane =
2116 Begin ColumnWidths = 12
2117 Column = 1440
2118 Alias = 900
2119 Table = 1170
2120 Output = 720
2121 Append = 1400
2122 NewValue = 1170
2123 SortType = 1350
2124 SortOrder = 1410
2125 GroupBy = 1350
2126 Filter = 1350
2127 Or = 1350
2128 Or = 1350
2129 Or = 1350
2130 End
2131 End
2132End
2133' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_3А'
2134GO
2135EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_3А'
2136GO
2137EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2138Begin DesignProperties =
2139 Begin PaneConfigurations =
2140 Begin PaneConfiguration = 0
2141 NumPanes = 4
2142 Configuration = "(H (1[41] 4[20] 2[8] 3) )"
2143 End
2144 Begin PaneConfiguration = 1
2145 NumPanes = 3
2146 Configuration = "(H (1 [50] 4 [25] 3))"
2147 End
2148 Begin PaneConfiguration = 2
2149 NumPanes = 3
2150 Configuration = "(H (1 [50] 2 [25] 3))"
2151 End
2152 Begin PaneConfiguration = 3
2153 NumPanes = 3
2154 Configuration = "(H (4 [30] 2 [40] 3))"
2155 End
2156 Begin PaneConfiguration = 4
2157 NumPanes = 2
2158 Configuration = "(H (1 [56] 3))"
2159 End
2160 Begin PaneConfiguration = 5
2161 NumPanes = 2
2162 Configuration = "(H (2 [66] 3))"
2163 End
2164 Begin PaneConfiguration = 6
2165 NumPanes = 2
2166 Configuration = "(H (4 [50] 3))"
2167 End
2168 Begin PaneConfiguration = 7
2169 NumPanes = 1
2170 Configuration = "(V (3))"
2171 End
2172 Begin PaneConfiguration = 8
2173 NumPanes = 3
2174 Configuration = "(H (1[56] 4[18] 2) )"
2175 End
2176 Begin PaneConfiguration = 9
2177 NumPanes = 2
2178 Configuration = "(H (1 [75] 4))"
2179 End
2180 Begin PaneConfiguration = 10
2181 NumPanes = 2
2182 Configuration = "(H (1[66] 2) )"
2183 End
2184 Begin PaneConfiguration = 11
2185 NumPanes = 2
2186 Configuration = "(H (4 [60] 2))"
2187 End
2188 Begin PaneConfiguration = 12
2189 NumPanes = 1
2190 Configuration = "(H (1) )"
2191 End
2192 Begin PaneConfiguration = 13
2193 NumPanes = 1
2194 Configuration = "(V (4))"
2195 End
2196 Begin PaneConfiguration = 14
2197 NumPanes = 1
2198 Configuration = "(V (2))"
2199 End
2200 ActivePaneConfig = 0
2201 End
2202 Begin DiagramPane =
2203 Begin Origin =
2204 Top = 0
2205 Left = 0
2206 End
2207 Begin Tables =
2208 Begin Table = "Exam"
2209 Begin Extent =
2210 Top = 6
2211 Left = 38
2212 Bottom = 165
2213 Right = 208
2214 End
2215 DisplayFlags = 280
2216 TopColumn = 0
2217 End
2218 End
2219 End
2220 Begin SQLPane =
2221 End
2222 Begin DataPane =
2223 Begin ParameterDefaults = ""
2224 End
2225 Begin ColumnWidths = 9
2226 Width = 284
2227 Width = 1500
2228 Width = 1500
2229 Width = 2595
2230 Width = 1500
2231 Width = 1500
2232 Width = 1500
2233 Width = 1500
2234 Width = 1500
2235 End
2236 End
2237 Begin CriteriaPane =
2238 Begin ColumnWidths = 12
2239 Column = 1440
2240 Alias = 900
2241 Table = 1170
2242 Output = 720
2243 Append = 1400
2244 NewValue = 1170
2245 SortType = 1350
2246 SortOrder = 1410
2247 GroupBy = 1350
2248 Filter = 1350
2249 Or = 1350
2250 Or = 1350
2251 Or = 1350
2252 End
2253 End
2254End
2255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_3Б'
2256GO
2257EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_3Б'
2258GO
2259EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2260Begin DesignProperties =
2261 Begin PaneConfigurations =
2262 Begin PaneConfiguration = 0
2263 NumPanes = 4
2264 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
2265 End
2266 Begin PaneConfiguration = 1
2267 NumPanes = 3
2268 Configuration = "(H (1 [50] 4 [25] 3))"
2269 End
2270 Begin PaneConfiguration = 2
2271 NumPanes = 3
2272 Configuration = "(H (1 [50] 2 [25] 3))"
2273 End
2274 Begin PaneConfiguration = 3
2275 NumPanes = 3
2276 Configuration = "(H (4 [30] 2 [40] 3))"
2277 End
2278 Begin PaneConfiguration = 4
2279 NumPanes = 2
2280 Configuration = "(H (1 [56] 3))"
2281 End
2282 Begin PaneConfiguration = 5
2283 NumPanes = 2
2284 Configuration = "(H (2 [66] 3))"
2285 End
2286 Begin PaneConfiguration = 6
2287 NumPanes = 2
2288 Configuration = "(H (4 [50] 3))"
2289 End
2290 Begin PaneConfiguration = 7
2291 NumPanes = 1
2292 Configuration = "(V (3))"
2293 End
2294 Begin PaneConfiguration = 8
2295 NumPanes = 3
2296 Configuration = "(H (1[56] 4[18] 2) )"
2297 End
2298 Begin PaneConfiguration = 9
2299 NumPanes = 2
2300 Configuration = "(H (1 [75] 4))"
2301 End
2302 Begin PaneConfiguration = 10
2303 NumPanes = 2
2304 Configuration = "(H (1[66] 2) )"
2305 End
2306 Begin PaneConfiguration = 11
2307 NumPanes = 2
2308 Configuration = "(H (4 [60] 2))"
2309 End
2310 Begin PaneConfiguration = 12
2311 NumPanes = 1
2312 Configuration = "(H (1) )"
2313 End
2314 Begin PaneConfiguration = 13
2315 NumPanes = 1
2316 Configuration = "(V (4))"
2317 End
2318 Begin PaneConfiguration = 14
2319 NumPanes = 1
2320 Configuration = "(V (2))"
2321 End
2322 ActivePaneConfig = 0
2323 End
2324 Begin DiagramPane =
2325 Begin Origin =
2326 Top = 0
2327 Left = 0
2328 End
2329 Begin Tables =
2330 Begin Table = "Lecturer"
2331 Begin Extent =
2332 Top = 6
2333 Left = 38
2334 Bottom = 136
2335 Right = 208
2336 End
2337 DisplayFlags = 280
2338 TopColumn = 0
2339 End
2340 End
2341 End
2342 Begin SQLPane =
2343 End
2344 Begin DataPane =
2345 Begin ParameterDefaults = ""
2346 End
2347 Begin ColumnWidths = 9
2348 Width = 284
2349 Width = 1500
2350 Width = 1500
2351 Width = 1500
2352 Width = 1500
2353 Width = 1500
2354 Width = 1500
2355 Width = 1500
2356 Width = 1500
2357 End
2358 End
2359 Begin CriteriaPane =
2360 Begin ColumnWidths = 11
2361 Column = 1440
2362 Alias = 900
2363 Table = 1170
2364 Output = 720
2365 Append = 1400
2366 NewValue = 1170
2367 SortType = 1350
2368 SortOrder = 1410
2369 GroupBy = 1350
2370 Filter = 1350
2371 Or = 1350
2372 Or = 1350
2373 Or = 1350
2374 End
2375 End
2376End
2377' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_4А'
2378GO
2379EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_4А'
2380GO
2381EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2382Begin DesignProperties =
2383 Begin PaneConfigurations =
2384 Begin PaneConfiguration = 0
2385 NumPanes = 4
2386 Configuration = "(H (1[41] 4[20] 2[18] 3) )"
2387 End
2388 Begin PaneConfiguration = 1
2389 NumPanes = 3
2390 Configuration = "(H (1 [50] 4 [25] 3))"
2391 End
2392 Begin PaneConfiguration = 2
2393 NumPanes = 3
2394 Configuration = "(H (1 [50] 2 [25] 3))"
2395 End
2396 Begin PaneConfiguration = 3
2397 NumPanes = 3
2398 Configuration = "(H (4 [30] 2 [40] 3))"
2399 End
2400 Begin PaneConfiguration = 4
2401 NumPanes = 2
2402 Configuration = "(H (1 [56] 3))"
2403 End
2404 Begin PaneConfiguration = 5
2405 NumPanes = 2
2406 Configuration = "(H (2 [66] 3))"
2407 End
2408 Begin PaneConfiguration = 6
2409 NumPanes = 2
2410 Configuration = "(H (4 [50] 3))"
2411 End
2412 Begin PaneConfiguration = 7
2413 NumPanes = 1
2414 Configuration = "(V (3))"
2415 End
2416 Begin PaneConfiguration = 8
2417 NumPanes = 3
2418 Configuration = "(H (1[56] 4[18] 2) )"
2419 End
2420 Begin PaneConfiguration = 9
2421 NumPanes = 2
2422 Configuration = "(H (1 [75] 4))"
2423 End
2424 Begin PaneConfiguration = 10
2425 NumPanes = 2
2426 Configuration = "(H (1[66] 2) )"
2427 End
2428 Begin PaneConfiguration = 11
2429 NumPanes = 2
2430 Configuration = "(H (4 [60] 2))"
2431 End
2432 Begin PaneConfiguration = 12
2433 NumPanes = 1
2434 Configuration = "(H (1) )"
2435 End
2436 Begin PaneConfiguration = 13
2437 NumPanes = 1
2438 Configuration = "(V (4))"
2439 End
2440 Begin PaneConfiguration = 14
2441 NumPanes = 1
2442 Configuration = "(V (2))"
2443 End
2444 ActivePaneConfig = 0
2445 End
2446 Begin DiagramPane =
2447 Begin Origin =
2448 Top = 0
2449 Left = 0
2450 End
2451 Begin Tables =
2452 Begin Table = "Lecturer"
2453 Begin Extent =
2454 Top = 14
2455 Left = 284
2456 Bottom = 173
2457 Right = 454
2458 End
2459 DisplayFlags = 280
2460 TopColumn = 0
2461 End
2462 Begin Table = "Exam"
2463 Begin Extent =
2464 Top = 6
2465 Left = 538
2466 Bottom = 174
2467 Right = 708
2468 End
2469 DisplayFlags = 280
2470 TopColumn = 0
2471 End
2472 Begin Table = "3_4А"
2473 Begin Extent =
2474 Top = 6
2475 Left = 38
2476 Bottom = 102
2477 Right = 224
2478 End
2479 DisplayFlags = 280
2480 TopColumn = 0
2481 End
2482 End
2483 End
2484 Begin SQLPane =
2485 End
2486 Begin DataPane =
2487 Begin ParameterDefaults = ""
2488 End
2489 Begin ColumnWidths = 9
2490 Width = 284
2491 Width = 1500
2492 Width = 1500
2493 Width = 1500
2494 Width = 1500
2495 Width = 1500
2496 Width = 1500
2497 Width = 1500
2498 Width = 1500
2499 End
2500 End
2501 Begin CriteriaPane =
2502 Begin ColumnWidths = 12
2503 Column = 1440
2504 Alias = 900
2505 Table = 1170
2506 Output = 720
2507 Append = 1400
2508 NewValue = 1170
2509 SortType = 1350
2510 SortOrder = 1410
2511 GroupBy = 1350
2512 Filter = 1350
2513 Or = 1350
2514 Or = 1350
2515 Or = 1350
2516 End
2517 End
2518End
2519' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_4Б'
2520GO
2521EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_4Б'
2522GO
2523EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2524Begin DesignProperties =
2525 Begin PaneConfigurations =
2526 Begin PaneConfiguration = 0
2527 NumPanes = 4
2528 Configuration = "(H (1[41] 4[20] 2[9] 3) )"
2529 End
2530 Begin PaneConfiguration = 1
2531 NumPanes = 3
2532 Configuration = "(H (1 [50] 4 [25] 3))"
2533 End
2534 Begin PaneConfiguration = 2
2535 NumPanes = 3
2536 Configuration = "(H (1 [50] 2 [25] 3))"
2537 End
2538 Begin PaneConfiguration = 3
2539 NumPanes = 3
2540 Configuration = "(H (4 [30] 2 [40] 3))"
2541 End
2542 Begin PaneConfiguration = 4
2543 NumPanes = 2
2544 Configuration = "(H (1 [56] 3))"
2545 End
2546 Begin PaneConfiguration = 5
2547 NumPanes = 2
2548 Configuration = "(H (2 [66] 3))"
2549 End
2550 Begin PaneConfiguration = 6
2551 NumPanes = 2
2552 Configuration = "(H (4 [50] 3))"
2553 End
2554 Begin PaneConfiguration = 7
2555 NumPanes = 1
2556 Configuration = "(V (3))"
2557 End
2558 Begin PaneConfiguration = 8
2559 NumPanes = 3
2560 Configuration = "(H (1[56] 4[18] 2) )"
2561 End
2562 Begin PaneConfiguration = 9
2563 NumPanes = 2
2564 Configuration = "(H (1 [75] 4))"
2565 End
2566 Begin PaneConfiguration = 10
2567 NumPanes = 2
2568 Configuration = "(H (1[66] 2) )"
2569 End
2570 Begin PaneConfiguration = 11
2571 NumPanes = 2
2572 Configuration = "(H (4 [60] 2))"
2573 End
2574 Begin PaneConfiguration = 12
2575 NumPanes = 1
2576 Configuration = "(H (1) )"
2577 End
2578 Begin PaneConfiguration = 13
2579 NumPanes = 1
2580 Configuration = "(V (4))"
2581 End
2582 Begin PaneConfiguration = 14
2583 NumPanes = 1
2584 Configuration = "(V (2))"
2585 End
2586 ActivePaneConfig = 0
2587 End
2588 Begin DiagramPane =
2589 Begin Origin =
2590 Top = 0
2591 Left = 0
2592 End
2593 Begin Tables =
2594 Begin Table = "Exam"
2595 Begin Extent =
2596 Top = 6
2597 Left = 38
2598 Bottom = 136
2599 Right = 208
2600 End
2601 DisplayFlags = 280
2602 TopColumn = 0
2603 End
2604 Begin Table = "Student"
2605 Begin Extent =
2606 Top = 6
2607 Left = 246
2608 Bottom = 136
2609 Right = 416
2610 End
2611 DisplayFlags = 280
2612 TopColumn = 0
2613 End
2614 Begin Table = "StudGroup"
2615 Begin Extent =
2616 Top = 6
2617 Left = 454
2618 Bottom = 163
2619 Right = 624
2620 End
2621 DisplayFlags = 280
2622 TopColumn = 0
2623 End
2624 End
2625 End
2626 Begin SQLPane =
2627 End
2628 Begin DataPane =
2629 Begin ParameterDefaults = ""
2630 End
2631 Begin ColumnWidths = 9
2632 Width = 284
2633 Width = 1500
2634 Width = 1500
2635 Width = 1500
2636 Width = 1500
2637 Width = 1500
2638 Width = 1500
2639 Width = 1500
2640 Width = 1500
2641 End
2642 End
2643 Begin CriteriaPane =
2644 Begin ColumnWidths = 12
2645 Column = 1440
2646 Alias = 900
2647 Table = 1170
2648 Output = 720
2649 Append = 1400
2650 NewValue = 1170
2651 SortType = 1350
2652 SortOrder = 1410
2653 GroupBy = 1350
2654 Filter = 1350
2655 Or = 1350
2656 Or = 1350
2657 Or = 1350
2658 End
2659 End
2660End
2661' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_5А'
2662GO
2663EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_5А'
2664GO
2665EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2666Begin DesignProperties =
2667 Begin PaneConfigurations =
2668 Begin PaneConfiguration = 0
2669 NumPanes = 4
2670 Configuration = "(H (1[38] 4[23] 2[12] 3) )"
2671 End
2672 Begin PaneConfiguration = 1
2673 NumPanes = 3
2674 Configuration = "(H (1 [50] 4 [25] 3))"
2675 End
2676 Begin PaneConfiguration = 2
2677 NumPanes = 3
2678 Configuration = "(H (1 [50] 2 [25] 3))"
2679 End
2680 Begin PaneConfiguration = 3
2681 NumPanes = 3
2682 Configuration = "(H (4 [30] 2 [40] 3))"
2683 End
2684 Begin PaneConfiguration = 4
2685 NumPanes = 2
2686 Configuration = "(H (1 [56] 3))"
2687 End
2688 Begin PaneConfiguration = 5
2689 NumPanes = 2
2690 Configuration = "(H (2 [66] 3))"
2691 End
2692 Begin PaneConfiguration = 6
2693 NumPanes = 2
2694 Configuration = "(H (4 [50] 3))"
2695 End
2696 Begin PaneConfiguration = 7
2697 NumPanes = 1
2698 Configuration = "(V (3))"
2699 End
2700 Begin PaneConfiguration = 8
2701 NumPanes = 3
2702 Configuration = "(H (1[56] 4[18] 2) )"
2703 End
2704 Begin PaneConfiguration = 9
2705 NumPanes = 2
2706 Configuration = "(H (1 [75] 4))"
2707 End
2708 Begin PaneConfiguration = 10
2709 NumPanes = 2
2710 Configuration = "(H (1[66] 2) )"
2711 End
2712 Begin PaneConfiguration = 11
2713 NumPanes = 2
2714 Configuration = "(H (4 [60] 2))"
2715 End
2716 Begin PaneConfiguration = 12
2717 NumPanes = 1
2718 Configuration = "(H (1) )"
2719 End
2720 Begin PaneConfiguration = 13
2721 NumPanes = 1
2722 Configuration = "(V (4))"
2723 End
2724 Begin PaneConfiguration = 14
2725 NumPanes = 1
2726 Configuration = "(V (2))"
2727 End
2728 ActivePaneConfig = 0
2729 End
2730 Begin DiagramPane =
2731 Begin Origin =
2732 Top = 0
2733 Left = 0
2734 End
2735 Begin Tables =
2736 Begin Table = "Exam"
2737 Begin Extent =
2738 Top = 6
2739 Left = 38
2740 Bottom = 165
2741 Right = 208
2742 End
2743 DisplayFlags = 280
2744 TopColumn = 0
2745 End
2746 Begin Table = "Student"
2747 Begin Extent =
2748 Top = 6
2749 Left = 279
2750 Bottom = 172
2751 Right = 449
2752 End
2753 DisplayFlags = 280
2754 TopColumn = 0
2755 End
2756 End
2757 End
2758 Begin SQLPane =
2759 End
2760 Begin DataPane =
2761 Begin ParameterDefaults = ""
2762 End
2763 Begin ColumnWidths = 9
2764 Width = 284
2765 Width = 1500
2766 Width = 1500
2767 Width = 1500
2768 Width = 1500
2769 Width = 1500
2770 Width = 1500
2771 Width = 1500
2772 Width = 1500
2773 End
2774 End
2775 Begin CriteriaPane =
2776 Begin ColumnWidths = 12
2777 Column = 1440
2778 Alias = 900
2779 Table = 1170
2780 Output = 720
2781 Append = 1400
2782 NewValue = 1170
2783 SortType = 1350
2784 SortOrder = 1410
2785 GroupBy = 1350
2786 Filter = 1350
2787 Or = 1350
2788 Or = 1350
2789 Or = 1350
2790 End
2791 End
2792End
2793' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_6А'
2794GO
2795EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_6А'
2796GO
2797EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2798Begin DesignProperties =
2799 Begin PaneConfigurations =
2800 Begin PaneConfiguration = 0
2801 NumPanes = 4
2802 Configuration = "(H (1[41] 4[22] 2[19] 3) )"
2803 End
2804 Begin PaneConfiguration = 1
2805 NumPanes = 3
2806 Configuration = "(H (1 [50] 4 [25] 3))"
2807 End
2808 Begin PaneConfiguration = 2
2809 NumPanes = 3
2810 Configuration = "(H (1 [50] 2 [25] 3))"
2811 End
2812 Begin PaneConfiguration = 3
2813 NumPanes = 3
2814 Configuration = "(H (4 [30] 2 [40] 3))"
2815 End
2816 Begin PaneConfiguration = 4
2817 NumPanes = 2
2818 Configuration = "(H (1 [56] 3))"
2819 End
2820 Begin PaneConfiguration = 5
2821 NumPanes = 2
2822 Configuration = "(H (2 [66] 3))"
2823 End
2824 Begin PaneConfiguration = 6
2825 NumPanes = 2
2826 Configuration = "(H (4 [50] 3))"
2827 End
2828 Begin PaneConfiguration = 7
2829 NumPanes = 1
2830 Configuration = "(V (3))"
2831 End
2832 Begin PaneConfiguration = 8
2833 NumPanes = 3
2834 Configuration = "(H (1[56] 4[18] 2) )"
2835 End
2836 Begin PaneConfiguration = 9
2837 NumPanes = 2
2838 Configuration = "(H (1 [75] 4))"
2839 End
2840 Begin PaneConfiguration = 10
2841 NumPanes = 2
2842 Configuration = "(H (1[66] 2) )"
2843 End
2844 Begin PaneConfiguration = 11
2845 NumPanes = 2
2846 Configuration = "(H (4 [60] 2))"
2847 End
2848 Begin PaneConfiguration = 12
2849 NumPanes = 1
2850 Configuration = "(H (1) )"
2851 End
2852 Begin PaneConfiguration = 13
2853 NumPanes = 1
2854 Configuration = "(V (4))"
2855 End
2856 Begin PaneConfiguration = 14
2857 NumPanes = 1
2858 Configuration = "(V (2))"
2859 End
2860 ActivePaneConfig = 0
2861 End
2862 Begin DiagramPane =
2863 Begin Origin =
2864 Top = 0
2865 Left = 0
2866 End
2867 Begin Tables =
2868 Begin Table = "3_6А"
2869 Begin Extent =
2870 Top = 6
2871 Left = 38
2872 Bottom = 119
2873 Right = 224
2874 End
2875 DisplayFlags = 280
2876 TopColumn = 0
2877 End
2878 End
2879 End
2880 Begin SQLPane =
2881 End
2882 Begin DataPane =
2883 Begin ParameterDefaults = ""
2884 End
2885 Begin ColumnWidths = 9
2886 Width = 284
2887 Width = 1500
2888 Width = 1500
2889 Width = 1500
2890 Width = 1500
2891 Width = 1500
2892 Width = 1500
2893 Width = 1500
2894 Width = 1500
2895 End
2896 End
2897 Begin CriteriaPane =
2898 Begin ColumnWidths = 12
2899 Column = 1440
2900 Alias = 900
2901 Table = 1170
2902 Output = 720
2903 Append = 1400
2904 NewValue = 1170
2905 SortType = 1350
2906 SortOrder = 1410
2907 GroupBy = 1350
2908 Filter = 1350
2909 Or = 1350
2910 Or = 1350
2911 Or = 1350
2912 End
2913 End
2914End
2915' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_6Б'
2916GO
2917EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_6Б'
2918GO
2919EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
2920Begin DesignProperties =
2921 Begin PaneConfigurations =
2922 Begin PaneConfiguration = 0
2923 NumPanes = 4
2924 Configuration = "(H (1[41] 4[20] 2[13] 3) )"
2925 End
2926 Begin PaneConfiguration = 1
2927 NumPanes = 3
2928 Configuration = "(H (1 [50] 4 [25] 3))"
2929 End
2930 Begin PaneConfiguration = 2
2931 NumPanes = 3
2932 Configuration = "(H (1 [50] 2 [25] 3))"
2933 End
2934 Begin PaneConfiguration = 3
2935 NumPanes = 3
2936 Configuration = "(H (4 [30] 2 [40] 3))"
2937 End
2938 Begin PaneConfiguration = 4
2939 NumPanes = 2
2940 Configuration = "(H (1 [56] 3))"
2941 End
2942 Begin PaneConfiguration = 5
2943 NumPanes = 2
2944 Configuration = "(H (2 [66] 3))"
2945 End
2946 Begin PaneConfiguration = 6
2947 NumPanes = 2
2948 Configuration = "(H (4 [50] 3))"
2949 End
2950 Begin PaneConfiguration = 7
2951 NumPanes = 1
2952 Configuration = "(V (3))"
2953 End
2954 Begin PaneConfiguration = 8
2955 NumPanes = 3
2956 Configuration = "(H (1[56] 4[18] 2) )"
2957 End
2958 Begin PaneConfiguration = 9
2959 NumPanes = 2
2960 Configuration = "(H (1 [75] 4))"
2961 End
2962 Begin PaneConfiguration = 10
2963 NumPanes = 2
2964 Configuration = "(H (1[66] 2) )"
2965 End
2966 Begin PaneConfiguration = 11
2967 NumPanes = 2
2968 Configuration = "(H (4 [60] 2))"
2969 End
2970 Begin PaneConfiguration = 12
2971 NumPanes = 1
2972 Configuration = "(H (1) )"
2973 End
2974 Begin PaneConfiguration = 13
2975 NumPanes = 1
2976 Configuration = "(V (4))"
2977 End
2978 Begin PaneConfiguration = 14
2979 NumPanes = 1
2980 Configuration = "(V (2))"
2981 End
2982 ActivePaneConfig = 0
2983 End
2984 Begin DiagramPane =
2985 Begin Origin =
2986 Top = 0
2987 Left = 0
2988 End
2989 Begin Tables =
2990 Begin Table = "Exam"
2991 Begin Extent =
2992 Top = 6
2993 Left = 38
2994 Bottom = 185
2995 Right = 208
2996 End
2997 DisplayFlags = 280
2998 TopColumn = 0
2999 End
3000 Begin Table = "Student"
3001 Begin Extent =
3002 Top = 6
3003 Left = 246
3004 Bottom = 175
3005 Right = 416
3006 End
3007 DisplayFlags = 280
3008 TopColumn = 0
3009 End
3010 End
3011 End
3012 Begin SQLPane =
3013 End
3014 Begin DataPane =
3015 Begin ParameterDefaults = ""
3016 End
3017 Begin ColumnWidths = 9
3018 Width = 284
3019 Width = 1500
3020 Width = 1500
3021 Width = 1500
3022 Width = 1500
3023 Width = 1500
3024 Width = 1500
3025 Width = 1500
3026 Width = 1500
3027 End
3028 End
3029 Begin CriteriaPane =
3030 Begin ColumnWidths = 12
3031 Column = 1440
3032 Alias = 900
3033 Table = 1170
3034 Output = 720
3035 Append = 1400
3036 NewValue = 1170
3037 SortType = 1350
3038 SortOrder = 1410
3039 GroupBy = 1350
3040 Filter = 3645
3041 Or = 1350
3042 Or = 1350
3043 Or = 1350
3044 End
3045 End
3046End
3047' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_7А'
3048GO
3049EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_7А'
3050GO
3051EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3052Begin DesignProperties =
3053 Begin PaneConfigurations =
3054 Begin PaneConfiguration = 0
3055 NumPanes = 4
3056 Configuration = "(H (1[40] 4[20] 2[20] 3) )"
3057 End
3058 Begin PaneConfiguration = 1
3059 NumPanes = 3
3060 Configuration = "(H (1 [50] 4 [25] 3))"
3061 End
3062 Begin PaneConfiguration = 2
3063 NumPanes = 3
3064 Configuration = "(H (1 [50] 2 [25] 3))"
3065 End
3066 Begin PaneConfiguration = 3
3067 NumPanes = 3
3068 Configuration = "(H (4 [30] 2 [40] 3))"
3069 End
3070 Begin PaneConfiguration = 4
3071 NumPanes = 2
3072 Configuration = "(H (1 [56] 3))"
3073 End
3074 Begin PaneConfiguration = 5
3075 NumPanes = 2
3076 Configuration = "(H (2 [66] 3))"
3077 End
3078 Begin PaneConfiguration = 6
3079 NumPanes = 2
3080 Configuration = "(H (4 [50] 3))"
3081 End
3082 Begin PaneConfiguration = 7
3083 NumPanes = 1
3084 Configuration = "(V (3))"
3085 End
3086 Begin PaneConfiguration = 8
3087 NumPanes = 3
3088 Configuration = "(H (1[56] 4[18] 2) )"
3089 End
3090 Begin PaneConfiguration = 9
3091 NumPanes = 2
3092 Configuration = "(H (1 [75] 4))"
3093 End
3094 Begin PaneConfiguration = 10
3095 NumPanes = 2
3096 Configuration = "(H (1[66] 2) )"
3097 End
3098 Begin PaneConfiguration = 11
3099 NumPanes = 2
3100 Configuration = "(H (4 [60] 2))"
3101 End
3102 Begin PaneConfiguration = 12
3103 NumPanes = 1
3104 Configuration = "(H (1) )"
3105 End
3106 Begin PaneConfiguration = 13
3107 NumPanes = 1
3108 Configuration = "(V (4))"
3109 End
3110 Begin PaneConfiguration = 14
3111 NumPanes = 1
3112 Configuration = "(V (2))"
3113 End
3114 ActivePaneConfig = 0
3115 End
3116 Begin DiagramPane =
3117 Begin Origin =
3118 Top = 0
3119 Left = 0
3120 End
3121 Begin Tables =
3122 Begin Table = "3_7А"
3123 Begin Extent =
3124 Top = 6
3125 Left = 38
3126 Bottom = 136
3127 Right = 224
3128 End
3129 DisplayFlags = 280
3130 TopColumn = 0
3131 End
3132 End
3133 End
3134 Begin SQLPane =
3135 End
3136 Begin DataPane =
3137 Begin ParameterDefaults = ""
3138 End
3139 Begin ColumnWidths = 9
3140 Width = 284
3141 Width = 1500
3142 Width = 1980
3143 Width = 1500
3144 Width = 1500
3145 Width = 1500
3146 Width = 1500
3147 Width = 1500
3148 Width = 1500
3149 End
3150 End
3151 Begin CriteriaPane =
3152 Begin ColumnWidths = 12
3153 Column = 1440
3154 Alias = 900
3155 Table = 1170
3156 Output = 720
3157 Append = 1400
3158 NewValue = 1170
3159 SortType = 1350
3160 SortOrder = 1410
3161 GroupBy = 1350
3162 Filter = 1350
3163 Or = 1350
3164 Or = 1350
3165 Or = 1350
3166 End
3167 End
3168End
3169' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_7Б'
3170GO
3171EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_7Б'
3172GO
3173EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3174Begin DesignProperties =
3175 Begin PaneConfigurations =
3176 Begin PaneConfiguration = 0
3177 NumPanes = 4
3178 Configuration = "(H (1[42] 4[20] 2[14] 3) )"
3179 End
3180 Begin PaneConfiguration = 1
3181 NumPanes = 3
3182 Configuration = "(H (1 [50] 4 [25] 3))"
3183 End
3184 Begin PaneConfiguration = 2
3185 NumPanes = 3
3186 Configuration = "(H (1 [50] 2 [25] 3))"
3187 End
3188 Begin PaneConfiguration = 3
3189 NumPanes = 3
3190 Configuration = "(H (4 [30] 2 [40] 3))"
3191 End
3192 Begin PaneConfiguration = 4
3193 NumPanes = 2
3194 Configuration = "(H (1 [56] 3))"
3195 End
3196 Begin PaneConfiguration = 5
3197 NumPanes = 2
3198 Configuration = "(H (2 [66] 3))"
3199 End
3200 Begin PaneConfiguration = 6
3201 NumPanes = 2
3202 Configuration = "(H (4 [50] 3))"
3203 End
3204 Begin PaneConfiguration = 7
3205 NumPanes = 1
3206 Configuration = "(V (3))"
3207 End
3208 Begin PaneConfiguration = 8
3209 NumPanes = 3
3210 Configuration = "(H (1[56] 4[18] 2) )"
3211 End
3212 Begin PaneConfiguration = 9
3213 NumPanes = 2
3214 Configuration = "(H (1 [75] 4))"
3215 End
3216 Begin PaneConfiguration = 10
3217 NumPanes = 2
3218 Configuration = "(H (1[66] 2) )"
3219 End
3220 Begin PaneConfiguration = 11
3221 NumPanes = 2
3222 Configuration = "(H (4 [60] 2))"
3223 End
3224 Begin PaneConfiguration = 12
3225 NumPanes = 1
3226 Configuration = "(H (1) )"
3227 End
3228 Begin PaneConfiguration = 13
3229 NumPanes = 1
3230 Configuration = "(V (4))"
3231 End
3232 Begin PaneConfiguration = 14
3233 NumPanes = 1
3234 Configuration = "(V (2))"
3235 End
3236 ActivePaneConfig = 0
3237 End
3238 Begin DiagramPane =
3239 Begin Origin =
3240 Top = 0
3241 Left = 0
3242 End
3243 Begin Tables =
3244 Begin Table = "Exam"
3245 Begin Extent =
3246 Top = 7
3247 Left = 96
3248 Bottom = 247
3249 Right = 389
3250 End
3251 DisplayFlags = 280
3252 TopColumn = 0
3253 End
3254 Begin Table = "Student"
3255 Begin Extent =
3256 Top = 5
3257 Left = 550
3258 Bottom = 259
3259 Right = 815
3260 End
3261 DisplayFlags = 280
3262 TopColumn = 0
3263 End
3264 End
3265 End
3266 Begin SQLPane =
3267 End
3268 Begin DataPane =
3269 Begin ParameterDefaults = ""
3270 End
3271 Begin ColumnWidths = 9
3272 Width = 284
3273 Width = 1500
3274 Width = 1500
3275 Width = 3020
3276 Width = 1500
3277 Width = 1500
3278 Width = 1500
3279 Width = 1500
3280 Width = 1500
3281 End
3282 End
3283 Begin CriteriaPane =
3284 Begin ColumnWidths = 12
3285 Column = 1440
3286 Alias = 900
3287 Table = 1170
3288 Output = 720
3289 Append = 1400
3290 NewValue = 1170
3291 SortType = 1350
3292 SortOrder = 1410
3293 GroupBy = 1350
3294 Filter = 1350
3295 Or = 1350
3296 Or = 1350
3297 Or = 1350
3298 End
3299 End
3300End
3301' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8А'
3302GO
3303EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8А'
3304GO
3305EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3306Begin DesignProperties =
3307 Begin PaneConfigurations =
3308 Begin PaneConfiguration = 0
3309 NumPanes = 4
3310 Configuration = "(H (1[42] 4[14] 2[15] 3) )"
3311 End
3312 Begin PaneConfiguration = 1
3313 NumPanes = 3
3314 Configuration = "(H (1 [50] 4 [25] 3))"
3315 End
3316 Begin PaneConfiguration = 2
3317 NumPanes = 3
3318 Configuration = "(H (1 [50] 2 [25] 3))"
3319 End
3320 Begin PaneConfiguration = 3
3321 NumPanes = 3
3322 Configuration = "(H (4 [30] 2 [40] 3))"
3323 End
3324 Begin PaneConfiguration = 4
3325 NumPanes = 2
3326 Configuration = "(H (1 [56] 3))"
3327 End
3328 Begin PaneConfiguration = 5
3329 NumPanes = 2
3330 Configuration = "(H (2 [66] 3))"
3331 End
3332 Begin PaneConfiguration = 6
3333 NumPanes = 2
3334 Configuration = "(H (4 [50] 3))"
3335 End
3336 Begin PaneConfiguration = 7
3337 NumPanes = 1
3338 Configuration = "(V (3))"
3339 End
3340 Begin PaneConfiguration = 8
3341 NumPanes = 3
3342 Configuration = "(H (1[56] 4[18] 2) )"
3343 End
3344 Begin PaneConfiguration = 9
3345 NumPanes = 2
3346 Configuration = "(H (1 [75] 4))"
3347 End
3348 Begin PaneConfiguration = 10
3349 NumPanes = 2
3350 Configuration = "(H (1[66] 2) )"
3351 End
3352 Begin PaneConfiguration = 11
3353 NumPanes = 2
3354 Configuration = "(H (4 [60] 2))"
3355 End
3356 Begin PaneConfiguration = 12
3357 NumPanes = 1
3358 Configuration = "(H (1) )"
3359 End
3360 Begin PaneConfiguration = 13
3361 NumPanes = 1
3362 Configuration = "(V (4))"
3363 End
3364 Begin PaneConfiguration = 14
3365 NumPanes = 1
3366 Configuration = "(V (2))"
3367 End
3368 ActivePaneConfig = 0
3369 End
3370 Begin DiagramPane =
3371 Begin Origin =
3372 Top = 0
3373 Left = 0
3374 End
3375 Begin Tables =
3376 Begin Table = "Student"
3377 Begin Extent =
3378 Top = 6
3379 Left = 38
3380 Bottom = 265
3381 Right = 384
3382 End
3383 DisplayFlags = 280
3384 TopColumn = 0
3385 End
3386 End
3387 End
3388 Begin SQLPane =
3389 End
3390 Begin DataPane =
3391 Begin ParameterDefaults = ""
3392 End
3393 Begin ColumnWidths = 9
3394 Width = 284
3395 Width = 1500
3396 Width = 2520
3397 Width = 1500
3398 Width = 1500
3399 Width = 1500
3400 Width = 1500
3401 Width = 1500
3402 Width = 1500
3403 End
3404 End
3405 Begin CriteriaPane =
3406 Begin ColumnWidths = 12
3407 Column = 1440
3408 Alias = 2480
3409 Table = 1170
3410 Output = 720
3411 Append = 1400
3412 NewValue = 1170
3413 SortType = 1350
3414 SortOrder = 1410
3415 GroupBy = 1350
3416 Filter = 1350
3417 Or = 1350
3418 Or = 1350
3419 Or = 1350
3420 End
3421 End
3422End
3423' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8Б'
3424GO
3425EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8Б'
3426GO
3427EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3428Begin DesignProperties =
3429 Begin PaneConfigurations =
3430 Begin PaneConfiguration = 0
3431 NumPanes = 4
3432 Configuration = "(H (1[41] 4[20] 2[11] 3) )"
3433 End
3434 Begin PaneConfiguration = 1
3435 NumPanes = 3
3436 Configuration = "(H (1 [50] 4 [25] 3))"
3437 End
3438 Begin PaneConfiguration = 2
3439 NumPanes = 3
3440 Configuration = "(H (1 [50] 2 [25] 3))"
3441 End
3442 Begin PaneConfiguration = 3
3443 NumPanes = 3
3444 Configuration = "(H (4 [30] 2 [40] 3))"
3445 End
3446 Begin PaneConfiguration = 4
3447 NumPanes = 2
3448 Configuration = "(H (1 [56] 3))"
3449 End
3450 Begin PaneConfiguration = 5
3451 NumPanes = 2
3452 Configuration = "(H (2 [66] 3))"
3453 End
3454 Begin PaneConfiguration = 6
3455 NumPanes = 2
3456 Configuration = "(H (4 [50] 3))"
3457 End
3458 Begin PaneConfiguration = 7
3459 NumPanes = 1
3460 Configuration = "(V (3))"
3461 End
3462 Begin PaneConfiguration = 8
3463 NumPanes = 3
3464 Configuration = "(H (1[56] 4[18] 2) )"
3465 End
3466 Begin PaneConfiguration = 9
3467 NumPanes = 2
3468 Configuration = "(H (1 [75] 4))"
3469 End
3470 Begin PaneConfiguration = 10
3471 NumPanes = 2
3472 Configuration = "(H (1[66] 2) )"
3473 End
3474 Begin PaneConfiguration = 11
3475 NumPanes = 2
3476 Configuration = "(H (4 [60] 2))"
3477 End
3478 Begin PaneConfiguration = 12
3479 NumPanes = 1
3480 Configuration = "(H (1) )"
3481 End
3482 Begin PaneConfiguration = 13
3483 NumPanes = 1
3484 Configuration = "(V (4))"
3485 End
3486 Begin PaneConfiguration = 14
3487 NumPanes = 1
3488 Configuration = "(V (2))"
3489 End
3490 ActivePaneConfig = 0
3491 End
3492 Begin DiagramPane =
3493 Begin Origin =
3494 Top = 0
3495 Left = 0
3496 End
3497 Begin Tables =
3498 Begin Table = "3_8А"
3499 Begin Extent =
3500 Top = 36
3501 Left = 57
3502 Bottom = 221
3503 Right = 401
3504 End
3505 DisplayFlags = 280
3506 TopColumn = 0
3507 End
3508 Begin Table = "3_8Б"
3509 Begin Extent =
3510 Top = 46
3511 Left = 498
3512 Bottom = 189
3513 Right = 783
3514 End
3515 DisplayFlags = 280
3516 TopColumn = 0
3517 End
3518 End
3519 End
3520 Begin SQLPane =
3521 End
3522 Begin DataPane =
3523 Begin ParameterDefaults = ""
3524 End
3525 Begin ColumnWidths = 9
3526 Width = 284
3527 Width = 1500
3528 Width = 2940
3529 Width = 2900
3530 Width = 1790
3531 Width = 1500
3532 Width = 1500
3533 Width = 1500
3534 Width = 1500
3535 End
3536 End
3537 Begin CriteriaPane =
3538 Begin ColumnWidths = 11
3539 Column = 7260
3540 Alias = 1070
3541 Table = 1170
3542 Output = 720
3543 Append = 1400
3544 NewValue = 1170
3545 SortType = 1350
3546 SortOrder = 1410
3547 GroupBy = 1350
3548 Filter = 1350
3549 Or = 1350
3550 Or = 1350
3551 Or = 1350
3552 End
3553 End
3554End
3555' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8В'
3556GO
3557EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_8В'
3558GO
3559EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3560Begin DesignProperties =
3561 Begin PaneConfigurations =
3562 Begin PaneConfiguration = 0
3563 NumPanes = 4
3564 Configuration = "(H (1[42] 4[20] 2[13] 3) )"
3565 End
3566 Begin PaneConfiguration = 1
3567 NumPanes = 3
3568 Configuration = "(H (1 [50] 4 [25] 3))"
3569 End
3570 Begin PaneConfiguration = 2
3571 NumPanes = 3
3572 Configuration = "(H (1 [50] 2 [25] 3))"
3573 End
3574 Begin PaneConfiguration = 3
3575 NumPanes = 3
3576 Configuration = "(H (4 [30] 2 [40] 3))"
3577 End
3578 Begin PaneConfiguration = 4
3579 NumPanes = 2
3580 Configuration = "(H (1 [56] 3))"
3581 End
3582 Begin PaneConfiguration = 5
3583 NumPanes = 2
3584 Configuration = "(H (2 [66] 3))"
3585 End
3586 Begin PaneConfiguration = 6
3587 NumPanes = 2
3588 Configuration = "(H (4 [50] 3))"
3589 End
3590 Begin PaneConfiguration = 7
3591 NumPanes = 1
3592 Configuration = "(V (3))"
3593 End
3594 Begin PaneConfiguration = 8
3595 NumPanes = 3
3596 Configuration = "(H (1[56] 4[18] 2) )"
3597 End
3598 Begin PaneConfiguration = 9
3599 NumPanes = 2
3600 Configuration = "(H (1 [75] 4))"
3601 End
3602 Begin PaneConfiguration = 10
3603 NumPanes = 2
3604 Configuration = "(H (1[66] 2) )"
3605 End
3606 Begin PaneConfiguration = 11
3607 NumPanes = 2
3608 Configuration = "(H (4 [60] 2))"
3609 End
3610 Begin PaneConfiguration = 12
3611 NumPanes = 1
3612 Configuration = "(H (1) )"
3613 End
3614 Begin PaneConfiguration = 13
3615 NumPanes = 1
3616 Configuration = "(V (4))"
3617 End
3618 Begin PaneConfiguration = 14
3619 NumPanes = 1
3620 Configuration = "(V (2))"
3621 End
3622 ActivePaneConfig = 0
3623 End
3624 Begin DiagramPane =
3625 Begin Origin =
3626 Top = 0
3627 Left = 0
3628 End
3629 Begin Tables =
3630 Begin Table = "Student"
3631 Begin Extent =
3632 Top = 6
3633 Left = 38
3634 Bottom = 177
3635 Right = 208
3636 End
3637 DisplayFlags = 280
3638 TopColumn = 0
3639 End
3640 Begin Table = "StudGroup"
3641 Begin Extent =
3642 Top = 14
3643 Left = 254
3644 Bottom = 143
3645 Right = 424
3646 End
3647 DisplayFlags = 280
3648 TopColumn = 0
3649 End
3650 End
3651 End
3652 Begin SQLPane =
3653 End
3654 Begin DataPane =
3655 Begin ParameterDefaults = ""
3656 End
3657 Begin ColumnWidths = 9
3658 Width = 284
3659 Width = 1500
3660 Width = 1500
3661 Width = 1500
3662 Width = 1500
3663 Width = 1500
3664 Width = 1500
3665 Width = 1500
3666 Width = 1500
3667 End
3668 End
3669 Begin CriteriaPane =
3670 Begin ColumnWidths = 12
3671 Column = 1440
3672 Alias = 900
3673 Table = 1170
3674 Output = 720
3675 Append = 1400
3676 NewValue = 1170
3677 SortType = 1350
3678 SortOrder = 1410
3679 GroupBy = 1350
3680 Filter = 1350
3681 Or = 1350
3682 Or = 1350
3683 Or = 1350
3684 End
3685 End
3686End
3687' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_9А'
3688GO
3689EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_9А'
3690GO
3691EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3692Begin DesignProperties =
3693 Begin PaneConfigurations =
3694 Begin PaneConfiguration = 0
3695 NumPanes = 4
3696 Configuration = "(H (1[41] 4[20] 2[11] 3) )"
3697 End
3698 Begin PaneConfiguration = 1
3699 NumPanes = 3
3700 Configuration = "(H (1 [50] 4 [25] 3))"
3701 End
3702 Begin PaneConfiguration = 2
3703 NumPanes = 3
3704 Configuration = "(H (1 [50] 2 [25] 3))"
3705 End
3706 Begin PaneConfiguration = 3
3707 NumPanes = 3
3708 Configuration = "(H (4 [30] 2 [40] 3))"
3709 End
3710 Begin PaneConfiguration = 4
3711 NumPanes = 2
3712 Configuration = "(H (1 [56] 3))"
3713 End
3714 Begin PaneConfiguration = 5
3715 NumPanes = 2
3716 Configuration = "(H (2 [66] 3))"
3717 End
3718 Begin PaneConfiguration = 6
3719 NumPanes = 2
3720 Configuration = "(H (4 [50] 3))"
3721 End
3722 Begin PaneConfiguration = 7
3723 NumPanes = 1
3724 Configuration = "(V (3))"
3725 End
3726 Begin PaneConfiguration = 8
3727 NumPanes = 3
3728 Configuration = "(H (1[56] 4[18] 2) )"
3729 End
3730 Begin PaneConfiguration = 9
3731 NumPanes = 2
3732 Configuration = "(H (1 [75] 4))"
3733 End
3734 Begin PaneConfiguration = 10
3735 NumPanes = 2
3736 Configuration = "(H (1[66] 2) )"
3737 End
3738 Begin PaneConfiguration = 11
3739 NumPanes = 2
3740 Configuration = "(H (4 [60] 2))"
3741 End
3742 Begin PaneConfiguration = 12
3743 NumPanes = 1
3744 Configuration = "(H (1) )"
3745 End
3746 Begin PaneConfiguration = 13
3747 NumPanes = 1
3748 Configuration = "(V (4))"
3749 End
3750 Begin PaneConfiguration = 14
3751 NumPanes = 1
3752 Configuration = "(V (2))"
3753 End
3754 ActivePaneConfig = 0
3755 End
3756 Begin DiagramPane =
3757 Begin Origin =
3758 Top = 0
3759 Left = 0
3760 End
3761 Begin Tables =
3762 Begin Table = "3_9А"
3763 Begin Extent =
3764 Top = 6
3765 Left = 38
3766 Bottom = 102
3767 Right = 224
3768 End
3769 DisplayFlags = 280
3770 TopColumn = 0
3771 End
3772 Begin Table = "Student"
3773 Begin Extent =
3774 Top = 6
3775 Left = 384
3776 Bottom = 170
3777 Right = 554
3778 End
3779 DisplayFlags = 280
3780 TopColumn = 0
3781 End
3782 Begin Table = "Exam"
3783 Begin Extent =
3784 Top = 12
3785 Left = 645
3786 Bottom = 179
3787 Right = 814
3788 End
3789 DisplayFlags = 280
3790 TopColumn = 0
3791 End
3792 End
3793 End
3794 Begin SQLPane =
3795 End
3796 Begin DataPane =
3797 Begin ParameterDefaults = ""
3798 End
3799 Begin ColumnWidths = 9
3800 Width = 284
3801 Width = 1500
3802 Width = 1500
3803 Width = 1500
3804 Width = 1500
3805 Width = 1500
3806 Width = 1500
3807 Width = 1500
3808 Width = 1500
3809 End
3810 End
3811 Begin CriteriaPane =
3812 Begin ColumnWidths = 12
3813 Column = 1440
3814 Alias = 900
3815 Table = 1170
3816 Output = 720
3817 Append = 1400
3818 NewValue = 1170
3819 SortType = 1350
3820 SortOrder = 1410
3821 GroupBy = 1350
3822 Filter = 1350
3823 Or = 1350
3824 Or = 1350
3825 Or = 1350
3826 End
3827 End
3828End
3829' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_9Б'
3830GO
3831EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'3_9Б'
3832GO
3833EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3834Begin DesignProperties =
3835 Begin PaneConfigurations =
3836 Begin PaneConfiguration = 0
3837 NumPanes = 4
3838 Configuration = "(H (1[42] 4[29] 2[2] 3) )"
3839 End
3840 Begin PaneConfiguration = 1
3841 NumPanes = 3
3842 Configuration = "(H (1 [50] 4 [25] 3))"
3843 End
3844 Begin PaneConfiguration = 2
3845 NumPanes = 3
3846 Configuration = "(H (1 [50] 2 [25] 3))"
3847 End
3848 Begin PaneConfiguration = 3
3849 NumPanes = 3
3850 Configuration = "(H (4 [30] 2 [40] 3))"
3851 End
3852 Begin PaneConfiguration = 4
3853 NumPanes = 2
3854 Configuration = "(H (1 [56] 3))"
3855 End
3856 Begin PaneConfiguration = 5
3857 NumPanes = 2
3858 Configuration = "(H (2 [66] 3))"
3859 End
3860 Begin PaneConfiguration = 6
3861 NumPanes = 2
3862 Configuration = "(H (4 [50] 3))"
3863 End
3864 Begin PaneConfiguration = 7
3865 NumPanes = 1
3866 Configuration = "(V (3))"
3867 End
3868 Begin PaneConfiguration = 8
3869 NumPanes = 3
3870 Configuration = "(H (1[56] 4[18] 2) )"
3871 End
3872 Begin PaneConfiguration = 9
3873 NumPanes = 2
3874 Configuration = "(H (1 [75] 4))"
3875 End
3876 Begin PaneConfiguration = 10
3877 NumPanes = 2
3878 Configuration = "(H (1[66] 2) )"
3879 End
3880 Begin PaneConfiguration = 11
3881 NumPanes = 2
3882 Configuration = "(H (4 [60] 2))"
3883 End
3884 Begin PaneConfiguration = 12
3885 NumPanes = 1
3886 Configuration = "(H (1) )"
3887 End
3888 Begin PaneConfiguration = 13
3889 NumPanes = 1
3890 Configuration = "(V (4))"
3891 End
3892 Begin PaneConfiguration = 14
3893 NumPanes = 1
3894 Configuration = "(V (2))"
3895 End
3896 ActivePaneConfig = 0
3897 End
3898 Begin DiagramPane =
3899 Begin Origin =
3900 Top = 0
3901 Left = 0
3902 End
3903 Begin Tables =
3904 Begin Table = "ListOfGroup"
3905 Begin Extent =
3906 Top = 53
3907 Left = 168
3908 Bottom = 258
3909 Right = 416
3910 End
3911 DisplayFlags = 280
3912 TopColumn = 0
3913 End
3914 Begin Table = "Exam"
3915 Begin Extent =
3916 Top = 51
3917 Left = 560
3918 Bottom = 293
3919 Right = 828
3920 End
3921 DisplayFlags = 280
3922 TopColumn = 0
3923 End
3924 End
3925 End
3926 Begin SQLPane =
3927 End
3928 Begin DataPane =
3929 Begin ParameterDefaults = ""
3930 End
3931 Begin ColumnWidths = 9
3932 Width = 284
3933 Width = 1500
3934 Width = 1500
3935 Width = 1500
3936 Width = 1500
3937 Width = 1500
3938 Width = 1500
3939 Width = 1500
3940 Width = 1500
3941 End
3942 End
3943 Begin CriteriaPane =
3944 Begin ColumnWidths = 12
3945 Column = 1860
3946 Alias = 1580
3947 Table = 1170
3948 Output = 720
3949 Append = 1400
3950 NewValue = 1170
3951 SortType = 1350
3952 SortOrder = 1410
3953 GroupBy = 1350
3954 Filter = 1350
3955 Or = 1350
3956 Or = 1350
3957 Or = 1350
3958 End
3959 End
3960End
3961' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Exam_A-12-01'
3962GO
3963EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Exam_A-12-01'
3964GO
3965EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
3966Begin DesignProperties =
3967 Begin PaneConfigurations =
3968 Begin PaneConfiguration = 0
3969 NumPanes = 4
3970 Configuration = "(H (1[41] 4[22] 2[18] 3) )"
3971 End
3972 Begin PaneConfiguration = 1
3973 NumPanes = 3
3974 Configuration = "(H (1 [50] 4 [25] 3))"
3975 End
3976 Begin PaneConfiguration = 2
3977 NumPanes = 3
3978 Configuration = "(H (1 [50] 2 [25] 3))"
3979 End
3980 Begin PaneConfiguration = 3
3981 NumPanes = 3
3982 Configuration = "(H (4 [30] 2 [40] 3))"
3983 End
3984 Begin PaneConfiguration = 4
3985 NumPanes = 2
3986 Configuration = "(H (1 [56] 3))"
3987 End
3988 Begin PaneConfiguration = 5
3989 NumPanes = 2
3990 Configuration = "(H (2 [66] 3))"
3991 End
3992 Begin PaneConfiguration = 6
3993 NumPanes = 2
3994 Configuration = "(H (4 [50] 3))"
3995 End
3996 Begin PaneConfiguration = 7
3997 NumPanes = 1
3998 Configuration = "(V (3))"
3999 End
4000 Begin PaneConfiguration = 8
4001 NumPanes = 3
4002 Configuration = "(H (1[56] 4[18] 2) )"
4003 End
4004 Begin PaneConfiguration = 9
4005 NumPanes = 2
4006 Configuration = "(H (1 [75] 4))"
4007 End
4008 Begin PaneConfiguration = 10
4009 NumPanes = 2
4010 Configuration = "(H (1[66] 2) )"
4011 End
4012 Begin PaneConfiguration = 11
4013 NumPanes = 2
4014 Configuration = "(H (4 [60] 2))"
4015 End
4016 Begin PaneConfiguration = 12
4017 NumPanes = 1
4018 Configuration = "(H (1) )"
4019 End
4020 Begin PaneConfiguration = 13
4021 NumPanes = 1
4022 Configuration = "(V (4))"
4023 End
4024 Begin PaneConfiguration = 14
4025 NumPanes = 1
4026 Configuration = "(V (2))"
4027 End
4028 ActivePaneConfig = 0
4029 End
4030 Begin DiagramPane =
4031 Begin Origin =
4032 Top = 0
4033 Left = 0
4034 End
4035 Begin Tables =
4036 Begin Table = "Lecturer"
4037 Begin Extent =
4038 Top = 32
4039 Left = 324
4040 Bottom = 245
4041 Right = 605
4042 End
4043 DisplayFlags = 280
4044 TopColumn = 0
4045 End
4046 End
4047 End
4048 Begin SQLPane =
4049 End
4050 Begin DataPane =
4051 Begin ParameterDefaults = ""
4052 End
4053 Begin ColumnWidths = 9
4054 Width = 284
4055 Width = 1500
4056 Width = 1500
4057 Width = 1500
4058 Width = 1500
4059 Width = 1500
4060 Width = 1500
4061 Width = 1500
4062 Width = 1500
4063 End
4064 End
4065 Begin CriteriaPane =
4066 Begin ColumnWidths = 11
4067 Column = 1440
4068 Alias = 900
4069 Table = 1170
4070 Output = 720
4071 Append = 1400
4072 NewValue = 1170
4073 SortType = 1350
4074 SortOrder = 1410
4075 GroupBy = 1350
4076 Filter = 4130
4077 Or = 1350
4078 Or = 1350
4079 Or = 1350
4080 End
4081 End
4082End
4083' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'LectExam'
4084GO
4085EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'LectExam'
4086GO
4087EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
4088Begin DesignProperties =
4089 Begin PaneConfigurations =
4090 Begin PaneConfiguration = 0
4091 NumPanes = 4
4092 Configuration = "(H (1[39] 4[23] 2[15] 3) )"
4093 End
4094 Begin PaneConfiguration = 1
4095 NumPanes = 3
4096 Configuration = "(H (1 [50] 4 [25] 3))"
4097 End
4098 Begin PaneConfiguration = 2
4099 NumPanes = 3
4100 Configuration = "(H (1 [50] 2 [25] 3))"
4101 End
4102 Begin PaneConfiguration = 3
4103 NumPanes = 3
4104 Configuration = "(H (4 [30] 2 [40] 3))"
4105 End
4106 Begin PaneConfiguration = 4
4107 NumPanes = 2
4108 Configuration = "(H (1 [56] 3))"
4109 End
4110 Begin PaneConfiguration = 5
4111 NumPanes = 2
4112 Configuration = "(H (2 [66] 3))"
4113 End
4114 Begin PaneConfiguration = 6
4115 NumPanes = 2
4116 Configuration = "(H (4 [50] 3))"
4117 End
4118 Begin PaneConfiguration = 7
4119 NumPanes = 1
4120 Configuration = "(V (3))"
4121 End
4122 Begin PaneConfiguration = 8
4123 NumPanes = 3
4124 Configuration = "(H (1[56] 4[18] 2) )"
4125 End
4126 Begin PaneConfiguration = 9
4127 NumPanes = 2
4128 Configuration = "(H (1 [75] 4))"
4129 End
4130 Begin PaneConfiguration = 10
4131 NumPanes = 2
4132 Configuration = "(H (1[66] 2) )"
4133 End
4134 Begin PaneConfiguration = 11
4135 NumPanes = 2
4136 Configuration = "(H (4 [60] 2))"
4137 End
4138 Begin PaneConfiguration = 12
4139 NumPanes = 1
4140 Configuration = "(H (1) )"
4141 End
4142 Begin PaneConfiguration = 13
4143 NumPanes = 1
4144 Configuration = "(V (4))"
4145 End
4146 Begin PaneConfiguration = 14
4147 NumPanes = 1
4148 Configuration = "(V (2))"
4149 End
4150 ActivePaneConfig = 0
4151 End
4152 Begin DiagramPane =
4153 Begin Origin =
4154 Top = 0
4155 Left = 0
4156 End
4157 Begin Tables =
4158 Begin Table = "Student"
4159 Begin Extent =
4160 Top = 30
4161 Left = 262
4162 Bottom = 297
4163 Right = 508
4164 End
4165 DisplayFlags = 280
4166 TopColumn = 0
4167 End
4168 End
4169 End
4170 Begin SQLPane =
4171 End
4172 Begin DataPane =
4173 Begin ParameterDefaults = ""
4174 End
4175 Begin ColumnWidths = 9
4176 Width = 284
4177 Width = 1500
4178 Width = 1500
4179 Width = 1500
4180 Width = 1500
4181 Width = 1500
4182 Width = 1500
4183 Width = 1500
4184 Width = 1500
4185 End
4186 End
4187 Begin CriteriaPane =
4188 Begin ColumnWidths = 11
4189 Column = 1440
4190 Alias = 1880
4191 Table = 1170
4192 Output = 720
4193 Append = 1400
4194 NewValue = 1170
4195 SortType = 1350
4196 SortOrder = 1410
4197 GroupBy = 1350
4198 Filter = 1350
4199 Or = 1350
4200 Or = 1350
4201 Or = 1350
4202 End
4203 End
4204End
4205' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ListOfGroup'
4206GO
4207EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ListOfGroup'
4208GO
4209USE [master]
4210GO
4211ALTER DATABASE [Shakhovtsev] SET READ_WRITE
4212GO