Database design for a price comparison site
$30-250 USD
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.
Projektazonosító: #37416674
A projektről
Odaítélve:
27 szabadúszó tett átlagosan 169$ összegű árajánlatot erre a munkára
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
- 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
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
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
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
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
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
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
Hi sir I'm professional web developer and database handler. I read your requirements. I done your work within 40 hours in 110 usd.
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
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
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
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