Empdt1(empcode, name, street, city, state, pincode).
For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
a) 1 NF only
b) 2 NF and hence also in 1 NF
c) 3NF and hence also in 2NF and 1NF
d) BCNF and hence also in 3NF, 2NF and 1NF
Answer: b
Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
Related Posts
RBAC is abbreviated as ______________
DTE is abbreviated as ___________________
_______________ in a system is given so that users can use dedicated parts of the system for which they’ve been given access to.
MAC is abbreviated as _______________
In a Linux-based system, the accounts may be members of 1 or more than one group.
In your Linux-based system, you have to log-in with your root account for managing any feature of your system.
Using the ______ account of a UNIX system, one can carry out administrative functions.
Join The Discussion