Shivali has to answer some questions based on the following table structure. Help her in ansy what isa Database
them:
Emp_id
Salary
Emp_name Date of joining
Project_name
Payroll_system
Differentiate bety
Rajesh
18/11/2015
A001
20000
Designation
Project
associate
Project lead
Project
manager
Mans
10/06/2012
MIS
A002
45000
Shruti
30/07/2014
Employee_management
A003
35000
Identify the data type for the following fields:
Define Tables
Emp_ld
Date_of_joining
Salary
(0) List the employees as per their salaries, displaying the highest paid person at the top and the lowest paida
at the bottom
What are
(1) Set the maximum number of characters to be entered in the field Project name.
(v) Which field can become the Primary key?
Answers
Answered by
3
Answer:
Highest paid : "Mansi''
Lowest paid : "Rajesh"
Explanation:
Similar questions