Mr Manav a database administrator in “Global educational and training Institute” has created following table named “Training” for the upcoming

Mr Manav a database administrator in “Global educational and training Institute” has created following table named “Training” for the upcoming training schedule
Training – Id / Name/ Email – Id /Topic/ City/ Fee/
ND01 /Ms. Rajan /[email protected] /Cyber Security/ New Delhi/ 10000 /
1. Write a command to create the table?
2. Name the candidate keys of the table?
3. What will be the datatype of table?
4. What is the degree and cardinality of table?
5.Write commands to insert rows for Mr Vinay and Mr Urvashi?
Subject: Infomatics Practices

Leave a Reply