Objective:
To develop a program that takes a dataset (relation) and functional dependencies as input, normalizes the relations based on the provided functional dependencies, produces SQL queries to generate the normalized database tables, and optionally determines the highest normal form of the input table.
Dataset (Relation)
Functional Dependencies
Choice of the highest normal form to reach (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
Option to find the highest normal form of the input table
SQL Queries to generate the normalized database tables.
The highest normal form of the input table (if opted).
Input Parser: To parse the input dataset and functional dependencies.
Normalizer: To normalize the dataset based on functional dependencies.
SQL Query Generator: To generate SQL queries for normalized tables.
Normal Form Finder: To find the highest normal form of the input table.
Source Code: Well-commented source code in the language of your choice.
Code Description: Detailed documentation describing the flow, logic, and methodology of the code.
Output File: A text file containing generated SQL queries and the highest normal form of the input table (if opted)