1. design a database to produce the following reports. do not use any surrogate keys inyour design. a) for each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. b) for each trip, list the trip id number, the trip name, the location from which the tripstarts, the state in which the trip originates, the trip distance, the maximum group size, thetype of trip (hiking, biking, or paddling), the season in which the trip occurs, and theguide number, first name and last name for each guide. a guide may lead many trips anda trip may be led by many different guides. c) for each customer, list the customer number, customer last name, customer first name, address, city, state, postal code, and telephone number. d) for each reservation, list the trip id number, the trip date, the number of persons included1n the reservation, the price of the trip per person, the total or any additional fees perperson, and the customer number, first name, and last name of the customer who madethe reservation.

This question involves a class named textfile that represents a text file. public class textfile { private string filename; private string filename; private arraylist words; // constructors not shown // postcondition: returns the number of bytes in this file public int filesize() { } // precondition: 0 < = index < words.size() // postcondition: removes numwords words from the words arraylist beginning at // index. public void deletewords(int index, int numwords) { } // precondition: 0 < = index < = words.size() // postcondition: adds elements from newwords array to words arraylist beginning // at index. pub lic voidaddwords(int index, string[] newwords) { } // other methods not shown } complete the filesize() method. the filesize() is computed in bytes. in a text file, each character in each word counts as one byte. in addition, there is a space in between each word in the words arraylist, and each of those spaces also counts as one byte. for example, suppose the words arraylist stores the following words: { mary had a little lamb; its fleece was white as snow. } the filesize() method would compute 4 + 3 + 1 + 6 + 5 + 4 + 6 + 3 + 5 + 2 + 5 as the sum of the lengths of each string in the arraylist. the value returned would be this sum plus 10, because there would also be 10 spaces in between the 11 words. complete the filesize() method below: // postcondition: returns the number of bytes in this file public int filesize() { }

Visualizing a game of “tag” to remember the meaning of contagious

Acommon algorithm for converting a decimal number to binary is to repeatedly divide the decimal number by 2 and save the remainder. this division is continued until the result is zero. then, each of the remainders that have been saved are used to construct the binary number.write a recursive java method that implements this algorithm.it will accept a value of int and return a string with the appropriate binary character representation of the decimal number.my code: public class lab16{public string converttobinary(int input){int a; if(input > 0){a = input % 2; return (converttobinary(input / 2) + "" +a); } return ""; } }