Canadian Conference on Electrical and Computer Engineering , 2008-05-05

Title : ( AUTOMATIC DATABASE NORMALIZATION AND PRIMARY KEY GENERATION )

Authors: Mahmoud Naghibzadeh ,

Citation: BibTeX | EndNote

Abstract

Normalization is the most exercised technique for the analysis of relational databases. It aims at creating a set of relational tables with minimum data redundancy that preserve consistency and facilitate correct insertion, deletion, and modification. A normalized database does not show anomalies due to future updates. It is very much time consuming to employ an automated technique to do this data analysis, as opposed to doing it manually. At the same time, the process is tested to be reliable and correct. This paper presents a new complete automated relational database normalization method. It produces the dependency matrix and the directed graph matrix, first. It then proceeds with generating the 2NF, 3NF, and BCNF normal forms. All tables are also generated as the procedure proceeds. One more side product of this research is to automatically distinguish one primary key for every final table which is generated.

Keywords

, Relational Database, Functional Dependency, Automatic Normalization, Primary Key
برای دانلود از شناسه و رمز عبور پرتال پویا استفاده کنید.

@inproceedings{paperid:1007113,
author = {Naghibzadeh, Mahmoud},
title = {AUTOMATIC DATABASE NORMALIZATION AND PRIMARY KEY GENERATION},
booktitle = {Canadian Conference on Electrical and Computer Engineering},
year = {2008},
location = {Niagra falls},
keywords = {Relational Database; Functional Dependency; Automatic Normalization; Primary Key},
}

[Download]

%0 Conference Proceedings
%T AUTOMATIC DATABASE NORMALIZATION AND PRIMARY KEY GENERATION
%A Naghibzadeh, Mahmoud
%J Canadian Conference on Electrical and Computer Engineering
%D 2008

[Download]