Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 778 |
For a database relation R(a,b,c,d) where the domains of a,b,c,d include only atomic values, only the following functional dependencies and those that can be inferred from them hold:
a→ c
b→ d
the relation is in
a→ c
b→ d
the relation is in
| first normal form but not in second normal form | |
| Second normal form but not in third normal form | |
| Third normal form | |
| None of these |
Question 778 Explanation:
● First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain.
● The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependencies of any of the columns on the primary key.
● The questions states that relation consists of automatic values but there no information about prime key.So we don’t about partial dependency.
● The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependencies of any of the columns on the primary key.
● The questions states that relation consists of automatic values but there no information about prime key.So we don’t about partial dependency.
Correct Answer: A
Question 778 Explanation:
● First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain.
● The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependencies of any of the columns on the primary key.
● The questions states that relation consists of automatic values but there no information about prime key.So we don’t about partial dependency.
● The Second Normal Form states that it should meet all the rules for 1NF and there must be no partial dependencies of any of the columns on the primary key.
● The questions states that relation consists of automatic values but there no information about prime key.So we don’t about partial dependency.
Subscribe
Login
0 Comments