STAT 300 Lecture 1: Dummy Variables in Regression - 2014-07-11T15-47-41-0

Go to the Relationships window and observe the relationship between the Services and Locations tables. How was that relationship created?

 

Feel free to delete the existing relationship line if you wish to test some of the choices below.

⭕ Drag from "Location ID" in the Locations table to "Location" in the Services table.

⭕ Right click the Locations table heading area, choose "relate to", then select the Services table.

⭕ Drag from "Location" in the Services table to "Location" in the Locations table.

⭕ Right click the Locations table heading area, choose "show direct relationships", then select "activate" after it displays the Services table

 

_________ refers to the set of rules that helps to maintain consistency between related tables

⭕ Referential Integrity

⭕ Join

⭕ Relationship

12. A football team of 11 players is to be selected from a set of 15 players, 5 of whom can play only in the backfield,8 of whom can only play on the line, and two of whom can play either in the backfield or the line. Assuming the team has 7 menon the line and 4 on the backfield, determine the number of football teams possible. We have to decide if the two versatile players are going to play.

 

(a) Neither of the two plays.

 

(b) One of the two plays.

  

   (i) If the versatile player played in the line.

   (ii) If the versatile player plays in the backfield.

 

(c)  Both play (one line, one backfield)

 

(d)  Both play line

 

(e) Both play backfield