Back to search

University of North Florida. School of Computing

Generating a Normalized Database Using Class Normalization

Abstract

dc:description.abstract

Relational databases are the most popular databases used by enterprise applications to store persistent data to this day. It gives a lot of flexibility and efficiency. A process called database normalization helps make sure that the database is free from redundancies and update anomalies. In a Database-First approach to software development, the database is designed first, and then an Object-Relational Mapping (ORM) tool is used to generate the programming classes (data layer) to interact with the database. Finally, the business logic code is written to interact with the data layer to persist the business data to the database. However, in modern application development, a process called Code-First approach evolved where the domain classes and the business logic that interacts with the domain classes are written first. Then an Object Relational Mapping (ORM) tool is used to generate the database from the domain classes. In this approach, since database design is not a concern, software programmers may ignore the process of database normalization altogether. To help software programmers in this process, this thesis takes the theory behind the five database normal forms (1NF - 5NF) and proposes Five Class Normal Forms (1CNF - 5CNF) that software programmers may use to normalize their domain classes. This thesis demonstrates that when the Five Class Normal Forms are applied manually to a class by a programmer, the resulting database that is generated from the Code-First approach is also normalized according to the rules of relational theory.

Degree

thesis:*
Name thesis:degree_name
Master of Science in Computer and Information Sciences (MS)
Discipline thesis:degree_discipline
Computing
Grantor
University of North Florida. School of Computing
Date dc:date.issued
Spring

Author and committee

dc:creator, dc:contributor.*
Authors dc:creator
  • Sudhindaran, Daniel Sushil
  • Sudhindaran, Daniel, 1985-
Advisors dc:contributor.advisor
  • Roggio, Robert
  • Elfayoumy, Sherif
  • Reddivari, Sandeep
Contributors dc:contributor
  • Dr. Robert Roggio
  • Dr. Sherif Elfayoumy
  • Dr. Sandeep Reddivari

Subjects

dc:subject × 7

Rights

dc:rights

Identifiers

dc:identifier.*
Repository record dc:identifier
https://digitalcommons.unf.edu/etd/727

Chain of custody

source
Harvested from
University of North Florida
Base URL
digitalcommons.unf.edu/do/oai/
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
citation

Sudhindaran, Daniel Sushil; Sudhindaran, Daniel, 1985-. Generating a Normalized Database Using Class Normalization. University of North Florida. School of Computing, https://digitalcommons.unf.edu/etd/727