SQL.

The Books table has the following columns: ISBN - unique code of the book edition, title of the book, author of the book, number of pages. Which of these columns can be the Primary key?

• ISBN

• author

• pages

• title

Select the Primary key from the following description: Groups (group_id, name, email)

• name

• email

• group_id

• name, group_id

Select the Primary key from the following description: Teachers (teacher_id, lastname, email)

• email

• teacher_id

• Teachers

• lastname

Select the Primary key from the following description: Schedule (schedule_id, course_id, teacher_id, group_id, time, room)

• schedule_id

• course_id

• teacher_id

• group_id

The database has a Courses table with the following columns: course id, course name, number of credits. Select which of the following constraints can be implemented for this table?

• the number of credits can be from 1 to 6

• books for each course should be available in the university library

• course grades must range from 0 to 100%

• courses must last 3 months

The database has a Schedule table with the following columns: schedule_id, course_id, teacher_id, group_id, time, room, day_of_week. Select which of the following constraints can be implemented for this table?

• lesson time can be from 08:00 to 22:00

• lessons should be interesting

• students must attend all lessons

• after each lesson, students must complete homework

The database has a Schedule table with the following columns: schedule_id, course_id, teacher_id, group_id, time, room, day_of_week. Select the possible query for this table.

• show group lessons by its id

• show how well students understand

• the lesson material

  show student marks by student_id

• show which course students like the most

The database has a Courses table with the following columns: course id, course name, number of credits. Select the possible query for this table.

• show the number of credits by course name

• show course description by course name

• show the most interesting courses

• show a course with a lot of homework

A teacher teaches one or more groups, each of which is taught by one or more teachers. The TEACHERS table has teacher_id, teacher_name columns. The GROUPS table has group_id, name columns. Identify a table with a Foreign Key(s) for the relationship between TEACHERS and GROUPS tables.

• TEACHERS

• GROUPS

• in the TEACHERS table or in the GROUPS table - both options are correct

• associative table between TEACHERS and GROUPS tables

A teacher may be assigned with exactly one position. A position must be assigned to one or many teachers. The TEACHERS table has teacher_id, teacher_name, birthdate columns. The POSITIONS table has position_id, position_name columns. Identify a type of the relationship between TEACHERS and POSITIONS entities.

• many (teachers)-to-many (positions)

• one (positions)-to-many (teachers)

• one (teachers)-to-many (positions)

• one (teachers)-to-one (positions)