1
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
Consider the following entity relationship diagram $$(ERD),$$ where two entities $$E1$$ and $$E2$$ have a relation $$R$$ of cardinality $$1:m.$$ GATE CSE 2004 Database Management System - Er Diagrams Question 7 English

The attributes of $$E1$$ are $$A11, A12$$ and $$A13$$ where $$A11$$ is the key attribute. The attributes of $$E2$$ are $$A21, A22$$ and $$A23$$ where $$A21$$ is the key attribute and $$A23$$ is a multi-valued attribute. Relation $$R$$ does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form $$(3NF)$$ is designed form the above $$ERD.$$ The minimum number of tables in the database is

A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
2
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
A relation Empdt $$1$$ is defined with attributes empcode (unique), name, street, city, state and pincode. For any pincode, there is only one city and state. Also, for any given street city and the state, there is just one pincode. In normalization terms, Empdt$$1$$ is a relation in
A
$$1NF$$ only
B
$$2NF$$ and hence also in $$1NF$$
C
$$3NF$$ and hence also in $$2NF$$ and $$1NF$$
D
$$BCNF$$ and hence also in $$3NF,$$ $$2NF$$ and $$1NF$$
3
GATE CSE 2004
MCQ (Single Correct Answer)
+2
-0.6
The relation scheme student Performance (Name, CourseNo, RollNo, Grade) has the following functional dependencies:

Name, courseNo $$\,\, \to \,\,$$ grade
RollNo, courseNo $$\,\, \to \,\,$$ grade
$$\,\,\,\,\,\,\,\,\,\,\,\,\,\,\,$$$$\,\,\,\,\,\,\,\,\,$$ Name $$\,\, \to \,\,$$ rollNo
$$\,\,\,\,\,\,\,\,\,\,\,\,\,$$$$\,\,\,\,\,\,\,\,\,$$ RollNo $$\,\, \to \,\,$$ name

The highest normal form of this relation scheme is

A
$$2\,NF$$
B
$$3\,NF$$
C
$$BCNF$$
D
$$4\,NF$$
4
GATE CSE 2004
MCQ (Single Correct Answer)
+1
-0.3
Consider the following relation schema pertaining to a students database:
Students (rollno, name, address)
Enroll(rollno,courseno, coursename)
Where the primary keys are shown underlined. The number of tuples in the student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where '*' denotes natural join?
A
8, 8
B
120, 8
C
960, 8
D
960, 120
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12