A
A
Artemy2018-01-29 13:23:02
Database design
Artemy, 2018-01-29 13:23:02

How to create a database for a store aggregator?

The meaning of what I want - Yandex.Market
We have ten drugs
We have four pharmacies
Each pharmacy sells at least one drug
Each pharmacy has its own price for each drug
The end application gives a list of drugs with a list of their price tags
I don't understand how to this build the database. Where should we write price tags?
I rush between "Price tags in the drug table" and "Price tags in the store table", and something tells me that both options are wrong.
If you can show an infological model, then it will be chic in general.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question