Q. Create table Employee as per following Table Instance Chart.
Table --
Answer =
Create table Employee (
EmpID int(6) primary key,
EmpName Varchar(20) Not null,
EmpAddress varchar (20),
EmpPhone Varchar(10),
EmpSal int(9),
DeptID Varchar(2),
Foreign key (DeptID ) References Department (Dept_ID)
) ;
It's very usefull
ReplyDeleteAll answers are good from you it's very usefull for studenta
Yes, Thank you for all the answers, these are really very much helpful
DeleteWelcome 😊😊😊
Deletein empsal shoulnt we write decimal(9,2) as decimal is also mentioned in the question
ReplyDeleteYes, nd v should use float fr this...
DeleteHey!!! It' s my humble request please strat vedio explanation also
ReplyDeleteOk, I will upload SQL video very soon.
DeleteHi, should we create department table too for reference, since foreign key is involved.
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )