Computer Science, asked by aarchi82, 10 months ago

tell this with proper explanation i will mark u as brainlist

Attachments:

aarchi82: plz teell

Answers

Answered by biswajit160501
2

》 the table name is ' Employee '.

》i think the datatype of exp.no. is 'auto number'

the data type of salary is 'number'

and others is 'text'.

》the 'exp.no ' attribute is the primary key of this table.

Answered by siddhartharao77
1

(i) Suggest a suitable name for the table and various fields.

Answer: Table name is 'Employee', the name of various fields is given.

(ii) Identify the data type of various fields in the table.

Answer: Varchar2, Varchar2, varchar, Varchar2, Varchar2, number.

(iii) Identify the primary key of the table.

Answer: Exp.No

Hope it helps!


aarchi82: explain ur 2 one answer
siddhartharao77: What doubt ur having in 2nd answer?
aarchi82: what is varchar here
siddhartharao77: varchar is a datatype in SQL.
siddhartharao77: varchar and varchar2 are datatypes!
aarchi82: oh tell me jn detail
aarchi82: beczz it is not in our syallabus
siddhartharao77: You can assign char datatype!
aarchi82: ok
Similar questions