List the each entity in the ERD. For each entity identified, you must state whether it is a

regular entity of a weak entity. $(2$ Marks$)$

$2.$ List each composite attribute, along with their component attributes. $(1$ Mark$)$

$3.$ Can an Instructor be the dean of multiple Colleges? $(1$ Mark$)$

$4.$ Can an Instructor simultaneously be the dean of a College and a char of a Department?

$(1$ Mark$)$

$5.$ Which of the following statements is true? $(1$ Mark$)$

a$.$ An instructor must be the dean of a college.

b$.$ An instructor must be the chair of a department.

c$.$ An instructor must be employed by a department.

d$.$ An instructor must teach a course.

$6.$ How can we uniquely identify a given Section? $(1$ Mark$)$

$7.$ We want to track if a whether or not a Student is full$-$time. We can determine this by

checking if they are currently taking at least $12$ credits. How would we designate this on

the ERD? $(1$ Mark$)$

$8.$ Suppose a Course could no longer be sufficiently uniquely identified by its code or name

alone, and instead was partially identified by its Department. Here, the course code

helps identify a Course and the course name is no longer useful in identifying a Course.

How would we change the ERD to reflect this? $(2$ Marks$)$