Базы данных и знаний. Мартьянова А.Е. - 116 стр.

UptoLike

ВУЗ: 

АГТУ | Астрахань

Составители: 

Рубрика: 

Мартьянова А.Е. Базы данных и знаний 116
WHERE DISCIPLINE.CodeDiscipline=STUDYING.CodeDiscipline And
GROUP_.CodeGroup=STUDENT.CodeGroup And
ADVA
G.KindOfReport =
meGroup, STUDENT.NumberTestBook, STUDENT.Surname,
T.Name, STUDENT.Patronymic, DISCIPLINE.NameDiscipline,
e, TEACHER.Patronymic
e;
предназначен для формирования экза-
:
ELECT DISCIPLINE.NameDiscipline, GROUP_.NameGroup,
STUDYING.KindOfReport,
NT.Surname, STUDENT.Name,
ic, ADVANCED.Rating, ADVANCED.DateOfReport
DVANCED, DISCIPLINE, GROUP_, STUDENT, STUDYING, TEACHER
_.CodeGroup=STUDENT.CodeGroup And
udent=STUDENT.CodeStudent And
And
NG.CodeTeacher=TEACHER.CodeTeacher
SCIPLINE.NameDiscipline, GROUP_.NameGroup,
.NumberOfSemester, STUDYING.KindOfReport, STUDENT.Surname;
нию
типы команд языка SQL (DDL, DML, DCL,
ка DQL (Data Query Language).
пример использования оператора SELECT в за-
4. С какой целью используется Query Builder?
Опишите порядок построения запроса с помощью Query
Build
значение полей Tables, Fields to Show:
, Field
By, Order By, Top N Value:,
eria, Or into Criteria, List Possible
NCED.CodeStudent=STUDENT.CodeStudent And
ADVANCED.CodeStudying=STUDYING.CodeStudying And
STUDYING.CodeTeacher=TEACHER.CodeTeacher And STUDYIN
'exam.'
GROUP BY GROUP_.Na
STUDEN
TEACHER.Surname, TEACHER.Nam
ORDER BY STUDENT.Surnam
Запрос «ExaminationSheet»
нной ведомостименацио
S
STUDYING.NumberOfSemester,
berTestBook, STUDESTUDENT.Num
T.PatronymSTUDEN
ROM AF
WHERE GROUP
ADVANCED.CodeSt
ADVANCED.CodeStudying=STUDYING.CodeStudying
NE.CodeDiscipline=STUDYING.CodeDiscipline AndDISCIPLI
TUDYIS
ORDER BY DI
STUDYING
КОНТРОЛЬНЫЕ ВОПРОСЫ к зада
1. Перечислите
DQL).
2. Опишите назначение язы
3. Приведите
просе.
5.
er.
6. Опишите назначение кнопки Set Table Joins построителя
Query Builder.
7. Опишите на
Name, Operator:, Value Criteria:, Group
Top Percent и кнопок And into Crit
ry Builder. Values построителя Que
116
116                                 Мартьянова А.Е. Базы данных и знаний


WHERE        DISCIPLINE.CodeDiscipline=STUDYING.CodeDiscipline     And
GROUP_.CodeGroup=STUDENT.CodeGroup                                 And
ADVANCED.CodeStudent=STUDENT.CodeStudent                           And
ADVANCED.CodeStudying=STUDYING.CodeStudying                        And
STUDYING.CodeTeacher=TEACHER.CodeTeacher And STUDYING.KindOfReport =
'exam.'
GROUP BY GROUP_.NameGroup, STUDENT.NumberTestBook, STUDENT.Surname,
STUDENT.Name,        STUDENT.Patronymic,      DISCIPLINE.NameDiscipline,
TEACHER.Surname, TEACHER.Name, TEACHER.Patronymic
ORDER BY STUDENT.Surname;
     Запрос «ExaminationSheet» предназначен для формирования экза-
менационной ведомости:
SELECT            DISCIPLINE.NameDiscipline,          GROUP_.NameGroup,
STUDYING.NumberOfSemester,                         STUDYING.KindOfReport,
STUDENT.NumberTestBook,          STUDENT.Surname,        STUDENT.Name,
STUDENT.Patronymic, ADVANCED.Rating, ADVANCED.DateOfReport
FROM ADVANCED, DISCIPLINE, GROUP_, STUDENT, STUDYING, TEACHER
WHERE               GROUP_.CodeGroup=STUDENT.CodeGroup              And
ADVANCED.CodeStudent=STUDENT.CodeStudent                            And
ADVANCED.CodeStudying=STUDYING.CodeStudying                         And
DISCIPLINE.CodeDiscipline=STUDYING.CodeDiscipline                   And
STUDYING.CodeTeacher=TEACHER.CodeTeacher
ORDER        BY         DISCIPLINE.NameDiscipline,    GROUP_.NameGroup,
STUDYING.NumberOfSemester, STUDYING.KindOfReport, STUDENT.Surname;



     КОНТРОЛЬНЫЕ ВОПРОСЫ к заданию
     1.    Перечислите типы команд языка SQL (DDL, DML, DCL,
DQL).
     2.    Опишите назначение языка DQL (Data Query Language).
     3.    Приведите пример использования оператора SELECT в за-
просе.
     4.    С какой целью используется Query Builder?
     5.    Опишите порядок построения запроса с помощью Query
Builder.
     6.    Опишите назначение кнопки Set Table Joins построителя
Query Builder.
     7.    Опишите назначение полей Tables, Fields to Show:, Field
Name, Operator:, Value Criteria:, Group By, Order By, Top N Value:,
Top Percent и кнопок And into Criteria, Or into Criteria, List Possible
Values построителя Query Builder.



                                   116

Страницы