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