E-commerce Project Consulting & Database Architecture

Jeffrey Beyo

Intro

Halledersin.com is a website which allows users to create or read repair guides for any tech device and buy components needed for repair.

Consulting

The system is dividid in 3 main parts: end-user website, web panel for stores and web panel for administration. First, a software requirement in IEEE standart is made to ensure customer's needs and software engineer's work.

Software Requirements

This document includes
Customer's requirements
Wireframes
Data Model
E/R Diagrams
Use-case scenarios and many other specifications.
Our consultancy service provides innovative perspectives from in-depth technical expertise. A good software requirement and modeling will give a better understanding to your software engineer and create the architecture of the project.

Database Architecture

The complete database architecture is given below and includes 30 tables, 10 views, 60 store procedures and 4 functions.

Optimization

We also did performance tests in order to optimize complexity and accuracy.
DECLARE random_price int; DECLARE random_category int; DECLARE random_stock int; DECLARE i int DEFAULT 1; WHILE i <= data_number DO SET random_price = randomIntBetween(5,150); SET random_category = randomIntBetween(78,80); SET random_stock = randomIntBetween(0,1); INSERT INTO products (name, price, categoryId, storeId, isInStock) VALUES (CONCAT("product name ",i) , random_price , random_category , 1, random_stock); SET i = i + 1; END WHILE;
=> MySQL procedure that generates bulk products with a given quantity

Data Analysis

We have also did a realtime data mining project in order to learn frequent products bought together. We have used "apriori" machine learning algorithm and made a frequent pattern mining.
Results:
antecedents consequents antecedent support consequent support support confidence lift leverage conviction 0 (346) (356) 0.666667 0.333333 0.333333 0.5 1.5 0.111111 1.333333 1 (356) (346) 0.333333 0.666667 0.333333 1.0 1.5 0.111111 inf 2 (346) (358) 0.666667 0.333333 0.333333 0.5 1.5 0.111111 1.333333 3 (358) (346) 0.333333 0.666667 0.333333 1.0 1.5 0.111111 inf
Orders Matrix:
productId 346 350 356 358 orderNo 0.0 1 0 0 1 1.0 0 1 0 0 2.0 1 0 1 0

Project Management

All of the project process has been tracked with Trello task management system:
Like this project

Posted Mar 28, 2021

Secret Social Network Project Development
Secret Social Network Project Development
Landing Page: Boğaziçi University Online English School
Landing Page: Boğaziçi University Online English School

Join 50k+ companies and 1M+ independents

Contra Logo

© 2025 Contra.Work Inc