Reference no: EM131549481
Please submit the relational algebra answers to the following questions in a Word document.
Questions:
1. Using the Master table, List players born in New York state in 1978. The output should contain their full name (First, given and last)
2. Using the Master and Appearances tables, select players born in the state of New Jersey in 1987, the years they appeared on the All-Star teams. Your answer should return the playerID, their full name (First, given and last) and the years they appeared on the AllStars.
3. Using the Appearances, what are the playerID for the players that appeared on both the 2000 and 2010 AllStar teams
4. Using the Master, Appearances, Teams and TeamsFranchises tables, select players born in New Jersey in 1987, the years they appeared on the All-Star teams and the name of the franchise they played for.
5. Using the Master and Salaries tables, write query that names of players whose salaries were between $80,000.00 and $90,000.00
6. Using the Managers, Hall of Fame and Master tables, write the query that returns all managers of AllStar teams that are also in the Hall of Fame
Note: The appearances table shows the years that someone was named to (appeared) the Allstar team. Allstarfull shows the actual games played by a specific player.
You are being asked to submit the Relational Algebra formulas, not any SQL statements.
|
Suppliers of company provide cash discounts
: The suppliers of a company provide cash discounts at 1/10, n/40. Other suppliers offer cash discounts of 3/10, n/40.
|
|
Analyze and interpret a short poem of your choice
: Analyze and interpret a short poem of your choice from the textbook. To succeed, you should demonstrate that you understand the terms.
|
|
How is the existence of evil in the world possible
: Many thinkers who accept the existence of God pose the problem of theodicy: how can God, being infinitely good and almighty, allow the existence of evil?
|
|
Chief security officer of a hypothetical organization
: As a Chief Security Officer of a Hypothetical organization which has international presence, how do you ensure that your cyber security policy
|
|
Write query that names of players whose salaries
: Using the Master and Salaries tables, write query that names of players whose salaries were between $80,000.00 and $90,000.00
|
|
Do the images work together to form a coherent pattern
: Do the images work together to form a coherent pattern? What ideas or feelings are conveyed by the images the author has selected?
|
|
What is the yield to maturity of this bond
: A 6.1% coupon bearing bond pays interest semi-annually and has maturity of 5 years. If current price of bond is $1,140.56, what is the yield to maturity of bond
|
|
What name is given to the open ocean
: What name is given to the open ocean? What level of ecology is concerned with groups of individuals of different species?
|
|
Corporate financial analysis and stock valuation study
: Corporate financial analysis and Stock Valuation Study - find out the annual dividend payments made during the fiscal years
|