in Education by
The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in (a) 1NF only (b) 2NF and hence also in 1NF (c) 3NF and hence also in 2NF and 1NF (d) BCNF and hence also in 3NF, 2NF and 1NF The question was asked during an interview for a job. My question is based upon Materialized Views topic in division Query Processing Techniques of Database Management

1 Answer

0 votes
by
Right choice is (b) 2NF and hence also in 1NF The best explanation: Empcode is unique, therefore it is the primary key. Since the primary key consists of a single attribute there will be no partial dependency, hence the relation is in 2NF. From the question we get the FDs as below: pincode -> city, state street,city,state -> pincode From the FDs we can see that there are transitive dependencies, hence the table is not in 3NF.

Related questions

0 votes
    Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Is there any relation between the directory that hold sstables and the name of the (1)keyspace of the sstable (2)There is ... names can be different (5)Both name has to be same...
asked May 6, 2021 in Education by JackTerrance
0 votes
    Is there any relation between the directory that hold sstables and the name of the (1)keyspace of the sstable (2)There is ... names can be different (5)Both name has to be same...
asked Apr 17, 2021 in Technology by JackTerrance
0 votes
    Name the leader who led a peoples’ march to Parliament in 1975 and state as to what was unique about this march. Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
    McFadden has defined normalization in his which book___________ (a) Database modern management (b) Management ... Querying Database in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    There are similarities between the instructor entity set and the secretary entity set in the sense that ... Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    A DOMAIN NAME IS A UNIQUE NAME GIVEN TO EACH WEBSITE TRUE OR FALSE Select the correct answer from above options...
asked Dec 22, 2021 in Education by JackTerrance
0 votes
    There are four men and six women on the city councils. If one council member is selected for a committee at random, ... it is a women? Select the correct answer from above options...
asked Nov 22, 2021 in Education by JackTerrance
0 votes
    There are record-once versions of the compact disk and digital video disk, which can be written only once ... Media in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    The number of attributes in relation is called as its (a) Cardinality (b) Degree (c) Tuples (d) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Is there any difference between the terms Data on Demand & Details on Demand?...
asked Nov 21, 2020 in Technology by JackTerrance
0 votes
    Given the following relation: Student (Std_ID, name, dept, totalcredit) Now Create a view STDINFO (ID, name, ... the STDINFO view. Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
    In Hive, when we do a query (like: select * from employee), we do not get any column names in the ... when you execute any query? Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
...