S
S
Segio2019-02-03 22:40:14
Database design
Segio, 2019-02-03 22:40:14

Are the relationships between the tables correctly created?

There is a database with tables:

  • suppliers
  • product
  • type of clothing
  • the size
  • Colour

According to the task, you need to create links between them. It turned out like this...
5c5743570390e927958864.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-02-03
@tsklab

It is unlikely that different suppliers bring the product at the same price. Price in the product supply table (ProductSupplier).
If the supplier brings the product several times, then add the date and quantity to the delivery table (ProductSupplier).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question