What does the appearance of symbols, such as 1 and the infinity - ProProfs Discuss
Topics
Products
Follow Us:

What does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean in the relationships window?



A. Referential integrity is enforced
B. Referential integrity isn’t enforced
C. An inner join is set
D. An outer join is set

This question is part of MS Access - Final Exam
Asked by Michael_laguisma, Last updated: Feb 10, 2020

+ Answer
Request

3 Answers

Carice Snow

I am a well trend Motivational speaker at California.

Carice Snow, Motivator, MA, California

Answered Jun 20, 2019

The correct answer to this question is A, Referential integrity is enforced. This is a concept related to relational databases. The concept states that the table and their relationships must always be consistent. Another way to explain referential integrity is that foreign keys must always agree with the primary keys.

In the same token, any primary key must always match the foreign keys. Its purpose is to prevent orphans, as well as keep the sync of references. It prevents any necessary information from being deleted, and the record no longer exists. It would be used in the Microsoft software Microsoft Access.

 

John Adney

John Adney

Answered Feb 13, 2017

Referntial integrity is enforced
 

John Smith

John Smith

Answered Feb 14, 2017

Referential integrity is enforced
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.