SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 305 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 19 Nov 2017 My Price 8.00

Using the Master table, List players born

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.  

 1 comment

Answers

SophiaPretty
(5)
Status NEW Posted 19 Nov 2017 02:11 PM My Price 8.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)