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

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

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

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

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.

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

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.

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.

A teacher may be assigned with exactly one position. A position must be assigned to one or more teachers. The TEACHERS table has teacher_id, teacher_name, birthdate columns. The POSITIONS table has position_id, position_name columns. Identify a table with a Foreign Key(s) for the relationship between TEACHERS and POSITIONS tables.

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.

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.

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.

Entities Groups and Subjects have a many-to-many relationship type. For this reason a new associative table between them should be created - Schedule table. Definitions of tables are: Groups (group_code (PK), group_name), Subjects (subject_code (PK), subject_name, description). Identify attributes in the Schedule table.

Determine the relationship type between Courses and Teachers entities by the description: "One course can be taught by many teachers, and one teacher can teach many courses".

Determine the relationship type between Students and Groups entities by the description: "One student can be enrolled only in one group, and one group contains many students".

Determine the relationship type between Students and Readers entities by the description: "One student has only one reader's card, and one reader's card can belong to only one student".

In an ER-diagram an entity is represent by a

Select the functional dependency according to the table description: Teachers (teacher_id, last_name, department_id)

Select the functional dependency according to the table description: Courses (course_id, course_name, credits)

Select the Normal Form by the table description: Teachers (teacher_id, last_name, department_id)

Select the Normal Form by the table description: Courses (course_id, major_id, course_name, credits, major_name)

Select the Normal Form by the table description: Groups (group_id, group_name, adviser_id, adviser_last_name)

Select the Normal Form by the table description: Students (stud_id, last_name, subject_ids)

Select the functional dependency according to the table description: Students (stud_id, last_name, group_id)

Answer if the next table has a partial dependency: Courses (course_id, major_id, course_name, credits, major_name)

Answer if the next table has a partial dependency: Teachers (teacher_id, last_name, department_id)

Answer if the next table has a partial dependency: Schedule (teacher_id, group_id, course_id, time, room)

Complete the code to create the table Teachers (teach_id, last_name, depart_id (FK)): CREATE TABLE Teachers teach_id int PRIMARY KEY, last_name varchar(20), depart_id int, _______ (depart_id) REFERENCES Departments(depart_id));

Complete the code to drop the table Courses:

Complete the code to create the table Departments (dep_id, dep_name): CREATE TABLE Departments dep_id int _______, dep_name varchar(15));

Complete the code to create the table Students (stud_id, last_name): CREATE TABLE Students stud_id int, last_name varchar(20), ________ (stud_id));

Complete the code to create the table Groups (group_id, group_name): ________ Groups (group_id int PRIMARY KEY, group_name varchar(20));

The SQL command which allows to change the structure of a table is

Which of the following SQL statements can be used to create a table?

Complete the code to create the table Courses (course id, name): CREATE TABLE Courses( course_id int _______, name varchar(10));

Complete the code to create the table Departments (dep_ id, name, faculty_id), where faculty_id is a FK to the table Faculties: CREATE TABLE Departments (dep_id int PRIMARY KEY, name varchar(10), faculty_id int, ________ (faculty_id) REFERENCES Faculties(faculty_id));

Complete the code to create the table Departments (dep id, dep_name), where dep_name attribute has the not null constraint: CREATE TABLE Departments (dep_id int PRIMARY KEY, dep_name varchar(10) IS ________));

Complete the code for the following table Subjects (subj_id (PK), name, credits): UPDATE Subjects SET credits=5 _______ credits=3;

Complete the code for the following table Subjects (subj_id (PK), name, credits): _______ SET credits=credits+1;

Complete the code for the following table Faculties(facult_id (PK), name): DELETE FROM Faculties ______ facult_id=1;

Complete the code for the following table Groups(group_id (PK), name): ______ SET name='Database Design' WHERE group_id=1;

Complete the code for the following table Groups(group_id (PK), name): DELETE FROM Groups _____ group_id=1;

Complete the code for the following table Students(stud_id (PK), lastname): DELETE FROM Students WHERE _____= 1;

Complete the code: _____ Students VALUES (1,'FirstName1','LastName1','2000-01-01'1);

Complete the code: DELETE FROM Students ______ stud_id=2;

Complete the code for the following table Departments(dep_id(PK), name): UPDATE Departments _____ name='IT' WHERE depart_id=1;

Complete the code for the following table Faculties(facult_id (PK), name): ______ Faculties SET name='Information Technology' WHERE name='IT';

Rows are also called records 

Primary key must contain unique values

What is  Subject Area Analysis?

Database is an organized collection of data, stored and accessed electronically.   

Tables are also called relations

The database has a Students table with the following columns: student_id, first_name, last_name, iin, email, phone_number. Select which of the following constraints cannot be implemented for this table?

Primary key can be empty

Rows are also called  tuples   

Primary key is a column in a table which uniquely identifies each row in a table

Columns are also called attributes

What is Relational database? 

Define incorrect answer.

The University database contains Teachers and Advisors tables. Usually teachers and advisors are different people, but some of them may hold 2 positions and, as a result, will be recorded in both tables. The Teachers table contains teach_id (PK), last_name, first_name attributes, while the Advisors table contains adv_id (PK), last_name, first name attributes. Which operator (command) can be used to obtain a list of only teachers - excluding those people who occupy 2 positions at the same time?

Complete the code to get all columns from the table: SELECT ___ FROM Groups;

The University database contains Teachers and Advisors tables. Usually teachers and advisors are different people, but some of them may hold 2 positions and, as a result, will be recorded in both tables. The Teachers table contains teach_id (PK), last_name, first_name attributes, while the Advisors table contains adv_id (PK), last_name, first_name attributes. Which operator (command) can be used to obtain a list of only those people who occupy 2 positions at the same time?

The University database contains Students and Groups tables. The Students table contains stud_id (PK), first_name, last_name, group_id (FK to the Groups table). The Groups table contains group_id (PK), name. Which of the following commands will list the names of students and the names of their groups? Only those students who are already enrolled in groups should be included in the list.

The University database contains Teachers and Advisors tables. Usually teachers and advisors are different people, but some of them may hold 2 positions and, as a result, will be recorded in both tables. The Teachers table contains teach_id (PK), last_name, first_name attributes, while the Advisors table contains adv_id (PK), last_name, first_name attributes. Which operator (command) can be used to obtain a general list of all teachers and advisors (in the form of a table with 2 columns first_name and last_name) ?

Complete the code to get all columns from the table: SELECT _____ FROM Departments;

Aggregate function ... selects the average value.

Aggregate function ... selects the minimum value.

The ... clause divides the rows returned from the SELECT statement into groups. Then for each group, you can apply an aggregate function.

The ... clause allows to sort rows by returned from a SELECT statement in ascending or descending order based on the specified criteria.

Aggregate function ... selects the maximum value

Aggregate function ... selects the number of occurrences (the number of tuples that satisfy a selection condition).

The ... operator compares the value of attribute to each value returned by the subquery. This keyword (which must follow a comparison operator) returns TRUE if the comparison is TRUE for any of the values in the column that the subquery returns.

Write the possible operator when a result of a subquery is multiple values (multiple fields).

SELECT SQL statement(s) with which subqueries can be used.

The ... operator (which must follow a comparison operator) compares the value of attribute to every value returned by the subquery. The result is true if all rows yield true. The result is false if any false result is found.

Select the condition when the «=» operator can be used with a subquery.

SQL allows testing the emptiness of a subquery's result using the ... keyword.

Can the SELECT statement on which the view is based contain a join operation?

If the records in the physical table have changed, will the view show the updated records?

What statement is used to create a view?

Which statement can be used to slightly change the structure of a view?

What statement can be used to show rows from a view?

What keyword is used to create а СТЕ?