Relational Database Management system

Product (code-prod, name,prix)
Stock (code-prod, code -dep, quantity)
Depot (id-dep-adr)
Label the primary and foreign keys
Populate the table with random values but follow the primary and foreign key constraints.

1 answer

Product table:
- Primary key: code-prod
| code-prod | name | prix |
|-----------|--------|------|
| 1 | Apple | 2.5 |
| 2 | Banana | 1.5 |
| 3 | Orange | 3.0 |

Stock table:
- Primary keys: code-prod, code-dep
- Foreign keys: code-prod (references Product.code-prod), code-dep (references Depot.id-dep-adr)
| code-prod | code-dep | quantity |
|-----------|----------|----------|
| 1 | 1 | 100 |
| 2 | 2 | 50 |
| 3 | 1 | 75 |

Depot table:
- Primary key: id-dep-adr
| id-dep-adr |
|-----------|
| 1 |
| 2 |
Similar Questions
  1. Product (code-product, Name-product, price);Stock (code-product, code-Dep, quantity); Depot (code -id, address); 1.Create sql
    1. answers icon 1 answer
  2. int carry=0;int prod,i,j,rem; int base=10; else if ( op == '*' ) //checks for operator, performs array multiplication {
    1. answers icon 2 answers
  3. What is the purpose of a version control system?to store copies of all of the previous versions of the code to make code more
    1. answers icon 1 answer
  4. What kind of code runs on routers and switchesfront end code back end code quality assurance code networking code
    1. answers icon 1 answer
more similar questions