Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  A relation Empdtl is defined with attribute e... Start Learning for Free
A relation Empdtl is defined with attribute 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, Empdtl is a relation in

  • a)
    2 NF and hence also in 1NF

  • b)
    1 NF Only

  • c)
    3 NF and hence also in 2 NF and 1NF

  • d)
    BCNF and hence also in 3 NF, 2 NF an 1 NF

Correct answer is option 'A'. Can you explain this answer?
Verified Answer
A relation Empdtl is defined with attribute empcode (unique), name, st...
1) Pin code →  city, state


2) Street, city, state →  pin code


The candidate keys of relation is empcode as it uniquely identifies the relation.


Hence, it is in 2NF and therefore, also in 1NF.
View all questions of this test
Most Upvoted Answer
A relation Empdtl is defined with attribute empcode (unique), name, st...
Normalization of Empdtl relation

1. First Normal Form (1NF)
- The given relation Empdtl already satisfies the first normal form (1NF) because it has a unique identifier attribute (empcode) and all the attributes are atomic (indivisible).

2. Second Normal Form (2NF)
- In order to determine whether the relation Empdtl satisfies the second normal form (2NF), we need to identify the functional dependencies in the relation.
- From the given information, we can infer the following functional dependencies:
- empcode -> name, street, city, state, pincode (Trivial functional dependency)
- pincode -> city, state
- street, city, state -> pincode
- The empcode attribute is a unique identifier and determines all other attributes in the relation. Therefore, the relation Empdtl satisfies the second normal form (2NF).

3. Third Normal Form (3NF)
- In order to determine whether the relation Empdtl satisfies the third normal form (3NF), we need to identify the transitive functional dependencies in the relation.
- From the given information, we can infer the following transitive functional dependency:
- street, city, state -> pincode (Non-trivial functional dependency)
- The relation Empdtl does not satisfy the third normal form (3NF) because it contains a transitive functional dependency.
- To eliminate the transitive functional dependency, we can decompose the relation into two relations:
- Relation 1: empcode, name, pincode
- Relation 2: pincode, city, state
- Now, both of these decomposed relations satisfy the third normal form (3NF).

Conclusion
- Based on the above analysis, the given relation Empdtl is in the first normal form (1NF) but not in the second normal form (2NF), third normal form (3NF), or Boyce-Codd Normal Form (BCNF).
- Therefore, the correct answer is option 'A' - Empdtl is only in the first normal form (1NF).
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Question Description
A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? for Computer Science Engineering (CSE) 2025 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer?.
Solutions for A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer?, a detailed solution for A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? has been provided alongside types of A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice A relation Empdtl is defined with attribute 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, Empdtl is a relation ina)2 NF and hence also in 1NFb)1 NF Onlyc)3 NF and hence also in 2 NF and 1NFd)BCNF and hence also in 3 NF, 2 NF an 1 NFCorrect answer is option 'A'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev