Question

Employee
Emplo EmpName JobTitle
1 Shreya Mehta Manager
2 Monica Desai Clerk
(New)
i. Which sorting has he applied to the SalesmanName field if the up-arrow appears in the column
Item No Name
Application-Based Questions
Quantity Purchase Date 3.
100 13-03-2014
101 Sharpener
a. Consider the table alongside:
i. Can Item No be taken as a primary key? If
102 Eraser
120 13-03-2014
no, why not?
103
Pen
120 18-04-2014
ii. What is the data type of the field, Item No?
104 Pencil 200 21-05-2014
105 Clips 300 21-05-2014
b. Consider the table on the right:
i. What could be the primary
Date of joining. Empalary
key field in this table?
8/15/2004
ii. Suggest suitable data types
12/23/2008
27000
for the fields of this table.
c. A large database file of customers is maintained by Myro Bank Ltd. Suggest a suitable method of
searching for the record of a particular account number,
d. The options in the Number Filters menu are listed below.
Equal Does Not Equal Less Than Greater Than Between
Which option will you select to do the following?
i. To display all records with salaries in the range of 50000 to 60000,
i. To display all records with a salary below 50000.
iii. To display all records with a salary above 50000.
iv. To display all records with a salary other than 50000.
v. To display all records with a salary that is exactly 50000.
e. Jatin has created a table for recording the details of all the salesmen in his team. He has applied
sorting on the SalesmanName field and the TotalSalesAmount field.
header?
ii. Which sorting has he applied to the TotalSalesAmount field if the down-arrow appears in the
column header?​

Answer 1

Answer:

please follow me and mark me as brainliest

Explanation:

sorry guy I don't know this answer