Contents

A relation that contains minimal redundancy and allows easy use is called
a) clean                                 

b) simple
c) complex                           

d) well-structured

d

The 1NF describe the tabular format in which
a) all key attributes are defines                        
b) nonrepeating group in table
c) all attributes are dependent                          
d) all of these

d

In functional dependency, the determinant is……
a) will be paired   
b) may be paired

c) may consist of one attribute                        
d) both a & c

d

When determinant contain two attributes is called……
a) first attribute determinant                            
b) second attribute determinant
c) both a & c                                       
d)
either first or second attribute determinant

c

An anomaly in relation is……
a) unusual data value 

b) duplicate data
c) undesirable data  

d) error in design

c

Restrictions on operations on a relation is called……
a) deletion anomaly           
b) insertion anomalies
c) modification anomalies
d) referential integrity

d