User Account

All Pages

Master and appearances tables

Assignment Help Basic Computer Science
Reference no: EM131548589

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.

Reference no: EM131548589

Questions Cloud

Create a linq-to-sql entity classes : Describe the process by which a designer would create a LINQ-to-SQL entity classes.
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.
How globalization impacts national governments ability : Imagine that you are a research assistant for the Director of Research at the International Labor Organization (the ILO), an agency that brings together.
How conservation of mass could be checked in the experiment : Conservation of mass was discussed in the background. Describe how conservation of mass (actual, not theoretical) could be checked in the experiment performed.
Master and appearances tables : 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.
Simple example of an application : Give a simple example of an application where radio buttons and check boxes of GUI components might be useful.
Explain the thesis - poverty in the united states : Minimum wage contributes to poverty in the united state is getting worse and the violence and war, crimes have increased worse each day not enough is getting.
Minimize the damage and impact caused by a disaster : What can be done to minimize the damage and impact caused by a disaster?
Find a polynomial with integer coefficients : Find a quadratic equation function that includes the set of values - Find a polynomial with integer coefficients that has degree 3, and zeros 0 and i.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Loop through the array to determine

Loop through the array to determine if the first name entered exists in the array. If a match is found, display a message that includes the name and a message indicating that there was a match found. If no match is found, display a message so indi..

  Create a program called sum of numbers

Create a program called Sum of Numbers

  Draw a circle that is one inch in diameter

Have a fellow student act as the mechanical arm and carry out your instructions. Do not tell your mechanical arm partner what he or she will be drawing (or writing) before the partner attempts to carry out your instructions.

  Explain the operation of the modified register

The other input of the NAND gate provides a parallel-load control. Explain the operation of the modified register.

  Precision relate to data quality

Does the Level of detail and precision relate to data quality and are uniform across scale?

  Draw a state transition graph for a simple bus

Draw a state transition graph for a simple bus that performs read operations but does not allow wait states-all transfers take one cycle. The bus uses a clock signal. Define all other signals required on the bus.

  Troubleshooting an ospf network

1. Name one troubleshooting command you would use when troubleshooting an OSPF network. Explain what the command does and what field in particular.

  Determine if the decision toinvest is sensitive to project

The company willmake the investment only if it will result in a rateof return of 15% per year or higher. If the revenueis expected to be between $135,000 and $165,000per year for 5 years, determine if the decision toinvest is sensitive to the proj..

  Describe an algorithm of the ford-fulkerson type

If the supplies si and the arc flow bounds bij and cij are integer, your algorithm should be guaranteed to find an integer feasible solution (assuming at least one feasible solution exists). Hint: Use the conversion to a max-flow problem of Fig. 3..

  How many pounds of fruit thereare for each type

Write a Python program that prompts the user to enter types of fruit, and how many pounds of fruit thereare for each type. The program should then display the information in the form fruit , weight listed in alphabeticalorder, one fruit type per l..

  Find the rms voltage of the carrier without modulation

Find the RMS voltage of the carrier without modulation

  What sampling design is the magazine planning to use

Could the magazine be misled by the poll, concluding that owners of American cars are much happier with their vehicles than owners of Japanese cars? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd