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)
) ;

8 Comments

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

  1. It's very usefull
    All answers are good from you it's very usefull for studenta

    ReplyDelete
    Replies
    1. Yes, Thank you for all the answers, these are really very much helpful

      Delete
    2. Welcome 😊😊😊

      Delete
  2. in empsal shoulnt we write decimal(9,2) as decimal is also mentioned in the question

    ReplyDelete
    Replies
    1. Yes, nd v should use float fr this...

      Delete
  3. Hey!!! It' s my humble request please strat vedio explanation also

    ReplyDelete
  4. Hi, should we create department table too for reference, since foreign key is involved.

    ReplyDelete

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post