Bissoy.com
Doctors Medicines MCQs Q&A

A table is in 3NF if it is in 2NF and if it has no ____________

A table is in 3NF if it is in 2NF and if it has no ____________ Correct Answer Transitive Dependencies

For a relation to be in Third Normal Form, it must be in Second Normal form and the following must satisfy:No non-prime attribute is transitively dependent on prime key attribute For any non-trivial functional dependency, X -> A, then eitherX is a superkey or,A is prime attribute.

Related Questions

Given the following two statements: S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB → C, D → E, E → C is a minimal cover for the set of functional dependencies AB → C, D → E, AB → E, E → C. Which one of the following is CORRECT?
Consider the following statements regarding database normal forms: 1. Any relation with two attributes is BCNF. 2. Lossless, dependency - preserving decomposition into BCNF is always possible. 3. Lossless, dependency - preserving decomposition into 3NF is always possible. 4. BCNF is stricter than 3NF. Which of the above statements are correct?
Which of the following normal form(s) is/are based on the functional dependencies among the attributes of a relation? A. 1NF B. 2NF C. 3NF D. 4 NF
Consider the circuit shown below. Given that R1=20kΩ, C1=2nF, R2=20kΩ, C2=2nF, find the approximate resonant frequency.
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Consider a relational table R that is in 3NF, but not in BCNF, Which one of the following statements is TRUE?
Read the given seating arrangement information and answer the question that follows. Prashant, Kamal, Rishi, Sunita, Tanvi, Vimal, Wazir and Yogita are sitting at a square table in such a way that four of them are sitting at four corners of the table, while the other four are sitting in the middle of each of four sides of the table. The four who are sitting at the corners of the table are facing the centre, whereas those who are sitting in the middle of the sides of the table are facing outside. Prashant, who is facing the centre, is sitting third to the right of Vimal. Tanvi, who is facing the centre, is not an immediate neighbour of Vimal. Only one person is sitting between Vimal and Wazir. Sunita sits second to the right of Kamal. Kamal is facing the centre. Rishi is not an immediate neighbour of Prashant. Which of the following statements regarding Kamal is true?
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. Which of the following is an acceptable sequence of negotiators around the table ?