Mention the data type(text/number) of the following fields and also indicate the primary key:-
• 1. Index Number -------
• 2. English --------
• 3. Hindi -------
• 4. Maths -------
• 5. Name --------
• 6. Science -------
• 7. Total ------
Answers
1. Index number
The index number can be an int data type since it is a column that contains the index representation of the data in the table.
The following columns can be of int/decimal data type:
2. English
3. Hindi
4. Maths
6. Science
7. Total
They can have an int data type since it's gonna take in marks of students. It could be in decimal(s) too.
5. Name
The Name column can be in varchar data type, since names of students can be of varying lengths.
The primary key would be the Index Number column, since index numbers are usually unique and not repetitive. The subjects and Name on the other hand, have a slight possibility of being repeated a few times.
Answer:
1. Number
2. Number
3. Number
4. Number
5. Text
6. Number
7. Number
Explanation:
Mark me brainliest ☺️☺️☺️