Question

write the answers based on the following a suggest a suitable data type for the feild empid and name in table employee
b. write query to desplay all the record in the table for deptid =101
c. add a new record the following details (7 chander makhiija ,102, MCA,M

Answer 1

a) Data type is Alphanumeric

b)select* from Employee where deptid='101'

c) INSERT INTO EMPLOYEES (

"Empid", "Name", "Deptid", "Qualification")

VALUE('7','Chandar Makhiija', '102' , 'MCA');

DO MARK THIS ANSWER AS THE BRAINLIEST ANSWER

Answer 2

emp id: id is most likely to be unique so it is preferable to go for int .

name: varchar

b. select*from employee where deptid=101;

c.insert into employee values(7,"chander makhiija", 102, "MCA",'M');