subject

Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives information about US Presidents. Attribute firstName is a string with the first name, and in some cases, one or more middle initials. Attribute lastName is a string with the last name of the president. For example, the previous president has firstName = 'George W.' and his father has firstName = 'George H. W.'; both have lastName = 'Bush'. The last two attributes, beginTerm and endTerm, are the years the president entered and left office, respectively. One subtlety is that Grover Cleveland served two noncontiguous terms. He appears in two tuples, one with the beginning and ending years of his first term and the other for the second term. Write the following queries: Which president was in office in 1900? Give his first and last name. Which presidents served in only one year? Give their first and last names. How many presidents served terms of more than four years (i. e., the difference between the beginning and ending years of their terms is greater than 4)? You may know that there are two pairs of presidents that were father and son. But there are a number of other pairs of presidents that shared a last name. Find all the last names belonging to two or more presidents. Do not repeat a last name, and remember that the same person serving two different terms (e. g., Grover Cleveland) does not constitute a case of two presidents with the same last name. What is the average length of a president's term for all those terms that began after 1900? Which president (first and last names) served between Grover Cleveland's two terms?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 21:00
Describir textbook icon_person mira los dibujos y describe lo que está pasando. usa los verbos de la lista.
Answers: 1
question
Computers and Technology, 23.06.2019 02:50
There’s only one game mode that stars with the letter ‘e’ in cs: go. which of the options below is it?
Answers: 1
question
Computers and Technology, 23.06.2019 17:00
The more powerful, 60 volt cables and the main power shut off on an hev are both colored orange
Answers: 1
question
Computers and Technology, 24.06.2019 18:00
Which of the following is an example of synchronous communication? a) e-mail b) voicemail c) telephone conversation d) text message.
Answers: 1
You know the right answer?
Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives inform...
Questions
question
Biology, 22.04.2020 18:47
question
History, 22.04.2020 18:47
question
Mathematics, 22.04.2020 18:47
Questions on the website: 13722367