QUESTION 2 a. Differentiate between ) Single value and multiple valued attribute. (i) Relational Database and Objected Oricnted Database b. What is a database? C. Consider the following relations with...


QUESTION 2<br>a. Differentiate between<br>) Single value and multiple valued attribute.<br>(i) Relational Database and Objected Oricnted Database<br>b. What is a database?<br>C. Consider the following relations with underlined primary keys<br>Product(PCode, Description, Stocking date, QDOnland MinQy, Price, Discount,<br>VCode)<br>Vendor(YCode, Name, Address, Phone)<br>Here a vendor can supply more than one product but a product is supplied by only one vendor.<br>Write SQL queries for the following<br>) List the names of all the vendors who supply more than one product.<br>(i) List the details of the products whose prices exceed the average<br>product price.<br>(ii) List the Name, Address and Phone of the vendors who are currently<br>Jof 4<br>

Extracted text: QUESTION 2 a. Differentiate between ) Single value and multiple valued attribute. (i) Relational Database and Objected Oricnted Database b. What is a database? C. Consider the following relations with underlined primary keys Product(PCode, Description, Stocking date, QDOnland MinQy, Price, Discount, VCode) Vendor(YCode, Name, Address, Phone) Here a vendor can supply more than one product but a product is supplied by only one vendor. Write SQL queries for the following ) List the names of all the vendors who supply more than one product. (i) List the details of the products whose prices exceed the average product price. (ii) List the Name, Address and Phone of the vendors who are currently Jof 4

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?