troubleshooting Question

Question in Functional depondences in the Relational Databases

Avatar of acad2012
acad2012 asked on
DatabasesOracle DatabaseMicrosoft SQL Server 2008
5 Comments1 Solution512 ViewsLast Modified:
Bovce-Codd normal form (BCNF) was proposed as a simpler form of 3NF, but it was found
to be stricter than 3NF. That is, every relation in BCNF is also in 3NF; however, a relation
in 3NF is not necessarily in BCNF. Intuitively, we can see the need for a stronger normal
form than 3NF by going back to the LOTS relation schema of Figure 1O.11a with its four
functional dependencies FD1 through FD4. Suppose that we have thousands of lots in the
relation but the lots are from only two counties: Dekalb and Fulton. Suppose also that lot
sizes in Dekalb County are only 0.5, 0.6, 0.7, 0.8, 0.9, and 1.0 acres, whereas lot sizes in
Fulton County are restricted to 1.1, 1.2, ... , 1.9, and 2.0 acres. In such a situation we
would have the additional functional dependency FD5: AREA --> COUNTY_NAME. If we add this to the other dependencies, the relation schema LOTs1A still is in 3NF because COUNTY_NAME is a prime attribute.

The area of a lot that determines the county, as specified by FD5, can be represented
by 16 tuples in a separate relation R(AREA, COUNTY_NAME), since there are only 16 possible AREA values. This representation reduces the redundancy of repeating the same information in the thousands of LOTs1A tuples. BCNF is a stronger normal form that would disallow LOTs1A and suggest the need for decomposing it.

My Question why the FD5 is AREA --> COUNTY_NAME not COUNTY_NAME --> AREA ?
Christoffer Swanström

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros