Викторина без названия

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

• KEY

• FOREIGEN KEY

• FOREIGEN

• Primary key

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

• Full

• Partial

• None of the given

• Transitive

Database is a collection of ...

• None of the given

• Programs

• Data

• Modules

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

• CREATE TABLE

• INSERT INTO

• UPDATE

• Delete From

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.

• schedule_id (PK), group_name (FK), subject_name (FK)

• schedule_id (PK), group_code (FK), subject_code (FK)

• schedule_id (PK), subject_name (FK)

• schedule_id (PK), group_code (FK)

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

• 0NF

• 1NF

• 2NF

• 3NF

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

• ALTER TABLE Groups

• UPDATE

• Groups

• UPDATE Groups

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

• Alter Table

• Add Table

• Create Table

• Create database

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?

• Author

• ISBN

• Title

• Pages

DBMS stands for ...

• Database Administrator System

• None of the given

• Database Basic Management System

• Database Management System