A departmental store MyStore is considering to maintain their inventory using SQL to store the data. As a
database administer, Abhay has decided that :
Name of the database - mystore
Name of the table - STORE
The attributes of STORE are as follows:
Item_no Qty I_name I_code Price
a) How we open/enter in database named mystore. 1
b) Write candidate key(s) from table STORE 1
c) What is the degree and cardinality of above table 1
d) Write insert command which insert data given below in above table 1
23, 40, ”shirt”, ‘s_001’, 500
e) Which command is used to remove table from database mystore. 1
Answers
Answered by
0
Answer:
bbnnkkkzamakKKKKkakakkai
Similar questions
Hindi,
2 months ago
Social Sciences,
2 months ago
Math,
2 months ago
Social Sciences,
5 months ago
Science,
5 months ago
Math,
11 months ago
Biology,
11 months ago
Physics,
11 months ago