Departmental store MyStore is considering to maintain their inventory

1.	Departmental store MyStore is considering to maintain their inventory using SQL to store the data. As adatabase 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 Pricea) How we open/enter in database named mystore. 1b) Write candidate key(s) from table STORE 1c) What is the degree and cardinality of above table 1d) Write insert command which insert data given below in above table 123, 40, ”shirt”, ‘s_001’, 500e) Which command is used to remove table from database mystore.
Answer» EXPLANATION: gshhdhdjdjejjfjdjjjjrjfjrj

Departmental store MyStore is considering to maintain their inventory using SQL to store the data. As adatabase 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 Pricea) How we open/enter in database named mystore. 1b) Write candidate key(s) from table STORE 1c) What is the degree and cardinality of above table 1d) Write insert command which insert data given below in above table 123, 40, ”shirt”, ‘s_001’, 500e) Which command is used to remove table from database mystore.

Answer»

gshhdhdjdjejjfjdjjjjrjfjrj