39 results for “topic:3nf”
Designed and Developed a comprehensive Database Management System for a modern Pharmacy.
A case study about designing simple database system for a bookstore. This repository contains ERD design and SQL codes for design of bookstore database system. The main purpose of this system is to build database system for bookstore.
3NF-normalize Yelp data on S3 with Spark and load it into Redshift - automate the whole thing with Apache Airflow
Program which normalize relation scheme to 3NF.
In this project, we are designing the database for the Graphics Design School named ‘Nexus’. A proper methodology of database systems has been followed starting with designing an ER Diagram for the database till the normalization of the schema till 3NF.
A tool for database analysis
This was a semester-long project in which we were given a description of a database that a client needed. We then went through the process of creating a conceptual EER model, then refined it into a relational model, then converted the relations into 3NF, and then actually created the sql statements with triggers. We also created queries and views.
Учебный проект по курсу “Системная аналитика DWH”, онлайн-школа T1
Designed and implemented an end-to-end ETL pipeline using PostgreSQL, transforming raw transactional data into a normalized OLTP schema (3NF) and analytical OLAP star schema. Generated business insights through complex SQL queries and ensured data integrity through validation checks.
A toolset for database analysis as bottom up approach
The project demonstrates the normalization process of a Healthcare Database from UNF to 3NF, addressing attributes like Patient Information, Drug Information, and Ward Management.
Designed a SQL Database/Schema for a Car Rental System. It was created on an Oracle 11g Database. The project features Entity-Relationship Design, Functional Dependency Theory, 3NF/BCNF principles, SQL Code, Bash Scripting
The System designed in 3NF, comprises entities such as Guests, Rooms, Bookings, and Updates. It optimally organizes guest reservations, room availability management, payment handling, and improves customer experience with real-time updates and personalized services.
Developed a program that Generates SQL Statements to Check Normalization in One Table and Normalize It If Needed. [Python and PostgreSQL]
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.
Conception et implémentation d’une base de données immobilière : modélisation (MCD/MLD), dictionnaire de données, chargement des tables et requêtes d’analyse.
SQL file for HouseBoat Mnagement System-Normalized-All features-Queries
A complete, production-ready database schema for an AirBnB. Features a fully normalized (3NF) PostgreSQL design with UUID primary keys, comprehensive constraints, sample data, and detailed documentation. Includes tables for users, properties, bookings, payments, reviews, and etc. with proper foreign key relationships and business rule enforcement.
SQL Database Normalization and Advanced Queries
A comprehensive MySQL database implementation for event planning and management with normalized schema, sample data, and complex queries.
Database design for a Spotify like music and podcast application based on given business requirement
End-of-course database project designing and implementing a Hospital Management System, including ERD modeling, normalization to 3NF, SQL schema creation, data population, queries, and Power BI for gain useful insight for hospital operations (patients, doctors, appointments, staff, medical records, and billing).
A production‑style conversion of a grocery spreadsheet into a normalized relational database
Final Assignment for DBS201(Summer 17)
A scalable PostgreSQL database (3NF) designed to replace manual Excel workflows. Includes a GDPR-compliant architecture and analytical SQL views.
This project analyzes video game sales data (1980-2020) using SQL and Tableau. The dataset includes game sales by platform, genre, publisher, and region. The project covers data preprocessing, SQL queries for insights, and a Tableau dashboard visualization.
No description provided.
A highly normalized (3NF) Manufacturing Resource Planning (MRP) engine built on Oracle 19c. Features recursive BOM traceability, bare-metal JDBC transaction control, and polymorphic entity modeling.
Designed and implemented a 3NF schema (9 entities) with Table-per-Type inheritance, plus 2 analytical views, 2 stored procedures, and a trigger enforcing stock validation and price stamping. Includes seed data and a Docker setup with Adminer for quick demo.
In the following application are given directory paths of where the client-side system is storing data files based on a music application product. I analyzed the data, build its entities and form the basic link between them. The analytics team is particularly interested in understanding what songs users are listening to