DataBase CH3

Question 1

A column or a set of columns whose value is unique for each row

Answer 1

Primary Key

Question 2

Foreign Key

Answer 2

Refers to a primary key in another referred relation

Question 3

In 1:M Relationship where do we put the (FK)?

Answer 3

In the Many side

Question 4

In 1:M if the 1 side has an optional Option we..

Answer 4

Put it in the relation besides the FK

Question 5

In M:N Relationship we..

Answer 5

Create a new relation and add the two foreign key

Question 6

the foreign key EITHER matches one of the values in the primary key column of the referred relation OR the value of the foreign key is null (empty)

Answer 6

Referential integrity constraint