A group project, where I designed RDBMS aspects such as ER design, database population, DDL, DML, and where I co-developed the Flask app
-
Updated
Jun 5, 2024 - HTML
A group project, where I designed RDBMS aspects such as ER design, database population, DDL, DML, and where I co-developed the Flask app
Project focused on relational database structuring techniques, such as normalization, utilizing Oracle SQL and a PHP interface
A production-ready MySQL 8.0 database for a multi-seller E-commerce Marketplace. Features advanced SQL (Window Functions, CTEs), ACID transactions, database programmability (Procedures/Triggers), and performance index tuning.
Sample APIs for practice.
The project demonstrates the normalization process of a Healthcare Database from UNF to 3NF, addressing attributes like Patient Information, Drug Information, and Ward Management.
This repository contains Group 7's AoL project for COMP6799001 – Database Technology course. The project focuses on applying database normalization (UNF → 1NF → 2NF → 3NF) to the Food Delivery Time dataset, identifying anomalies, and designing a structured database including ERD visualization. (AoL score: 100, grade: A).
This is a database that stores information about car brands and models. The database has been normalized to comply with Third Normal Form (3NF), and its data is made available to users through a small web application.
The project focuses on applying Fourth Normal Form (4NF) to a Student Database, addressing issues like multivalued dependencies involving sponsors, referees, and supervisors.
This repository contains the design and implementation of the Bring Your Own Device (BYOD) System for managing personal devices at Life Insurance Company. It includes an ERD diagram, MySQL scripts for database creation, data insertion, and queries, as well as detailed data definitions and system requirements documentation.
Audited DBI202 group project: SQL Server cosplay rental database, ERD, normalization, T-SQL workflows and 46 executable tests.
Relational database design and implementation for a coffee-shop chain, covering ER modelling, normalisation, PostgreSQL, Db2, MySQL, views and data migration.
A relational database designed and implemented in Oracle SQL for a car rental business management system, featuring 17 normalized tables (3NF) and 10 complex operational queries.
A comprehensive implementation of the Life Insurance Co. BYOD system. Includes ERD, MySQL scripts for database creation and population, detailed data definitions, normalization documentation, and SQL queries for IT management analytics. Demonstrates best practices in database design and management.
SQL database schema normalizer (3NF && BCNF)
SQL database design for an online retail application including ER diagram, schema, normalization, and queries.
A RESTful API for a personal blogging platform, with full CRUD operations on posts, categories, and tags, plus search by term. Built as a practice project to reinforce MVC architecture concepts, database normalization, and REST API design best practices.
A collection of database management scripts and interactive shell programs built using PostgreSQL and Bash. Includes robust ETL pipelines, querying tools, and terminal-based applications.
Takes Database and Functional dependencies as Input and checks Normalization form and converts up to BCNF.
It contains DataBase-MongoDB Installation and Introduction and Basic Methods with Examples
Database Optimization using postgresSQL for Swiftride
To associate your repository with the database-normalization topic, visit your repo's landing page and select "manage topics."