Empdt1(empcode, name, street, city, state, pincode). For any pincode, – McqOptions

MCQOPTIONS

1.	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» C. 3NF and hence also in 2NF and 1NF

Discussion

No Comment Found

Related MCQs

An ________ is a set of entities of the same type that share the same properties, or attributes.
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),primary key (ownerID:));Choose the correct option regarding the above statement
In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
With SQL, how do you select all the records from a table named Persons where the value of the column FirstName ends with an a ?
If you don t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
With SQL, how can you return all the records from a table named Persons sorted descending by FirstName ?
Which of the following command makes the updates performed by the transaction permanent in the database?
Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2
An entity set that does not have sufficient attributes to form a primary key is termed a __________