TAW_10_2 chapter 5, input checks

Question 1

Fixed value appends can be reused in multiple domains?

Answer 1

No, an append is always for one domain

Question 2

What causes an input field value check to occur

Answer 2

Either a foreign key or fixed values is attached to the domain

Question 3

What is the foreign key table vs the check table?

Answer 3

The foreign key table is the table that that is checking against the check table. The check table acts like fixed values

Question 4

When defining foreign keys what is required of the compared fields?

Answer 4

They must have the same domain. the non-check field domains can be different but the field type and length must be the same

Question 5

When a value table is added to a domain it creates a foreign key?

Answer 5

No, it only means that when a foreign key is created the value table will be used to generate the proposal.

Question 6

You should always use the system proposal for foreign keys?

Answer 6

No, sometimes the proposal is too generic and another more specific table should be used