Database Design

Examine the attached database network diagram and write the SQL statements required. Special attention to syntax and function. It is recommended that you first create a database so you can test your SQL statements for functionality.

 

SQL Exercise 3Consider the following relational database for the Super Baseball League.It keeps track of teams in theleague, coaches and players on the teams, work experience of the coaches, bats belonging to each team, andwhich players have played on which teams.Note the following facts about this environment:ï‚·The database keeps track of the history of all of the teams that each player has played on and all of theplayers who have played on each team.ï‚·The database only keeps track of the current team that a coach works for.ï‚·Team number, team name, and player number are each unique attributes across the league.ï‚·Coach name is only unique within a team (and we assume that a team cannot have two coaches of thesame name.)ï‚·Serial number (for bats) is only unique within a team.ï‚·In the Affiliation table, the Years attribute indicates that number of years that a player played on a team;the batting average is for the years that a player played on a team.Write SQL SELECT commands to answer the following queries.

• 1495521511-SQL Exercise 3.pdf

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495521512-Solutions file 2.docx preview (51 words )

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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer