СГИЛ

The database has a Courses table with the following columns: course id, course name,

of credits. Select which of the following constraints can be implemented for this table?

numberx

• 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

The Books table has the followislg 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

• title

• pages

• pages

A primary key for an entity is …

• unique attribute

• any attribute

• first row

• type of relationship

Choose the right order of the database design phases

• Subject area analysis, Conceptual Design, Logical Design, Physical Design

• Subject area analysis, Logical Design, Conceptual Design, Physical Design

• Conceptual Design, Logical Design, Physical Design, Queries Implementation

• Conceptual Design, Logical Design, Physical Design, Queries Implementation

Database is a collection of …

• data

• programs

• modules

• none of the given

DBMS stands for...

• Database

  Management

  System

• None of the given

• Database Basic Management System

• Database Administrator System

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 type of the relationship between TEACHERS and GROUPS tables.

• many (teachers)-to-many (groups)

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

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

• one (teachers)-to-one (groups)

A teacher teaches one or more subjects, each of which is taught by one or more

teachers.

Definitions of the entities are: Teachers (teacher_id, name, birthdate), Subjects (subject_id, name,

description). Identify a type of the

relationship between TEACHERS and SUBJECTS tables.

• many (teachers)-to-many (subjects)

• one (teachers)-to-one (subjects)

• > one (teachers)-to-many (subjects)

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

A teacher teaches one or more subjects, each of which is taught by one or more teachers.

Definitions of entities are: Teachers (teacher id, name, birthdate), Subjects (subject id, name,

description). Identify a table with a Foreign Key(s) for the relationship between TEACHERS and

SUBJECTS tables.

• associative table between Teachers and Subjects tables

• Teachers

• Subjects

• in the Teachers table or in the

  Subjects table - both options are

  correct