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

Teachers (teacher_id (PK), name, birthdate)

Subjects (subject_code (PK), name, description)

Identify a type of the relationship between Teachers and Subjects tables.

Primary keys made up of more than one single attributes are called

A functional dependency is a logical relationship between or among

In an ER diagram an entity is represent by a

Complete the code to drop the table Faculties:

Complete the code to create the table Subjects (subj id (PK), name):

CREATE TABLE Subjects(

subj_id int ___________ ,

name varchar(10));

Can a Foreign key be NULL?

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

Determine the type of the relationship between Products and Orders entities by its description: "One produc can be included in many orders, and one order can include many products"

Determine what functional dependency is in this table

Teachers (PK teacher_id, Iname, email, FK dep_id)

Which of the following are considered as DBMS?

Complete the code for the following table Faculties (facult_id (PK), name):

______ Faculties

SET name='Information Technology'

WHERE name='IT';

Determine the primary key by the description of the table: Students (stud id, Iname, fname,

Complete the code to create the table Departments (dep_id (PK), name), where name attribute has constraint:

CREATE TABLE Departments dep_id int PRIMARY KEY,

name varchar(10) ________ );

The another name for a row is

Complete the code to create the table Teachers (teach_id (PK), lastname), where lastname unique constraint:

CREATE TABLE Teachers( teach_id int PRIMARY KEY,

lastname varchar(10) _______ );

Doctors may prescribe several appointments for one patient. One appointment is focused on only one pa

Patients(patient_id(PK), fname, Iname, age)

Appointments(app_id(PK), time, day_of_week) Identify a table with a Foreign Key(s) for the relationship between Patients table and Appointments tab

Complete the code to add a new column to the table Courses.

ALTER TABLE Courses _____________ credits int;

Third normal form is based on the concept of …

Complete the code to drop the table Teachers:

DROP _____________ ;

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

Complete the code to drop a column from the table Subjects:

ALTER TABLE Subjects _______________ name;

In ER Diagram by Chen's notation a relationship type is represented by

How many rows (maximum number) will be deleted by the following code from the table (PK), name): DELETE FROM Subjects WHERE subject_id=1;

write the number here: 1

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

CREATE TABLE Subjects( subjid int, name varchar(10),

______________ (subj id));

There is a bank that serves many customers, each of which can have one / several accour savings account, a salary account, etc. Determine the type of relationship between the cu accounts entity?

Which of the following is not a phase of database development?

Which of the following is not a DDL statement?

There is a bank, which serves a lot of customers, each of customer can have one/several accounts, for example, saving account, salary account, etc. Identify a table with a Foreign Key(s) for the relationship between Customers table and Accounts table.

A relation in which the intersection of each row and column contains one and only one value is said to be in

In an diagram by Chen notation attributes are represented by

Determine the type of the relationship between Customers and Orders entities by its description: "One cus make many orders, and one order can be made by only one customer"

Can a Foreign key be duplicate?

Complete the code to delete all rows from the following table Faculties (facult_id (PK), name):

Complete the code to add a new record with incomplete information for the following table: Teachers (teach_id (PK), firstname, lastname,

dateofbirth):

INSERT INTO Teachers (teach_id, ______________________________)

VALUES (1, 'First name', 'Last name');

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

Determine the Normal Form of the table:

Complete the code to drop a column from the table Schedule:

ALTER TABLE _________________________;

Key to represent relationship between tables is called

A faculty might include several departments, and a department belongs to one faculty. Identify a table with a Foreign Key(s) for the relationship between FACULTIES and DEPARTMENTS.

Complete the code to drop the table Subjects:

________________ Subjects;

Complete the code to drop the table Schedule :

______________ Schedule;

Determine the type of the relationship between Products and Orders entities by its description: "One product can be included in many orders, and one order can include many products"

Third normal form is based on the concept of … of…

In an ER diagram by Chen's notation attributes are represented by

There is a company that specializes in repairing various equipment. This company takes orders from customers every day. They have a team of specialists, each of whom can perform various orders, however one order is related to only one specialist. Based on this description, determine the type of relationship between specialists entity and orders entity?

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

Determine the Normal Form of the table:

Entity Relationship model consists of a collection of basic objects called … and relationships among these objects.

Determine the Normal Form of the table:

A teacher may be assigned with exactly one position, like tutor, lecturer or professor. A position must be assigned to one or more teachers. A teacher is recorded with teacher identity code, name, address and date of birth. A position is associated with name of the position and the identity code for the position.

Identify a type of the relationship between TEACHERS and POSITIONS entities.

Determine the Normal Form of the table:

Determine what functional dependency is in this table

Determine what functional dependency is in this table

There is a bank which serves a lot of customers, each of customer can have one several accounts for example saving account salary account etc identify a table with a Foreign Key(s) for the

relationship between Customers table and Accounts table.

A primary key for an entity is

There is a bank, which has several departments lke i department, finance HR etc. There are a lot of employees and each of them belongs to only one department identify a table with a Foreign Keys) for the relationship between Departments table and Employees table

There is a bank, which serves a lot of customers each of customer can have one severa accounts for example, saving account salary account etc identify a table with a Foreign Key(s) for the relationship betiveen Customers table and Accounts table.

Complete the code to add a new column to the table Subjects:

_______________ Sutjects ADD COLUMN name varchar(25);

Determine the type of the relationship betiween Students and Reader's cards entities by its description: "One student has only one reader's card, and one readers card can belong to only one student"

Determine the type of the relationship between Customers and Orders entities by its description: One customer can make many orders and one order can be made by only one customer

Which of the following is not a DDL statement?

A teacher may be assigned with exactiy one position, like tutor, lecturer or professor. A position must be assigned to one or more teachers. Ateacher is recorded with teacher identity code name address and date of birth. A position is associated with name of the position and the identity code for the position. identify a type of the relationship betiween TEACHERS and POSITIONS entities

What SQL structure is used to limit column values of a table?

A table with Foreign Key(s) for the relationship between FACULTIES and DEPARTMENTS is:

The FD X-> Y is a full dependency in a relation R if there is . attribute A that can be . X and the dependency still holds

Complete the code to create the table Teachers (teachid (PK), lastname), where lastname attribute has the not null constraint:

CREATE TABLE Teachersf teach_id int PRIMARY KEY lastname varchar(10) __________

Which of the following is not a phase of database development?

Which SQL keyword is used to specify conditional search?

Which SQL statement is used to extract data from a database?

The column of a table is referred to as the

Normalization is ...

SQL

Table is synonymous with the term

Complete the code for the following table Subkects(subj_id(PK),name,credits):

___________________

SET credits=credits+1;

Complete the code for the following table Groups(group_id(PK),name):

DELETE FROM Groups

_______ group_id=1;

Determine what functional dependency is in this table