Skip to content

Repository files navigation

DATABASE-SCHEMA-NORMALIZATION

Transform Data Integrity, Unlock Seamless Innovation


🚀 Table of Contents


Overview

Database-Schema-Normalization is an innovative developer tool designed to simplify and visualize the complex process of database schema normalization. Built with React, TypeScript, Tailwind CSS, and Vite, it offers an interactive environment for designing schemas, analyzing functional dependencies, and ensuring data integrity through normalization standards.

Why Database-Schema-Normalization?

This project empowers developers to efficiently build, analyze, and normalize database schemas with ease. The core features include:

  • 🌱 Schema Builder: Create and modify database tables interactively, supporting dynamic schema design.
  • 🔍 Dependency Analysis: Visualize and manage functional dependencies to understand attribute relationships.
  • 🗝️ Candidate Key Finder: Identify minimal superkeys to ensure schema uniqueness and integrity.
  • 🔄 Normalization Logic: Validate and decompose schemas into higher normal forms like BCNF.
  • 🧩 Modular Architecture: Leverage React contexts for centralized state management, enabling scalable and maintainable development.
  • 💻 Modern UI Integration: Seamless setup with React, Tailwind CSS, and Vite for a responsive, developer-friendly experience.

Getting Started

Follow these steps to get a local copy up and running.

Prerequisites

  • Programming Language: TypeScript
  • Package Manager: npm

Installation

  1. Clone the repository

    git clone https://github.com/Jemin-s/Database-Schema-Normalization.git
  2. Navigate to the project directory

    cd Database-Schema-Normalization
  3. Install dependencies

    npm install

Usage

Run the project locally:

npm start

This will start the development server (usually at http://localhost:3000) and watch for changes.

Testing

This project uses the test_framework test framework. To run the test suite:

npm test

Built With

JavaScript React Vite TypeScript Tailwind CSS ESLint


Releases

Packages

Contributors

Languages