Database design for a price comparison site

Befejezett Kiadva: 6 hónapja Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

Hi! I am working on a relational database design and need someone with experience to double check and optimze my setup.

Project info:

- I have already setup a suggested database, without relations. The link is here: [login to view URL]

- I suggest buidling the database in [login to view URL] as I have already started there.

- I have attached JSON file swith all the data from another price comparison site, which can be used as background/template for designing the database

- I need the database design itself and code on how to create it in sql.

Basically I am looking to copy the abilities to these two price comparison sites:

[login to view URL]

[login to view URL]

About the database, it will contain for example:

- products

- webshops

- three levels of product categories

- search for products and categories

- users

- user reviews (of products)

- user notifications

- product reviews (by for example a magazine)

- delivery alternatives

- payment alterantives

- brands table

- price history

- images

- videos

- siblings products

- recommended products

- suggested products

++ Please have a look at the dbdiagram.io-table and json

What needs to be searchable/indexed (result = a list of products):

- Product names and description

- Categories (use case: show all products within a category)

- Brand names

Filtering on different settings/attributes must also be quick, for example if I just want products within a price interval from brand X.

I am open to suggestions on how to make this database 100% correct and optimized. This also applies to the tables different data types.

About me

Hobby programmer working as a project manager within IT. I am easy to work with and will answer quickly.

About you

You have experince setting up relational databases.

Technology

Probably I will use a mysql database.

MySQL SQL Szoftverarchitektúra

Projektazonosító: #37416674

A projektről

27 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 hónapja

Odaítélve:

alexvinnik

Hello. Your db looks fine. Only categories tables need to fix. Best regards

$200 USD 1 napon belül
(134 értékelés)
6.6

27 szabadúszó tett átlagosan 169$ összegű árajánlatot erre a munkára

globaltechnosys

Hi There, I have 9+ years of experience in PHP/MySQL, Laravel, CakePHP, Codeigniter, CorePHP, Yii, and Zend. Also, have a good eye for UI/UX, and design, My skills include configuration and setup, design, development, Továbbiak

$140 USD 7 napon belül
(37 vélemény)
6.7
kaindo2017

- Hi! I am Simon, a freelancer with 5+ years of experience and a holder in Bsc degree in computer science and a diploma in project management. I understand from your description that you are looking for someone to do Továbbiak

$140 USD 7 napon belül
(89 vélemény)
6.5
jayprakashyadav

HI I have more then 15 year’ experienced in development . As i am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build your project as soon a Továbbiak

$100 USD 7 napon belül
(24 vélemény)
6.2
ManzoorH

Thanks for considering me for this job. I am excited to work on your project! I understand from your description that you are looking for someone with experience in database design and optimization who can check and Továbbiak

$200 USD 7 napon belül
(20 vélemény)
5.5
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Továbbiak

$100 USD 1 napon belül
(8 vélemény)
4.2
ashiruddin

I have read your requirement,I am 10 years experienced database developer, designer,administrator,Database Programmer in MS SQL Server , MySQL, I am specialize in database design,analysis, report genration, dashboard Továbbiak

$500 USD 7 napon belül
(10 vélemény)
3.9
Muhammadzeesha59

Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Eclipse , Sql , Mysql ,Oracle , Object Oriented Programming , Data Structure , Alg Továbbiak

$40 USD 1 napon belül
(11 vélemény)
3.5
aleksisgsr

Hello, I'm a SQL developer with more than 10 years of experience. Over 5 years I worked as senior SQL Server developer in various companies. I design databases, schemas, indexes, constraints etc. I develop complex Továbbiak

$120 USD 7 napon belül
(4 vélemény)
3.6
Jennycreation

Hi there! I understand you are looking for someone with experience in database design and optimization to check and optimize your setup. My team has 13+ years of experience in Asp.net Web, Window and Android developmen Továbbiak

$250 USD 7 napon belül
(0 vélemény)
0.0
sabir021

Hi, I'll enhance your setup to replicate the functionalities of leading price comparison sites. Leveraging my experience, I'll ensure efficient relationships and quick search capabilities. Let's build a high-performing Továbbiak

$120 USD 15 napon belül
(0 vélemény)
0.0
muhammadsaifisb

Hi sir I'm professional web developer and database handler. I read your requirements. I done your work within 40 hours in 110 usd.

$110 USD 2 napon belül
(0 vélemény)
0.0
leoe

Hi Magnus, I've seen your diagram, there are several fixes that I suggest to do, for example: Instead of having 3 tables, category, subcategory, subcategory2, it's a better practice to have only one that points to a r Továbbiak

$140 USD 1 napon belül
(0 vélemény)
0.0
abs674

Hi there, Can you please provide me with the link to your current database setup? I would like to review it and see if there are any optimizations that can be made. Also, could you let me know if there are any specif Továbbiak

$150 USD 7 napon belül
(0 vélemény)
0.0
kristianw08

hi my name is kristian i'm interest with the project basicly im a programmer too, i have question about table Image list, why not make into 1 table to "Table Image"? i usually develop for ERP System And POS System im Továbbiak

$140 USD 7 napon belül
(0 vélemény)
0.0
josecarlnivore

Hello, I have a 5 year experience in database design and implementation using MySQL. I am skilled in optimizing databases, and If you take a look at my profile, you will see that I have just a few skills, that is becau Továbbiak

$140 USD 7 napon belül
(0 vélemény)
0.0
ndambukiboniface

Greetings Dear Client, Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Clie Továbbiak

$250 USD 1 napon belül
(0 vélemény)
0.0
fazalimamnuttkan

Hi there! My name is Fazal and I am a software engineer with expertise in Power BI/ Business Intelligence / Data Analysis / Power BI / NetSuite. I have 10 years of experience working with these technologies. I read y Továbbiak

$140 USD 7 napon belül
(0 vélemény)
0.0