Question

plz answer fast plz plz plz​

Answer 1

The primary key would be Emp_Co‎de.

A primary key is a constraint that uniquely identifies values, i.e., no values are/will be repeated. It helps in eliminating data redundancy.

Since none of the values in Emp_Co‎de is repeated and they're unique, it would be considered as the primary key.

The most suitable data type for the Designation field would be varch‎ar(30), since there is no specific character limit on the data it contains.

The most suitable data type for the Salary field would be int(6), or simply int as the Salary amount could still be increased.

The query to display all the records of the table Employee where the age is greater than or equal to 35 is as follows:

Select * from Employee where Age >= 35;

The asterisk represents all the data from the table.