Question

22
A company, Sunrise Ltd. Is considering to manage the records of their employees using SQL
to store the data. As a database administrator, Harish has decided that:
Name of the database: Employee
Name of the table : Empl
The attributes of Empl are as follows:
Empld - Numeric
Empname - character of size 20
Salary - Numeric
Date_of_Joining - Date
Empld
1001
1002
1004
1008
1006
1005
Empname
Mr. Khanna
Mr. Roy
Ms. Sehgal
Mr. Pahwa
Ms. Sharma
Mr. Bhalla
Salary
50000
35000
25000
30000
20000
25000
Date_of_Joining
23-10-2018
22-04-2017
23-08-2016
15-10-2019
14-12-2019
12-09-2020
1
1
1
1
(a) Identify the attribute best suitable to be declared as a primary key.
(b) write the degree and cardinality of the table Empl.
(c) Harish want to delete all the records of the table Empl. Structure of the table
should not be removed. Write the query for the same.
(d) Write a query to increase the salary of all the employees by 5000.
(e) Harish wants to see the structure of the table 'Empl'. Help him to do the same.
1
222
consider the following Data frame dhand answer any four questions from ito​

Answer 1

refer to the attachment