System Analysis and Design Paper 34

1

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






2

Pick the meaningful relationship between entities






3

In an E-R diagram relationship is represented by






4

If an entity appears in only one relationship then it is






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






6

A relation is said to be in 1NF if






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






8

Boye Codd Normal Form (BCNF) is needed when






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






10

One of the main objectives of a DBMS is to






Result

Total Questions:
Correct Answers:
Wrong Answers:
Percentage: