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, 21.06.2019 22:00
What is the most important aspect of marking media? a. data labelingb. content descriptionc. electronic labelingd. classification
Answers: 2
question
Computers and Technology, 23.06.2019 01:30
Which tab is used to change the theme of a photo album slide show? a. design b. view c. transitions d. home
Answers: 1
question
Computers and Technology, 23.06.2019 02:00
Which demographic challenge is europe currently experiencing? a. an aging and decreasing population b. a baby boomc. an unequal distribution between males and females d. a large group of teenagers moving through the school system(i chose a but i'm unsure)
Answers: 1
question
Computers and Technology, 23.06.2019 06:10
The head restraint should be adjusted so that it reaches a.the top of your ears b.the base of your skull c.the top of the head
Answers: 1
You know the right answer?
Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives inform...
Questions
question
Chemistry, 25.01.2021 17:10
question
Mathematics, 25.01.2021 17:10
Questions on the website: 13722363