Question

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.​

Answer 1

Explanation:

gshhdhdjdjejjfjdjjjjrjfjrj