Which of the following is true about a foreign key?a$.$ It could be not$-$unique and nullable $($has nulls$).$b$.$ It can relate to multiple rows in another table.c$.$ It can relate to columns which are not primary keys.d$.$ It must be defined in all tables in tHe table