Question $2(8$ points$)$

Consider the half$-$completed schema below:

This schema has NO primary keys or foreign keys identified. In addition, other constraints on attributes are missing.

Your job is to match attributes in different relations of the schema to their respective constraint or true$/$false$.$

Requires Respondus LockDown Browser

This schema has NO primary keys or foreign keys identified. In addition, other constraints on attributes are missing.

Your job is to match attributes in different relations of the schema to their respective constraint or true$/$false$.$

$$ Foreign Key Users$($id$)$ references

Follows$($following$\_$user$\_$id$)$

Foreign Key Posts$($user$\_$id$)$ references Users$($id$)$

$$

Users.id

$$ Follows.followed$\_$user$\_$id

Primary Key

Foreign Key

Unique

Not null

True

False

Question $3(2$ points$)$