Search & Filtering
1. Create a databases of Finance and do the 4 triggers, 4 procedures and 4 functions by SQL codes.
Write a program to take input for n book records from user and write those book records in a file named: ”record”, whose price is less than INR 500 . Program should also perform random access in the file, after taking input for a particular record number to read and it should also perform random record overwriting after taking input of new record and the record number to overwrite. After overwriting record, display all records on the screen [Attributes of book: Book_id, Book_price, Book_name, Book_author_name]
Create a maze without itertools and copy library Assign them (2, y) coordinates, where (0,0) is the upper-left corner of the map. In the example map above, we have lots of cells along the top edge; their coordinates are (0,0), (1,0), (2,0),(3,0),(4,0), (5,0),(6,0),... There are also quite a few along the left edge: (0,1),(0,2), (0,3), (0,4),(0,5).... The start point is at (4,0) and the end point is at (5,7). Required Dump Points As noted above, the "command" that the user types will tell you how far to run the algorithm, before you dump out a result. You must support the following commands; if the user types anything other than one of these (a blank line is OK), then report an error and terminate the program. For each of these commands, check the testcases to find the proper output.
Write a program that has these overloaded search methods to do array searching:
boolean search(int[] arr, int searchKey) – searches an integer array given a search key value, returns true if searchKey is found, false if not.
Hint:
boolean found=false;
for(int i=0; i<arr.length; i++){
if( ){//compare the array element with the search key value
//action taken if found
}
}
//return something
boolean search(String[] arr, String searchKey) – searches an array of strings given a search key value, returns true if searchKey is found, false if not.
(read Comparing_Strings.doc)
In the main method, you can declare and initialize the two arrays with random values, for example:
int[] intArray={7,3,2,8,1,0,9};
String strArray={"Enchanted","Bedazzled","Divine","Delighted","Elegant"};
Use the methods in the program.
Enter a string to search in the array: bedazzled
bedazzled is found in the array
Write a program that can perform addition with these overloaded methods:
int add(int x, int y) – returns the sum of two integer values
double add(int x, double y) – returns the sum of an integer value and a double value
double add(int x, int y, double z) – returns the sum of two integer values and a double value
Use the methods in the program. (How would you use them?)
1. A Database of Finance by four functions, four projections and four triggers?please help
Write a program to take input for n book records from user and write those book records in a file named: ”record”, whose price is less than INR 500 . Program should also perform random access in the file, after taking input for a particular record number to read and it should also perform random record overwriting after taking input of new record and the record number to overwrite. After overwriting record, display all records on the screen [Attributes of book: Book_id, Book_price, Book_name, Book_author_name]
Write a program to take input for n number of doctor records and write records of all cardiologists in
a file named: “record1”. Also write records of all those doctors in another file named: “record2” who are
taking salary more than INR 80,000. After writing records in both files, merge their contents in another
file: “finalrecord” and read all records of “finalrecord” file and display on screen. [Attributes of doctor:
doc_id, doc_name, doc_specialization, doc_salary]
. A prime number is a number that is evenly divisible only by itself and 1. For example, the
number 5 is prime because it can be evenly divided only by 1 and 5. The number 6, however,
is not prime because it can be divided evenly by 1, 2, 4, and 6.
Write a method named as Prime, which takes an integer as an argument and returns true if the
argument is a prime number, or false otherwise. Also write main method that displays prime
numbers between 1 to 500
how to calculate total income a an employee
