DB Modeling HW $1$

Due January $18$

Write the answers on the page itself. For the following partial ERDs, using the business rules as given, do the following for each one:

put in an appropriate Primary Key $($PK$)$

put in a Foreign Key $($FK; if necessary$)$ ensure you indicate it as such!

put in the relationship name $($both sides!$),$ in the correct place

put in maximum cardinality

put in one additional attribute $($your choice, but it must make sense$)$

A student is advised by one faculty member; a faculty member advises many students.

Student

$\backslash$table$[[$Student$,$Faculty$],[?,?$