1
GATE CSE 2024 Set 1
MCQ (More than One Correct Answer)
+1
-0.33

Which of the following statements about a relation $R$ in first normal form (1NF) is/are TRUE?

A

$R$ can have a multi-attribute key

B

$R$ cannot have a foreign key

C

$R$ cannot have a composite attribute

D

$R$ cannot have more than one candidate key

2
GATE CSE 2022
MCQ (Single Correct Answer)
+1
-0.33

In a relational data model, which one of the following statements is TRUE?

A
A relation with only two attributes is always in BCNF.
B
If all attributes of a relation are prime attributes, then the relation is in BCNF.
C
Every relation has at least one non-prime attribute.
D
BCNF decompositions preserve functional dependencies.
3
GATE CSE 2022
Numerical
+1
-0.33

Consider a relation R(A, B, C, D, E) with the following three functional dependencies.

AB $$\to$$ C ; BC $$\to$$ D ; C $$\to$$ E;

The number of superkeys in the relation R is _________.

Your input ____
4
GATE CSE 2016 Set 1
MCQ (Single Correct Answer)
+1
-0.3
A database of research articles in a journal uses the following schema.
(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE)
The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema.
(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE
(VOLUME, NUMBER) → YEAR
(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE
The database is redesigned to use the following schemas.
(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE)
(VOLUME, NUMBER, YEAR)
Which is the weakest normal form that the new database satisfies, but the old one does not?
A
1NF
B
2NF
C
3NF
D
BCNF
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
CBSE
Class 12