Skip to content

A Java based application which takes functional dependencies as input and can identify the keys, highest normal form and can decompose it further.

Notifications You must be signed in to change notification settings

hritiksk392/Database-System-Normalization-Application

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Database-System-Normalization-Application

Overview

A Java based GUI application that for a given set of Attributes and Functional Dependencies can identify candidate keys and check the highest normal form it satisfies. If the highest normal form is X it can decompose the given relation to satisfy X+1 Normal Form upto BCNF Normal Form.

The application has been made using NetBeans IDE 8.2 and written entirely in Java (v. 1.8.0_231).The source code for the project can be found in the src/mymod1 directory. The source code has been appropriately commented wherever found necessary.

Team Members

Preview:

Below is the preview of different functionalities of the application.

Instructions for Inputs

  • All the input Attributes should be seperated by a comma ','.
  • For each functional dependency the left attributes and the right attributes should be seperated using a single arrow '->'.
  • New functional dependencies should be added from a new line ("Press Enter").

Home

Candidate Keys

The candidate keys can be obtained using the KEYS button. Keys

Highest Normal Form

To obtain the Highest Normal Form use the HNF button. Keys

Decomposition to X+1 Form

For decomposing the given relation to X+1 form use Decompose button. Only applicable upto to BCNF form. Keys

Closures

For closure of all possible combinations of the given attributes can be obtained from Closure button. Keys

About

A Java based application which takes functional dependencies as input and can identify the keys, highest normal form and can decompose it further.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages