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

Answer:

a) USE MyStore

b) Item_no, I_code

c) Degree: 5, Cardinality: 0 (Since the table has no values entered in it)

d) INSERT INTO MyStore VALUES(23,40, 'shirt','s_001',500);

e)DROP TABLE MyStore