Question # 2 Given the following relation it is not 3 NF because Student(roll no

Question

Question # 2

Given the following relation it is not 3 NF because Student(roll no, name, course no, course max. marks, year of study,address), where roll no is PK

Select correct option:

it is not in 2 NF

it does not have composite key

non-key attributes course no and course max. marks arefunctionally dependent

it has more than 3 non-key attributes

Question # 3

A 3 NF relation is converted to BCNF by

Select correct option:

removing composite keys

removing multivalued dependencies

dependent attributes of overlapping composite keys are putin a separate relation

dependent non-key attributes are put in a separatetable

Question # 4

Total Marks: 1

The following SQL statement reflects as ______________ inrelational algebra. Select * from relation1 where a = b;

Select correct option:

Projection Statement

Selection Statement

Question # 5

Total Marks: 1

A relation which is in a higher normal form

Select correct option:

implies that it also qualifies to be in lower normalform

does not necessarily satisfy the conditions of lowernormal form

is included in the lower normal form

is independent of lower normal forms

Question # 6

Total Marks: 1

The following SQL statement reflects as _________ in relationalalgebra. Select * from relation1;

Select correct option:

Projection Statement

Selection Statement

Question # 7

Total Marks: 1

Attributes are (i) properties of relationship (ii) attributed toentities (iii) properties of members of an entity set

Select correct option:

i

i and ii

i and iii

iii

Question # 2

Given the following relation it is not 3 NF because Student(roll no, name, course no, course max. marks, year of study,address), where roll no is PK

Explanation / Answer

Q.2 option a Q.3 option b Q.4 option a Q.5 option d Q.6 option a Q.7 option d

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---