+1 vote
39 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

A table is in second normal form (2NF) if and only if it is in 1NF and every nonkey attribute is fully dependent on the primary key. An attribute is fully dependent on the primary key if it is on the right side of an FD for which the left side is either the primary key itself or something that can be derived from the primary key using the transitivity of FDs.  

An example of a transitive FD in report is the following:

report_no -> dept_no

dept_no -> dept_name

Therefore we can derive the FD (report_no -> dept_name), since dept_name is transitively dependent on report_no.

Related questions

+1 vote
1 answer 68 views
+1 vote
1 answer 80 views
+1 vote
1 answer 67 views
+1 vote
1 answer 179 views
+1 vote
1 answer 112 views
+1 vote
1 answer 39 views
+1 vote
1 answer 56 views
asked Oct 18 in Law for Engineers by (user.guest)
+2 votes
1 answer 222 views
+1 vote
1 answer 143 views
0 votes
1 answer 20 views
asked 14 hours ago in Computational Tools by (user.guest)
0 votes
1 answer 16 views
asked 14 hours ago in Computational Tools by (user.guest)
+1 vote
0 answers 28 views
0 votes
1 answer 57 views
asked Oct 25 in Others by (user.guest)
+1 vote
1 answer 26 views
+3 votes
1 answer 984 views
+1 vote
1 answer 139 views
+1 vote
1 answer 28 views
+1 vote
0 answers 12 views
+1 vote
0 answers 11 views
+1 vote
0 answers 11 views
+1 vote
1 answer 25 views
0 votes
1 answer 62 views
0 votes
1 answer 61 views
+1 vote
1 answer 34 views
+1 vote
1 answer 88 views
+1 vote
1 answer 50 views
+1 vote
1 answer 113 views
+1 vote
1 answer 152 views
+1 vote
1 answer 138 views
+1 vote
1 answer 308 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...