Question:
Which of the following statements about a relation \( R \) in first normal form (1NF) is/are TRUE?
Which of the following statements about a relation \( R \) in first normal form (1NF) is/are TRUE?
Show Hint
In 1NF, atomicity of attributes is essential. Composite attributes are not allowed, but multi-attribute keys and foreign keys are permitted.
Updated On: Jan 22, 2025
- \( R \) can have a multi-attribute key
- \( R \) cannot have a foreign key
- \( R \) cannot have a composite attribute
- \( R \) cannot have more than one candidate key
Show Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
Step 1: Analyze the statements.
1. \( R \) can have a multi-attribute key: Multi-attribute keys are allowed in 1NF as long as the attributes are atomic. This statement is true.
2. \( R \) cannot have a foreign key: This statement is false. Foreign keys are allowed in 1NF as they maintain referential integrity.
3. \( R \) cannot have a composite attribute: In 1NF, attributes must store atomic values, so composite attributes are not allowed. This statement is true.
4. \( R \) cannot have more than one candidate key: A relation in 1NF can have multiple candidate keys. This statement is false. Final Answer: \[ \boxed{\text{(1) and (3)}} \]
1. \( R \) can have a multi-attribute key: Multi-attribute keys are allowed in 1NF as long as the attributes are atomic. This statement is true.
2. \( R \) cannot have a foreign key: This statement is false. Foreign keys are allowed in 1NF as they maintain referential integrity.
3. \( R \) cannot have a composite attribute: In 1NF, attributes must store atomic values, so composite attributes are not allowed. This statement is true.
4. \( R \) cannot have more than one candidate key: A relation in 1NF can have multiple candidate keys. This statement is false. Final Answer: \[ \boxed{\text{(1) and (3)}} \]
Was this answer helpful?
0
0
Top GATE CS General Aptitude Questions
- A person sold two different items at the same price. He made 10% profit in one item and 10% loss in the other item. In, selling the person made a total of
- The value of x in given series is
6, 9, 14, x, 30, 41 - log \([\frac{x+y}{2}]=\frac{1}{2}\) (log x+log y) the value of \(\frac{x}{y}+\frac{y}{x}\) is
- A cube is to be cut into 8 pieces of equal size and shape Here each cut should be straight and it should not stop till it reaches the other end of the cube The minimum number of such cuts required?
- Increasing order of the intensity
Walk → Jog → Sprint
Bothered →? Daunted
View More Questions
Top GATE CS Questions
- Which of the following sequences when stored in an array at locations A[1],..., A[10] forms a max-heap?
- The Lucas sequence Ln is defined by the recurrence relation: Ln = Ln−1 + Ln−2, for n ≥ 3, with L1 = 1 and L2 = 3. Which one of the options given is TRUE?
- Which of the following fields of IP header is/are always modified by any router before it forwards to IP Packet ?
- Which one of the following CIDR profix exactly represent the range of IP addresses 10.12.2.0 to 10.12.3.255?
- Consider an ethernet segment whose transmission is \(10^8\) bits per second. Maximum segment length \(500\ m\), speed of the provocation media velocity is \(2 × 10^8\) meter per second. What is the minimum frame size in bits ?
View More Questions