Meemansha Priyadarshinimeemansha.hashnode.dev·Nov 18, 2024Deciding Between Standardization and Normalization: Key GuidelinesWhen working on Machine Learning projects, we often need to adjust the data to make algorithms run faster and more efficiently. This adjustment involves methods like Normalization and Standardization. Normalization $$X normalized = X-Xmin/Xmax- Xmin$...1 likestandardization
prajwal motghareblogs29.hashnode.dev·Nov 14, 2024Database Normalization: Ensuring Data Integrity and EfficiencyAbstract Database normalization is essential for designing efficient and consistent relational databases. This paper explores the principles, benefits, and stages of normalization, providing practical examples for better understanding. 1. Introducti...Databases
Nathan Kaduruhimwhowrote.hashnode.dev·Oct 28, 2024Understanding Database Design and Modeling: From ER Diagrams to UML and Class StructuresIf you’re stepping into database design and modeling for the first time, concepts like Entity-Relationship diagrams, Normalization, UML, and Class Diagrams might sound intimidating. But once you understand the basics, these tools will make organizing...Databases
Kshitij Shresthkshitijshresth.hashnode.dev·Sep 29, 2024Mathematical TransformersWhen dealing with data, transforming columns using mathematical functions can significantly improve the performance of machine learning models. By applying various transformations, we can adjust the probability density function of our data to approxi...10 likestransformers
Cañete,Brandon L.git-fundamentals-documentation.hashnode.dev·Sep 27, 2024Normalize the Denormalize tableStudent Table Course Table Department Table Project Table Scholarship Table ExtracurricularActivities Table Advisor Table Attendance Table Tables Relationship I normalized this table by breaking a one student table to multiple tables like c...normalization
Cañete,Brandon L.git-fundamentals-documentation.hashnode.dev·Sep 25, 2024Normalizing Denormalized Data Using ExcelemployeeData Sheet: projectData Sheet: managerData Sheet: departmentData Sheet: studentData Sheet: classData Sheet: teacherData Sheet: courseData Sheet: guardianData Sheet: productData Sheet: categoryData Sheet: supplierData Sheet: wareho...3 likesMySQL
Cañete,Brandon L.git-fundamentals-documentation.hashnode.dev·Sep 20, 2024Normalization and Denormalization in DatabasesIn this Research we will understand the differences between Normalization and Denormalization in Databases What is Normalization? The purpose of normalization in database design is to organize data to minimize redundancy and improve data integrity. ...3 likes·34 readsnormalization
Thirdy Gayaressoftware-engineer.thirdygayares.com·Sep 15, 2024Activity: Normalizing Denormalized Data Using ExcelIn this activity, you will take 5 denormalized datasets and normalize them using Excel. You will generate 5 tables, each containing at least 25 columns. The goal is to split the data into multiple tables to follow database normalization rules using E...27 readsActivitynormalization
Thirdy Gayaressoftware-engineer.thirdygayares.com·Sep 13, 2024Normalization and Denormalization in DatabasesWhat is Normalization? Normalization is a method used in organizing data inside a database. It breaks down big tables into smaller, simpler tables and links them. This method helps avoid duplicate data and ensures that all data is stored clearly and ...MySql Databasedenormalization
Muhammad Abdiel Al Hafizabdiel.hashnode.dev·Sep 7, 2024Pentingnya Normalisasi Database untuk Konsistensi dan Integritas DataData yang konsisten dan akurat merupakan fondasi dalam pengambilan keputusan yang tepat. Untuk memastikan data tetap terstruktur dengan baik dan terhindar dari inkonsistensi, salah satu teknik penting yang digunakan adalah normalisasi. Teknik ini san...1 like2NF