Consider the Flights relation: Flights(fino: integer, from: string, to: string, distance: integer, departs: time, arrives: time)
Write the following queries in Datalog and SQL:1999 syntax:
1. Find the fino of all flights that depart from Madison.
2. Find the .fino of all flights that leave Chicago after Flight 101 arrives in Chicago and no later than 1 hour after.
3. Find the fino of all flights that do not depart from NIadison.
4. Find aJI cities reachable frOlll l\iladison through a series of one or 1I10re connecting flights.
5. Find all cities reachable from IVladison through a chain of one or rnore connecting flights, with no 1I1Ore than 1 hour spent on any connection. (That is, every connecting flight must depart 6. Find the shortest tilne to fly frOl11 ~IIadison to i\dadras, using a chain of one or 1nore connecting flights.
7. Find the Jlno of all flights that do not depart [1'0111 ~!Iadison or a city that is reacha. ble frolIlrvladison through a chain of flights.

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() { }