Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic value

Sail E0 Webinar

Question

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F={CHâ†’G, Aâ†’BC, Bâ†’CFH, Eâ†’A, Fâ†’EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.The relation R is

Options:

A . in 1NF, but not in 2NF.

B . in 2NF, but not in 3NF.

C . in 3NF, but not in BCNF.

D . in BCNF.

Answer: Option A

-NA-

Was this answer helpful ?

Next Question

Submit Solution

More Questions on This Topic :

Question 1. Were you a bird, you ___________________ in the sky. ....

Question 2. Choose the grammatically INCORRECT sentence: ....

Question 3. After several defeats in wars, Robert Bruce went in exile and wanted to commit suicide. Just before committing suicide,....the following assertions is best supported by the above information?

Question 4. Find the sum of the expression1/(√1 + √2) + 1/(√2 + √3) + 1/(√3 + √4) + .... + 1/(&....+ 1/(√3 + √4) + .... + 1/(√80 + √81)

Question 5. Out of all the 2-digit integers between 1 and 100, a 2-digit number has to be selected at random. What is the probabili....probability that the selected number is not divisible by 7?

Question 6. Which one of the following is the tightest upper bound that represents the number of swaps required to sort n numbers u....of swaps required to sort n numbers using selection sort?

Question 7. What is the maximum number of reduce moves that can be taken by a bottom-up parser for a grammar with no epsilon- and u....A â†’ a) to parse a string with n tokens?

Question 8. Consider the languages L1 = Ï† and L2 ={a}. Which one of the following represents L1L2* á´œ L3* ? ....

Question 9. Match the problem domains in GROUP I with the solution technologies in GROUP II.GROUP I �.... (4) XML

Question 10. A scheduling algorithm assigns priority proportional to the waiting time of a process. Every process starts with priori....have no I/O operations and all arrive at time zero?

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0