Question

Write following queries: a) Create a Database COMPANY. 1 b) Open the currently created Database. 1 c) Create a table Dept(DeptNo, DeptName). Make DeptNo as Primary Key.2 d) Create a Table EMPLOYEE(EmpId, EmpName, EmpSal, Empdeptt,Grade). Make EmpId as Primary key and Empdeptt as Foreign Key which will refer DeptNo of Dept table. 3 e) Display Structure of both the table.

Answer 1

hope it will help you in solving your question