ABC COMPANY
Mr. Pawan works as a programmer in “ABC Marketing Company” where he has designed a Salary generator software to generate the salary of salesman in which Name and Salary are entered by the user. A screenshot of the same is shown below:
(i) After selecting appropriate Radio Button, when ‘Commission’ button is clicked, commission should be displayed in the respective text field as each Salesman will get a commission based on the units sold according to the following criteria: Until Sold 1 to 20 so Commission 500, Until Sold 20 to 40 so Commsiion 1000 and sold >40 so Commission 2000.
(ii) Gross Salary = Salary + Commission.
(iii) After required selection of Checkbox(es), when ‘Facility Charges’ button is clicked, Facility charges will be displayed in the respective text field according to the following criteria: Faccility transport so charges 500 and Facility Mess so charge 2000.
(iv) Net Salary = Gross Salary - Deductions
EMP
1. To DISPLAY LIST OF ALL EMPLOYEESS BELOW 25 YEAR OLD.
2. To LIST NAMES AND RESPECTIVE SALARIES IN DESCENDING ORDER OF SALARY.
3. To COUNT THE NUMBER OF EMPLOYEES WITH NAMES STARTING WITH ‘K’.
4. To LIST NAME AND ADDRESSES OF THOSE PERSONS WHO HAVE ‘DELHI’ IN THEIR ADDRESS.
5. SELECT NAME, SALARY FROM EMP WHERE SALARY BETWEEN 50000 AND 70000;
6. SELECT NAME, PHONE FROM EMP WHERE PHONE LIKE ‘99%’;
Table
Sales Person
Order
1. To display SALESPERSONID, NAMES, ORDERIDS AND ORDER AMOUNT OF ALL SALESPERSONS.
2. To DISPLAY NAMES, SALESPERSONS IDS AND ORDER IDS OF THOSE SALES PERSONS WHOSE NAMES START WITH ‘A’ AND SALES AMOUNT IS BETWEEN 15000 AND 20000.
3. SELECT SALESPERSONID, NAME, AGE, AMOUNT FROM SALESPERSON, ORDERS WHERE SALESPERSON.SALESPERSONID = ORDERS.SALESPERSONID AND AGE BETWEEN 30 AND 45.
Shiksha Vidyalaya
The students of “Shiksha Vidyalaya” work for different extracurricular activities like ‘Community Outreach Programme’, ‘Swachh Bharat Abhiyan’ and ‘Traffic Safety Club’. The Programmer at the school has developed a GUI application as shown below:
Soft Drink
1. To DISPLAY NAMES AND DRINK CODES OF THOSE DRINKS THAT HAVE MORE THAN 120 CALORIES?
2. To DISPLAY DRINK CODES, NAME AND CALORIES OF ALL DRINKS IN DESCENDING ORDER OF CALORIES.
3. To DISPLAY NAMES AND PRICE OF DRINKS THAT HAVE PRICE IN THE RANGE 12 TO 18.
4. To INCREASE THE PRICE OF ALL DRINKS IN THE GIVEN TABLE 10%:
5. SELECT COUNT(DISTINCT (PRICE)) FROM SOFTDRINK;
6. SELECT MAX(CALORIES) FROM SOFTDRINK;
7. SELECT DNAME FROM SOFTDRINK WHERE DNAME LIKE ‘%MANGO%’;
Table
Sales
Location
1. To display SALESMANID, NAME OF SALESMES, LOCATIONID WITH CORRESPONDING LOCATION NAMES?
2. To DISPLAY NAME OF SALESMAN, SALES AND CORRESPONDING LOCATION NAME WHO HAVE ACHIVED SALES MORE THAN 1300000.
3. To DISPLAY NAME OF THOSE SALESMAN WHO HAVE ‘SINGH’ IN THEIR NAME.
4. Write SQL command to change the LocationID to 104 of the salesman with ID as S3 in the table ‘sales’.
Water Park
Mr. Rangaswami works at a Recreation Park as a system analyst. He has created the following GUI. when a group arrives at the Recreation Park, the number of people in the group and whether the group wants to enjoy the Water park or not is entered. Entry fees is Rs. 500 per person. The person can choose to play at Water Park by selecting the checkbox. Rides of Water Park will cost Rs. 250 extra per person.
(i) On the click of command button ‘Calculate’, textfield for ‘Entry Fees’ should display Entry Fees per person x Number of people. If ‘Water park’ checkbox is selected, textfield for ‘Water Park Charges’ should display Water Park Charges per person x Number of people. Textfield for ‘Total Amount’ should display sum of Entry Fees and Water Park Charges for all the people in the group.
(ii) Write Java code to clear all Textboxes on the click of ‘Clear’ button.
(iii) Write Java code to close the application on the click of ‘Exit’ button.
Exam
1. To Display all information of the student of humanities in descending order of percentage.
2. To displayAdno, Name, Percentage and Stream of those student whose name is less than 6 characters long.
3. To add another column Bus_Fees with datatype and size as Descimal(8,2).
4. To increase percentage by 2% of all the Humanities students.
5. SELECT COUNT(*) FROM EXAM;
6. SELECT SNAME, PERCENTAGE FROM EXAM WHERE SNAME LIKE ‘N%’;
7. SELECT ROUND (PERCENTAGE, 0) FROM EXAM WHERE ADNO = ‘R005’;
Table
Sams
Vendor
1. To display ICODE, INAME and VNAME of all the vendor, who manufacture “Refrigerator”.
2. To display INAME, ICODE, VNAME AND PRICE OF ALL THE PRODUCT WHOSE PRICE IS MORE THAN 20000.
3. To display vendor name and names of all items manufactured by vendor whose code Is ‘P03’ .
Grade Calculate
Aditya is a programmer at Edudel enterprises. He created the following GUI in NetBeans.
Fitness
1. To Display the name of all the product with price more than 20000.
2. To display the name of all product by the manufacture “Aone”.
3. To change the price data of all the product by applying 25% discount reduction.
4. To Insert a new rows in the table Fitness.
‘P7’,’VIBRO EXERCIER’, 28000, ‘Aone’;
5. SELECT * FROM FITNESS WHERE MANUFACTURE LIKE ‘%E’;
6. SELECT COUNT (DISTINCT (MANUFACTURER)) FROM FITNESS;
7. SELECT MAX(PRICE) FROM FITNESS;
Table
Employeee
Department
1. To display ENO, ENAME, SALARY and corresponding DANEM of all the employees whose age is between 25 and 35(both value inclusive).
2. To display DNAME and corresponding ENAME from the table DEPARTMENT and EMPLOYEE.
3. To display ENAME, SALARY, ZONE and INCOME TAX of all the employees with appropriate column headings.
Lets Play With Series
Design a GUI application that obtains to the diplay odd and even number. If you write starting number 2 and ending number 10 so print is 2 4 6 8 10.
Shoppe
1. To Display name of the items, whose name starts with ‘C’ in ascending order of Price?
2. To display Code, Item name and City of the Product whose quantity is less than 100.
3. TO count distinct Company from the table.
4. To Insert a new rows in the table Shoppe.
‘110’,’Pizza Jones’, 120, ‘Kolkata’, 50.0;
5. Select Item from Shoppe where Item IN(“Jam”, “Coffee”);
6. Select Count(distinct (City)) from Shoppe;
7. Select Min(Qty) from Shoppe where City = “Mumbai”;
Table
Item
Brand
1. To display ICode, IName and corresponding Brand of those Itemss, whose Price is between 20000 and 45000.
2. To display ICode,Price and BName of the Item, which has IName as ‘Television’.
3. To increase the price of all the Items by 15%.
Platinum Gold Silver
Design a GUI application that obtains the price and quantity of an item, calculates the sale-values, discount and net payble amount. Discount is calculated as 10% of the sale-value.
Exam
1. To List the name of those students, who have obtained Division as FIRST in the ascending order of NAME?
2. To display a report listing NAME, SUBJECT and Annual stipend received assuming that the stipend column has monthly stipend?
3. To count the number of student, who have either accounts or informatics as subject?
4. To Insert a new row in the table EXAM: INSERT INTO EXAM VALUES(6,’MOHAN’,500,’ENGLISH’,73,’SECOND’);
5. SELECT AVG(Stipend) FROM EXAM WHERE DIVISION = ‘THIRD’;
6. SELECT COUNT(DISTINCT Subject) FROM EXAM;
7. SELECT MIN(Average) FROM EXAM WHERE Subject = ‘English’;
Table
Item Table
Customer Table
1. To display the details of item whose Prise is in the range of 40 and 95 (Both value included)?
2. To display the CustomerName, City from table Customer and ItemName and Price from table item, with their corresponding matching ID?
3. To increase the price of all the product by 50?