Question

a.
1. Look at the table given here and answer the following:
How many records and fields are there in the table?
b. What is the data type of ID field?
Do you think it is a primary key?
How are the numbers 1, 2, ..., etc,
Cars
ID
Model
1 Vento Highline
2 Santro XO
Cost
Company
*9,80,000.00 Volkswagon
*4,50,000.00 Hyundai
C.
entered in the ID field?​

Answer 1

Answer:

correct answer is B what is the data type

Answer 2

The datatype of the ID field in the table is the int.

And the integer id is the primary key , because it has unique values in it.

Explanation:

The ID numbers in the table are entered as 1,2,3,.... this values are unique values.

They are inserted as the primary key, the duplicate values are not allowed in the primary key.

The table as contents like ID, Model, Cost and Company.

The other values in the table can be same, means one or more types of the vehicle's Model can be not same but at the same time the cost and the company can be same.

But here ID is assigned so that the record remains easy to identify.