Question $2$

$\frac{0}{10}pts$

Consider the department table from Course Management System Data Dictionary below:

$\backslash$table$[[\backslash$table$[[$DEPARTMENT TABLE$]]],[\backslash$table$[[$ATTRIBUTE$],[$NAME$]],$ATTRIBUTE DESCRIPTION,Domain R$,$Range,PK$,$FK$,$Null$],[$Departmentld$,\backslash$table$[[$System Generated unique number used to identify a$],[$department$]],$number $(2\mathrm{.}0)$ A$,$ALL,Yes N$,$No$,$No$],[$DepartmentName$,$Name of the Department,varchar$2(50)$ A$,$ALL,No No$,$No No$,$No$],[$StreetAddress$1,$First line of Address,varchar$2(50)$ AL$,$ALL,No No$,$No$,$No$],[$StreetAddress$2,$Second line of Address,varchar$2(50)$ AL$,$ALL,No no$,$No Y$,$Yes$],[$City$,$Name of the City,varchar$2(15)$ AL$,$ALL,No No$,$No$,$No$],[$State$,$Name of the State,chat$(2)$ AL$,$ALL,No No$,$No No$,$No$],[$Country$,$Name of the Country,varchar$2(15)$ AL$,$ALL,No N$,$No$,$No$],[$Zipcode$,$Zipcode,varchar$2(10)$ AL$,$ALL,No No$,$No N$,$No$]]$

Which statement$($s$)$ below is$/$are correct for the table described in data dictionary above?

All the attributes in this table must have a value.

lipcode is a $5$ digit number.

DepartmentName cannot be NULL.

Departmentld is the only primary key for this table.