Question

1. Given the following table: Product, Write the answers for the following
questions.
Quantity
12
Productno
1121
1132
1176
1156
1190
Product_name
Table
Sofa
Table
Chair
Sofa
Price
11000
78000
13000
4500
90000
13
12
7
8
a) For the above table identify the field that can be set as a Primary key
b) How many attributes and how many tuples are there in the above
table.
c) Write a SQL statement to display only the Product name and price
from the table Product
d) Write a SQL statement to insert one record into the table with the
following data ( 1189, Chair, 3000,7)​

Answer 1

Answer:

Given tha following table: product, write the answers for the following

Explanation:

(a) For the above table identify the field that can be set as a Primary key