Observe the following table and answer the question (a) to (e) (Any 04) TABLE: VISITOR VisitorID VisitorName Contact Number V001 V002 ANAND AMIT SHYAM MOHAN 9898989898 9797979797 9696969696 9595959595 V003 V004 (a) Write the name of most appropriate columns which can be considered as Candidate keys? (b) Out of selected candidate keys, which one will be the best to choose as Primary Key? (c) What is the degree and cardinality of the table? (d) Insert the following data into the attributes VisitorID, VisitorName and ContactNumber respectively in the given table VISITOR. VisitorID cor|D=v004^ s , VisitorName= "VISHESH" and Contact Number9907607474 nber = 990 (e) Remove the table VISITOR from the database HOTEL. Which command will he used from the following: a) DELETE FROM VISITOR; b) DROP TABLE VISITOR
Answers
Answered by
1
Answer:
b
Explanation:
Similar questions