Classical Normalization
Home
Schema:
FD Set: ( X -> Y ) =
->
Add FD
Delete From List
Clear List
Load File
Enter Input Directly
View Data Input
Optimal Schema Size:
Optimal Number of Functional Dependencies:
Generate Randomized Input
Attribute Set:
Algorithm:
BCNF Decomposition
3NF Decomposition
Canonical Cover
All Minimal Keys
Projection
Attribute Set Closure
Generate Randomized Input
Version 1 - Standard
Version 2 - Tsao/Fischer
Version 3 - Augmented Tsao/Fischer
© 2013 University of Auckland v0.981
(Optimized for Firefox and IE > 9)
Output
Done
View Input Data
Back
Load File
Load File
Instructions on Use
Previous
Next
Enter Input Data
Ok
Instructions on Use
You need to first set up a schema and a set of functional dependencies. This can be done in a number of ways. 1. You can add the schema and FD set manually using the fields provided. The schema field and left hand/right hand sides of each dependency expect a comma-delineated list of attributes which must not contain spaces. 2. You can click on the Load File button and load a schema/FD set document into the program. The file must be of a required format. The first line must be a comma separated list of attributes and any subsequent lines must consist of individual functional dependencies of the form X -> Y. The file must not end with more than one carriage return sequence. 3. You can enter the data directly in the raw by clicking on Enter Input Directly. 4. You can click on the Generate Randomized Input button. Optionally you can explicitly set the schema size and number of functional dependencies. Next you select an algorithm to run using this data. Select from the main algorithms drop-down - in some cases there are sub-options.
Future Use - Page Two
To be filled
Future Use - Page Three
To be filled
Version 1 - Standard
Version 2 - Tsao/Fischer
Version 3 - Augmented Tsao/Fischer
Version 1 - Expanded
Version 2 - Unique LHS
Version 1 - Expanded
Version 2 - Unique LHS