ICT
ARCHITECTURE OF 8085
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Secondary
|
|
|
Primary
|
|
|
Foreign
|
|
|
Optional
|
|
|
Compulsory
|
Detailed explanation-1: -In the relationship window in Access, the primary key side of a one-to-many relationship is denoted by a number 1. The foreign key side of a relationship is denoted by an infinity symbol.
Detailed explanation-2: -A foreign key is a field (or fields) in one table that references the primary key in another table.
Detailed explanation-3: -A foreign key helps to define the relationship among tables . This unique key communicates one or more interrelationships in a relational database between two or more tables.
Detailed explanation-4: -The foreign key field in the Orders table, Customer ID, is designed to allow multiple instances of the same value. This relationship returns related records when the value in the Customer ID field in the Orders table is the same as the value in the Customer ID field in the Customers table.