The responsibilities of a database administrator includes
i. maintenance of data dictionary
ii. ensuring security of database
iii. ensuring privacy and integrity of data
iv. obtain an E-R model
Detailed Answer
Correct answer: (B)
i, ii, iii
2
Pick the meaningful relationship between entities
Detailed Answer
Correct answer: (A)
vendor supplies goods
3
In an E-R diagram relationship is represented by
Detailed Answer
Correct answer: (C)
diamond shaped box
4
If an entity appears in only one relationship then it is
Detailed Answer
Correct answer: (A)
a 1:1 relationship
5
Relations are used in logical database design because
i. sound theory of relations facilitates systematic design of relational databases
ii. they are very popular
iii. they are flat files and easy to store and retrieve from computer memory
iv. E-R diagrams allow design of relations
Detailed Answer
Correct answer: (B)
i and iii
6
A relation is said to be in 1NF if
Detailed Answer
Correct answer: (B)
there are no composite attributes in the relation
7
A relation is said to be in 2 NF if
i. it is in 1 NF
ii. non-key attributes dependent on key attribute
iii. non-key attributes are independent of one another
iv. if it has a composite key, no non-key attribute should be dependent on part of the composite key
Detailed Answer
Correct answer: (C)
i, ii, iv
8
Boye Codd Normal Form (BCNF) is needed when
Detailed Answer
Correct answer: (C)
there are two or more possible composite overlapping keys and one attribute of a composite key is dependent on an attribute of another composite key
9
A relation project guidance Project Guidance (professor, project, student no. st-name, dept)
A professor can give many projects to many students
A project will have many students
A project may be guided by many professors
The 4 NF relation corresponding to this are