Problem StatementWe have created employee and department tables with the below definition without adding foreign key relationTo maintain data integrity in the database, you are required to link the 'departmentId' from the 'department' table with the 'deptId' column in the 'employee' table. This is achieved by establishing a foreign key relationship between the two columns.Write an ALTER query for the 'employee' table to create a foreign key named 'deptIdFk,' referencing 'departmentId' from the 'department' table.Note:Write table name/ column name as given.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the detailed description of the employee table.Refer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :Field Type Null Key Default Extraid int NO PRI NULL name varchar(100) YES NULL address varchar(100) YES NULL age int YES NULL dob date YES NULL deptId int YES MUL NULL

Write a query for the following.employee(eid,name, salary, address) department(d_id, d_name, eid)Give Primary Key, foreign key constraints after creating table with constraint names in given schemas.(1) Create a view department_details of department table.(2) Join two existing tables using inner join.(3) To drop a view

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?Select one:a.Use the ALTER TABLE command with the MODIFY clause on the DEPT table.b.This task cannot be accomplished.c.Use the ALTER TABLE command with the MODIFY clause on the EMP table.d.Use the ALTER TABLE command with the ADD clause on the EMP table.e.Use the ALTER TABLE command with the MODIFY clause on the EMP table.

Assume you have two tables in a database: employees and departments.employees table:employee_id (Primary Key)namedepartment_id (Foreign Key referencing departments.department_id)departments table:department_id (Primary Key)department_nameNow, write an SQL query to retrieve the names of employees along with their corresponding department names.

To create a relationship between two tables, the attributes that define the primary key in one table must appear as attributes in another table, where they are referred to as a foreign key

Problem StatementIn a company's Employee Management System, a database table named "Employees" that stores information about employees, including their EmployeeID, EmployeeName, Department, and Salary.The HR department needs a mechanism to delete employee records from the system when an employee leaves the company or for any other valid reason. To address this requirement, you are tasked with creating a stored procedure named "DeleteEmployee," which takes an EmployeeID as input and deletes the corresponding employee record from the "Employees" table.The following table is already created, and the records are inserted into the table.TABLE: Employees EmployeeID INT PRIMARY KEY, EmployeeName VARCHAR(50), Department VARCHAR(50), Salary DECIMAL(10, 2)Prepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The stored procedure deletes the employee record based on the provided EmployeeID.The output should display the employee details after deletion as shown below.EmployeeID EmployeeName Department Salary1 John Doe IT 60000.002 Jane Smith HR 55000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00EmployeeID EmployeeName Department Salary1 John Doe IT 60000.003 Bob Johnson Marketing 70000.004 Alice Williams Finance 80000.00Refer to the sample output for the column headers.