Week5 - Introduction to Relational databases, Relational Algebra and Keys / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

Question 1
Identify the attributes from the following relation.

(a) ROLL_NO
(b) NAME
(c) ADDRESS
(d) PHONE
(e) AGE

Question 2
Write the correct relation schema for the given relation.

(a) STUDENT(ROLL_NO, NAME, ADDRESS, PHONE, AGE)

Question 3
What is tuple?

(d) Row

Question 4
Identify the tuple from the given options.

(a) 1 Roger San Francisco 9878765543 18

Question 5
Number of attributes in the relation is known as __________.

(a) Degree

Question 6
The STUDENT relations has how many degrees?

(d) 5

Question 7
Which column allows null values in STUDENT relation?

(d) PHONE