Programming & Computer Science Answers

write a program that implements computerized maintenance of your 

monthly expenditure record keeping. You have to build two classes ExpenseItem,  ExpenseLedger

The class ExpenseLedger will record all expenses you make. You record an expense by giving it a serial number, a description (that tells what it is about) and money you spent on this item. So you need to create a class ExpenseItem with serial, description and amount. Provide constructors, 

getters & setters & toString for this class. Now in ExpenseLedger class you need to build a collection that will hold instance of ExpenseItem. Provide following methods in ExpenseLedger 

1. int removeSmallExpenses(double amt):This method will find expense items that are smaller or equal to amount amt and then remove these items from list. Note that multiple items can be smaller than this value and thus each of these should be removed. Also this method should return number of items removed. 

2. Override toString method to print ledger in well formatted form

Given a BST and a range low-to-high(inclusive). Write a C code to count the number of nodes in the BST that lie in the given range.

Check whether the given schedules are conflict serializable or not

 S1 : R2(B)W2(A)R1(A)R3(A)W1(B)W2(B)W3(B)

S2:R3(Y)W3(Z)R1(X)W1(X)W3(Y)W3(Z)R2(Z)R1(Y)W1(Y)R2(Y)W2(Y)

Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria.

>90 A

>80AND <90 B

>70AND <80 C

>60 AND<70 D

<60 F

Apply a trigger on relation client (sno, fname, lname, eid, and password) on attributes fname and password after/before delete or update these columns. The trigger should insert the old or deleted values from both these columns into a new table client1.

Write input, display,

and calculation methods. Your final output should

display all calculated values, including the total

deductions and all defined constants.

5. Write a C program to calculate area of an equilateral triangle.

write a program to find the duplicate number in the array

which is also prime.

Make a program that asks the user for the hours worked for the week and the hourly rate. The basic salary is computed as:

Salary = hours worked*hourly rate

Bonuses are given:

-No. of hours > 45

~No of hours > 40 and <= 45

✓No of hours > 35 and <= 40

-Bonus of 500 pesos

~Bonus of 250 pesos

✓Bonus of 150 pesos

Display the basic salary, bonus and the total salary (basic salary + bonus) for the week.

Inserting a record

ABC International School wants to computerize students details. The school maintains a database of students in Oracle. The student table contains information related to students and is shown in the following student table structure.

Column Name Type Constraint

Rollno Number (4) Primary Key

StudentName Varchar (20) Not Null

Standard Varchar (2) Not Null

Date_Of_Birth Date

Fees Number (9,2)

 When a new student joins the school, the student record is inserted in the student table. The valid student details are as follows:

• Rollno: Valid value is a 4-digit number

• StudentName: Valid value can contain maximum 20 letters in uppercase

• Standard : Valid values are Roman Letters representing I to X(I, II, III, IV….IX, X)

Write a Java program to insert some records to the table.