Bissoy.com
Doctors Medicines MCQs Q&A

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

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 Correct Answer 2NF and hence also in 1NF

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

A relation Empdtl 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, Empdtl is a relation in:
We usually use feature normalization before using the Gaussian kernel in SVM. What is true about feature normalization?
1. We do feature normalization so that new feature will dominate other
2. Some times, feature normalization is not feasible in case of categorical variables
3. Feature normalization always helps when we use Gaussian kernel in SVM
Read the following information carefully and answer the questions that follow: Seven persons Tina, Vini, Yasir, Rishi, Sanya, Pankaj and Urmila live on the separate floors of a 7- floor building. Ground floor is number one; second floor is number two and so on. Each of them goes to a city viz. Paris, Istanbul, Shanghai, Durban, London, Madrid and Dubai but not necessarily in the same order. Only three people live above the floor on which Sanya lives. Only one person lives between Sanya and the one who goes to Paris. Vini lives just below the person who goes to Madrid. Only three people live between the one who goes to Paris and London. The person who goes to Madrid lives on an even numbered floor. Urmila lives just above Rishi. Urmila does not go to London. Only two persons live between Pankaj and the one who goes to Durban. Pankaj lives above the person who goes to Durban. Yasir does not go to Istanbul. Tina does not live just above or just below Sanya. The one who goes to Shanghai does not live just above or just below Pankaj. Who among the following lives on floornumber 7?
In the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. Not just to ______ the new morning
n the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. we just need to be ______.
n the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. ourselves is also ______ with the
In the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. sun has great inner ______.
n the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. sunrise to ______ within ourselves
Which one of the following four addresses is NOT EXACTLY the same as the one given below? Nusrat Jahan 138 F, Pragya colony Meena street West bengal i. Nusrat Jahan 138 F, Pragya colony Meena street West bengal ii. Nusrat Jahan 138 F, Pragya colony Meena street West bengal iii. Nusrat Jahan 130 F, Pragya colony Meena street West bengal iv. Nusrat Jahan 138 F, Pragya colony Meena street West bengal 
Which one of the following four addresses is NOT EXACTLY the same as the one given below? Jennifer Stenvin 23/198 B, Walkswagen  malaviyen street Stempho guestur London i. Jennifer Stenvin 23/198 B, Walkswagon  malaviyen street Stempho guestur London ii. Jennifer Stenvin 23/198 B, Walkswagen  malaviyen street Stempho guestur London iii. Jennifer Stenvin 23/198 B, Walkswagen  malaviyen street Stempho guestur London iv. Jennifer Stenvin 23/198 B, Walkswagen  malaviyen street Stempho guestur London