BCNF Decomposition: Difference between revisions

From Algorithm Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 26: Line 26:
[[File:BCNF Decomposition - Space.png|1000px]]
[[File:BCNF Decomposition - Space.png|1000px]]


== Pareto Frontier Improvements Graph ==  
== Space-Time Tradeoff Improvements ==  


[[File:BCNF Decomposition - Pareto Frontier.png|1000px]]
[[File:BCNF Decomposition - Pareto Frontier.png|1000px]]

Revision as of 15:37, 15 February 2023

Description

BCNF Decomposition is the problem of decomposing a relation schema into Boyce-Codd normal form (BCNF).

A relation schema $R$ is in Boyce Codd Normal Form (abbr. BCNF) if for all non-trivial FDs $X \rightarrow Y$ in $F^+$, $X$ is a superkey. In extending this notion to database schemas, we must be conscious of the UR-assumption. We say that $R_i = <ATTR_i,F_i>$ is in BCNF if the schema $<ATTR_i, F^+(ATTR_i)>$ is in BCNF, and $D$ is in BCNF if each $R_i$ is.

Related Problems

Related: Decisional BCNF

Parameters

No parameters found.

Table of Algorithms

Currently no algorithms in our database for the given problem.

Time Complexity Graph

BCNF Decomposition - Time.png

Space Complexity Graph

BCNF Decomposition - Space.png

Space-Time Tradeoff Improvements

BCNF Decomposition - Pareto Frontier.png