SQL 2 quiz

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 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

• title

• author

• 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, DBMS Selection

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 table with a Foreign Key(s) for the relationship between TEACHERS and GROUPS tables.

• associative table between TEACHERS and GROUPS tables

• TEACHERS

• GROUPS

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

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

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

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

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

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

Table is synonymous with the term

• Relation

• Field

• Column

• Record