E-commerce Project Consulting & Database Architecture

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

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.

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.

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

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;

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.

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

productId 346 350 356 358 orderNo 0.0 1 0 0 1 1.0 0 1 0 0 2.0 1 0 1 0

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