Reference no: EM131439412
The kings and queens of England are listed in a relation Kings(name,nickname,house,beginReign,endReign). Their name is unique, either using a Roman numeral to distinguish them, e.g., 'Edward I' or 'Edward II', or in a few cases using their nickname, e.g., 'Edward the Confessor'. The attribute nickname is an additional appelation, if they have one and it is not used in their name to distinguish them, e.g., 'The Unready'. The value of nickname is NULL if there is no nickname. The attribute house is the dynasty, e.g., 'Tudor'. Attribute beginReign and endReign are integers, the first and last years, respectively, that the king or queen was on the throne. There is also a relation Parents(child,parent). Both attributes are the names of kings or queens, with the obvious connection that the first is a child of the second.
Write the following queries:
1) Who was king in the year 1000? Give the name and nickname.
2) Find all the pairs of kings or queens (A,B) such that A was the great grandchild of B.
3) Find the name and nickname of all kings or queens that have a nickname that does not begin with "The".
4) Find the names of those kings or queens that were the parent of two or more kings or queens. List each such person only once.
5) Find for each house the number of kings or queens of that house.
6) Several times in British history, kings or queens have deposed one another, so that their reigns overlapped. Find all such pairs, listing the pairs in both orders; i.e., list both (A,B) and (B,A). However, be careful not to list pairs A and B where the only overlap is that A's reign ended in the same year that B's began, or vice-versa.
|
Difference between data and entity models
: Can you explain the difference between data and entity models, data flow diagrams and process models?
|
|
Determine the descriptive and explanatory methods
: Determine the descriptive, explanatory, and predictive analytical methods used by Cox Committee, IC, and CRS to develop the report's conclusions on the PRC's intelligence threat. Your assignment is to describe the various analytical methods used...
|
|
College with a print management system
: Provide the college with a print management system for their student pay for print program. There will be an implementation of applications for the purpose of tracking and billing students and guest for printing services at the college.
|
|
Calculate the income tax and national insurance
: Required: For each year, calculate the following: Income Tax and National Insurance due, Interest on unpaid Income Tax and any penalties due in respect of the unpaid Income Tax. You should include a short note detailing your calculations. Explain..
|
|
Who was king in the year 1000
: 1) Who was king in the year 1000? Give the name and nickname. 2) Find all the pairs of kings or queens (A,B) such that A was the great grandchild of B. 3) Find the name and nickname of all kings or queens that have a nickname that does not begin with..
|
|
How is your company different from its competitors
: How is your company different from its competitors? Think about the products/services offered or their pricing strategy or even their distribution strategy.
|
|
Explore the elements of emotional intelligence
: According to the article "Emotional Intelligence and Effective Leadership", one of the most important constructs in leadership today is the concept and application of emotional intelligence (EI) (Batool, 2013). Imagine that you are an internal con..
|
|
People on their use of electronic games
: Survey at least 15 people on their use of electronic games; then present the results in a brief report with charts. Your data should reflect such information as types of games, devices used, gender, and time spent.
|
|
Methods for system recovery in windows 7
: Compare and contrast the tools and methods for system recovery in Windows7 to those in Windows8.x/10. Be specific in regards to how tools are accessed and used in each instance.
|