itsmedjLv1

11 Sep 2021

QUESTION 17

Exercise: Download the "01 - Sample Database" file from Blackboard (Part 1 /Exercise Files), extract the Zip, and open the database.

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

 

QUESTION 18

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

⭕ Referential Integrity

⭕ Join

⭕ Relationship