Instructions: Provide complete answers to the questions below. For all questions that involve completing a table, actually create the completed table with data in MS Word. The answers to all questions should be in a single MS Word document.
1. Create two tables containing data with at least 4 columns and 4 rows of data each so that the tables clearly are not union-compatible. You cannot use one of the examples from class or the book - create your own.
2. Create two tables containing data with at least 4 columns and 4 rows of data each that are union-compatible. Be sure that at least one row (but not all rows) in the first table is identical to a row in the second table. You cannot use one of the examples from class or the book - create your own.
3. Using the two tables from question #2, illustrate the Difference relational operator.
For the remaining questions, use the following tables. Assume the primary key of PLAYER is Player_Num and the primary key of TEAM is Team ID.
PLAYER
|
Player Num
|
Player_FName
|
Player_LName
|
Team_ID
|
|
400
|
Clint
|
Rogers
|
102
|
|
402
|
William
|
Sellers
|
102
|
|
406
|
Rachel
|
Carouthers
|
110
|
|
407
|
Burton
|
Wills
|
|
|
409
|
Sydnie
|
Payton
|
|
|
412
|
Scott
|
Ritter
|
101
|
TEAM
|
Team ID
|
Team Location
|
Team Name
|
Team Coach
|
|
101
|
Cincinnati
|
Spoilers
|
Sanders
|
|
103
|
Peppertown
|
Pirates
|
Murphy
|
|
110
|
Savannah
|
Saints
|
Raines
|
|
102
|
Rogerstown
|
Rowdies
|
Crowther
|
|
103
|
Asheville
|
Armadillos
|
Arnold
|
4. Does the PLAYER table exhibit entity integrity? Why or why not?
5. Does the TEAM table exhibit entity integrity? Why or why not?
6. Does the PLAYER table exhibit referential integrity in its relationship to TEAM? Why or why not?
7. Does the TEAM table exhibit referential integrity in its relationship to PLAYER? Why or why not?
8. Produce the table that would result from a natural join of TEAM-to-PLAYER.
9. Produce the table that would result from an equijoin of PLAYER-to-TEAM.
10. Produce the table that would result from a left outer join of PLAYER-to-TEAM.
11. Produce the table that would result from a right outer join of PLAYER-to-TEAM.