1. There are tables: SHOPS (S NUM, S NAME, S_TYPE) and GOODS (G NUM, G NAME, G TYPE, G PRICE, SHOP NUM). Create object view to achieve shops names and count of goods in shop. Show transcribed image text
Expert Answer
An answer will be send to you shortly. . . . .