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, 23.06.2019 02:30
How to launch an app: steps to be successful? launching an app is a great idea, but it’s not that easy as we supposed to think. the majority of mobile applications don’t generate revenue because companies aren’t ready to be competitive. referring to our experience in successfully building and launching apps we hope to you omit these difficulties. we are going to talk about ideas, marketing, testing your product, its development, distribution and support. you will learn 8 product launch stages to succeed.
Answers: 1
question
Computers and Technology, 24.06.2019 00:50
Which of the following is not a key player in the sale of travel products?
Answers: 2
question
Computers and Technology, 24.06.2019 06:30
Some peer-to-peer networks have a server and some don't. true false
Answers: 2
question
Computers and Technology, 24.06.2019 07:30
John recently worked on a project about various programming languages. he learned that though procedural language programs are useful, they have disadvantages too. what is a disadvantage of programs written in procedural languages? a. programs do not represent data complexity. b. programs take more time to execute. c. programs are prone to security threats. d. programs do not interface with multiple platforms.
Answers: 3
You know the right answer?
Presidents Imagine a relation Presidents(firstName, lastName, beginTerm, endTerm) that gives inform...
Questions
question
Mathematics, 17.11.2019 23:31
Questions on the website: 13722363