The following table contains the data of courses offered by a computer Training Academy. Create
the following table in your notebook and answer the given questions based upon the table.
T_ID Dep_ID Course_ID Students_Name Category
101 001 00A_Base Manisha Software
102 002 00B_Calc Samsheer Software
103 001 00A_PHP Christina Software
104 003 00C_Writer Sunena Software
105 002 00D_Java Md. Yusuf Software
106 004 00E_Python Babita Software
107 001 00D_ASP Nikhil Software
5M
a What is the Degree(total number of attributes) of a table.
b What is the Primary key in above table?
C How many candidate keys are there in above table?
d What is the cardinality( Total number of records excluding heading ) of the table?
e Mention any two Field names of the table.l
Answers
105 002 00D_Java Md. Yusuf Software
106 004 00E_Python Babita Software
107 001 00D_ASP Nikhil Software
Explanation:
The following table contains the data of courses offered by a computer Training Academy. Create
the following table in your notebook and answer the given questions based upon the table.
T_ID Dep_ID Course_ID Students_Name Category
101 001 00A_Base Manisha Software
102 002 00B_Calc Samsheer Software
103 001 00A_PHP Christina Software
104 003 00C_Writer Sunena Software
105 002 00D_Java Md. Yusuf Software
106 004 00E_Python Babita Software
107 001 00D_ASP Nikhil Software
5M
a What is the Degree(total number of attributes) of a table.
b What is the Primary key in above table?
C How many candidate keys are there in above table?
d What is the cardinality( Total number of records excluding heading ) of the table?
e Mention any two Field names of the table.l