/sql-nf-checker

A Python script to check of Normalization forms with SQL

Primary LanguagePythonGNU General Public License v3.0GPL-3.0

sql-nf-checker

A Python script to check of Normalization forms with SQL

Input

Example of valid python call: "python p2v.py database=input.txt"

Output

Failed column lists which normal form failed A blank space indicates passing normal form checks '---' indicates a more severe error such as query failure

Links to helpful sites, referenced code, sourced code

https://stackoverflow.com/questions/3277503/how-do-i-read-a-file-line-by-line-into-a-list https://stackoverflow.com/questions/663171/is-there-a-way-to-substring-a-string-in-python https://github.com/uber/vertica-python/blob/master/vertica_python/vertica/cursor.py https://stackoverflow.com/questions/2872512/python-truncate-a-long-string https://stackoverflow.com/questions/40080375/get-column-names-title-from-a-vertica-data-base https://stackoverflow.com/questions/36924137/how-to-return-errors-from-pyodbc https://stackoverflow.com/questions/23681453/finding-a-relation-in-3nf-but-not-in-bcnf https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form https://github.com/craned/cosc6340-Project-1 https://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html https://www.1keydata.com/database-normalization/