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

A primary key for an entity is

Choose the right order of the database design phases

Database is a collection of…

DBMS stands for …

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.

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

What type of

relationship is described by the following rule? For one instance of entity A.

there

exists one or many instances of entity B; and for one instance of entity B, there exists one or many

instances of entity A.

What type of relationship is described by this rule? For one instance of entity A, there exists

one or many instances of entity B; but for one instance of entity B, there exists one instance of entity A…

What type of relationship is described by this rule? One instance of entity A can be associated

with one instance of entity B. and one instance of entity B can be associated with one instance of entity A

A relation in which the intersection of each row and column contains one and only one value

is said to be in

An entity with atomic attributes that has no partial functional dependencies is in … form

Can a Foreign key be duplicate?

In an ER diagram an entity is represent by a …

Table is synonymous with the term …

The another name for a row is …

The column of a table is a synonym for …

… operator is used to convert from one data type into another.

Select the functional dependency according to the table description: Teachers (teacher id

(PK), last_name, department_id)

To check if a value in a column is null, the … operator is used.

Table names can be aliased to another using the … operator.

Select the functional dependency according to the table description: Students (study id (PK).

last_name, group_id)

Select the functional dependency according to the table description: Groups (group_id (PK),

group_name)

Select the functional dependency according to the table description: Courses (course id (PK),

course_name, credits)

Select the Normal Form by the table description: Teachers (teacher id (PK), last_name,

department_id)

Select the Normal Form by the table description: Courses (course id (PK), major id (PK), course name, credits, majorname)

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

advisor id, advisor last name)

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

subject ids)

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

course_name, credits, major name)

Answer if the next table has a partial dependency: Schedule (teacher id (PK), groupid

(PK).

course id (PK), time, room)

Answer if the next table has a partial dependeney: Teachers (teacher_id (PK), last_name,

department id)

Answer if the next table has a partial dependency: Groups (group_id (PK), group_name,

adviser_id, adviser_last name)

A functional dependency is a logical relationship between or among …

Select the Normal Form by the table description: Teachers (teacher id (PK), Name, email,

department id, department name)

Select the Normal Form by the table description: Students (study id (PK), group_id (PK).

Name, email, group_name)

Select the Normal Form by the table description: Students (stud id (PK), group id, Iname,

email, group_name)

Select the Normal Form by the table description: Schedule (teacher_id (PK), subject_id (PK).

teacher Name, time, subject name)

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

((PK), teacher Jname, email, department name)

Select the Normal Form by the table description: Schedule (teacher_id (PK), subject_id,

teacher Name, time, subject_name)

Select the Normal Form by the table description: Schedule (sch id (PK), teacher id,

subject_id, time)

Select the Normal Form by the table description: Departments (department id (PK), name,

teacher Just names)

Third normal form is based on the concept of…

Which normal form is considered "good" for relational database design?

Complete the code to create the table Teachers (teach id (PK), 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 create the table Departments (deptid (PK), dep_name): CREATE TABLE

Departments(depid int

dep_name varchar(15));

Complete the code to create the table Students (stud_id (PK), last_name): CREATE TABLE

Students(stud_id int, last name varchar(20),

(stud_id));

Complete the code to create the table Groups (group id (PK), 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 (PK), name): CREATE TABLE

Courses( course id int

name varchar(10));

Which of the following language is used to specify database structure?

Complete the code: DELETE FROM Students___stud id=2:

Complete the code for the following table Departments (depart_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';

Complete the code for the following table Faculties (faculty id (PK), name): DELETE FROM

Faculties___facult_jd=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 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):___SETcredits=credits+1;

Complete the code for the following table: Faculties (facult_id (PK), name): INSERT INTO___(1, IT):

Complete the code for the following table Groups (group_id (PK), group_name):___VALUES (1, "SIS-01");

Complete the code for the following table Groups (group_id (PK), group_name):___INTO Groups VALUES (I, 'SIS-01");

Complete the code for the following table Schedule (sch_id (PK), group_id, subj_id, teach_id,

time, room): INSERT INTO Schedule (sch_id group_id, subj_id,___VALUES (1, 1, 1, '08:00');

Complete the code to create the table Departments (dep_id (PK), 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___Faculties (faculty_id));

Complete the code

to create the table Departments (dep id

(PK), 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 (deptid (PK), dep_name), where dep_name

attribute has the not null constraint: CREATE TABLE Departments( deptid int PRIMARY KEY, dept name

varchar(10)___);

Complete the code to create the table Departments (deptid (PK), dep name), where dept name

attribute has the unique constraint: CREATE TABLE Departments(dep id int PRIMARY KEY, dep name

varchar(10)___);

Complete the code to create the table Subjects (subj_id (PK), name):___(subjid

int PRIMARY KEY, name yarchar(10));

Complete the code to drop the table Coumes___Cersa

The SQL DROP TABLE clause is wied to___

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

…

<question> What does SQL stand for?

Which of the following language is used to

specify database structure?

With SQL, how do you select all the records from a table named "Persons" where the value of

the column "FirstName" is "Peter"?

With SQL, how do you select all the records from a table named "Persons" where the

"FirstName" is "Peter" and the "LastName" is "Jackson"?

Which of the following is the correct order of keywords for SQL SELECT statements?

If you want to apply a second

condition to your statement where both statements must be true,

what keyword would you use between the conditions?

Union R1 U R2 is …

EXCEPT in SQL is analogous to

Complete the code:

Students VALUES (1,'FirstNamel','LastNamel','2000-01-01',I);

Complete the code: DELETE FROM Students___stud_id=2;

Complete the code for the following table Departments (depart_id (PK), name): UPDATE

Departments___name='IT' WHERE depart_id=1;

Set difference R1 - R2 is …

Intersection R1 N R2 is …

The FULL OUTER JOIN keyword combines the results of both … and … joins.

LIKE 'SIS-_' can give 'SIZE-2301' as the answer

How to select all data from student table starting the name from letter 'r"?

Aggregate function … selects the minimum value.

The … clause sets the selection condition for aggregate functions or group rows created by the

GROUP BY clause.

Aggregate function … selects the number of occurrences (the number of tuples that satisfy a

selection condition).

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.

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

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

Find all the tuples having temperature greater than 'Paris'.

What keyword is used to create a CTE?

Which of the following multi-row operators can be used with a subquery?

Which of the following is used to denote the projection operation in relational algebra?

Which of the following is not a relational algebra operation?

What statement is used to create a view?

EXCEPT in SQL is analogous to

What operator tests column for the absence of data?

Union R1 R2 is …

Set difference R1 - R2

is

…

With SQL, how can you return the numbers

Which SQL statement will selects all rows from a table called "Customers" and orders the

result by "customer name"?

Which of the following are the five built-in aggregate functions provided by SQL?

A subquery in an SQL SELECT statement is enclosed in

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

WmI SQL, how df

do yo

the column "FirstName" starts wit

rts with an "a"

LIKE operator uses

and

Choose the correct order of keywords in a SELECT statement

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.

Choose the correct option to convert phone number attribute from varchar to integer data type

What is a result of "CAST (phone_number AS INTEGER)"?

LIKE 'SIS-%' can give 'SIZE-2301' as the answer

… operator is used to convert from one data type into another.

SQL provides the … operator for pattern matching.

Which SQL keyword is used to return only different (unique) values?

To check if a value in a column is not null, the … operator is used.

Column names can be aliased to another using the … operator.

What is the meaning of LIFE %4040%