Which of the following is NOT a rule for tables in a relational database system?

No duplicate rows in a table

Foreign keys cannot be null

Every table must have a primary key

No duplicate columns in a table

Which two duties do not violate separation of duties if they are performed by the same individual ?

Writing checks and receiving checks in the mail.

Approving purchase orders and receiving items ordered.

handling cash and posting to customer accounts

Approving payment to vendors and completing the monthly bank reconciliation.

A data analyst wanted to predict how much rework time would result from taking a manufacturing line from producing 8 hours a day to 24 hours a day. The analyst carefully analyzed three years of performance from manufacturing lines that operated 8 hours a day to make the prediction. The analyst is at risk of making what type of error?

Data overfitting error

Outlier error

Garbage in garbage out

Either a type I or type II error

Extrapolation beyond the range error