[solved]-Consider Following Relation Stock Primary Key Stock Prodid Depid Please Answer Quickly Tha Q39032075

We consider the following relation Stock. The primary key ofStock is prodid, depid. please answer quickly. thanks

prodid

depid

prodname

quantity

p1

d1

vcr

10

p1

d2

vcr

20

p2

d3

tv

30

1. What are the ids of the depots? (Relational algebra)
2. What are the products (ids) in stock (quantity > 0) ?(Relational algebra)
3. What is the average quantity of the products in Stock?(SQL
4. What is the average quantity of EACH productin Stock? (SQL)
5. What are the functional dependencies for Stock?
6. What are the problems of a table such as stock? Think aboutnormalization
7. Is Stock 3BNF?
8. Is Stock BCNF?

Expert Answer

---

Answer to We consider the following relation Stock. The primary key of Stock is prodid, depid. please answer quickly. thanks prodi… . . .