Database normalization design pattern

  title={Database normalization design pattern},
  author={K.Uday Kumar and Sachindra Kumar Azad},
  journal={2017 4th IEEE Uttar Pradesh Section International Conference on Electrical, Computer and Electronics (UPCON)},
  • K.Uday KumarS. K. Azad
  • Published 1 October 2017
  • Computer Science
  • 2017 4th IEEE Uttar Pradesh Section International Conference on Electrical, Computer and Electronics (UPCON)
Normalization is a database design technique, which is used to design the Relational Database table up to higher normal form. The main aim of the database normalization approach is to reduce data redundancy and maintain the atomicity within the database table. In this paper, The Tabular approach algorithm method is introduced to generating candidate key from set a valid set of functional dependency. Once, it determines the candidate key of a database table from a given valid set of functional… 

Figures from this paper

Behavior Analysis using Serverless Machine Learning

This paper supplies a route for using the Watson Machine Learning API on IBM Cloud to carry out serverless data analytics using machine learning as a service. Transforming the large amount of data



Automatic database normalization and primary key generation

This paper presents a new complete automated relational database normalization method that produces the dependency matrix and the directed graph matrix, first, and proceeds with generating the 2NF, 3NF, and BCNF normal forms.

Algorithm for Relational Database Normalization Up to 3NF

An algorithmic approach for database normalization up to third normal form by taking into account all candidate keys, including the primary key, is proposed.

Database Systems: A Practical Approach to Design, Implementation and Management

This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical

Design Methodology for Relational Databases : Issues Related to Ternary Relationships in Entitiy-Relationship Model and Higher Normal Forms

This paper focuses on the issues related to modeling binary relationships, ternary relationships, decomposing ternARY relationships to binary equivalents and transforming the same to relations and proposed a methodology which database designers must follow during each phase of database design.

Normalizing Relational Database Schemas Using Mathematica

Basic relational database normalization algorithms are implemented efficiently as Mathematica modules and JMath-Norm provides an effective interactive tool in an educational setting for teaching DB normalization theory.

Database Systems A Practical Approach To Design Implementation And Management

Thank you for reading database systems a practical approach to design implementation and management, which shows how people have search hundreds of times for their chosen readings, but end up in malicious downloads.

Normal forms and normal theories in conditional rewriting

Localized Operational Termination in General Logics

The generalize the global notion of operational termination to this new setting and adapt the recently introduced OT-framework for mechanizing proofs of operationaltermination to support proofs of localized operational termination.

The Guide to the Software Engineering Body of Knowledge

The authors-who represent the project's editorial team-discuss the three-phase plan to characterize a body of knowledge, a vital step toward developing software engineering as a profession.