Question

Consider the following requirements statement and the ERD we would draw to model it:

“We want to track flesh-eating clowns and the victims they eat. Each clown has a unique nickname, such as GiggleManiac, and we also want to capture its shoe size and favorite weapon. Each victim has a unique victim number, last name, height, and weight. A clown may eat multiple victims, but some of our clowns are just learning, and have no associated victims. We don’t record a victim until the victim has actually been eaten.”

Which would we still need to ask about in order to complete our diagram? (Hint: Draw it!)

	a.	cardinality
	b.	nothing – we have all of the information we need to draw a complete diagram
	c.	PKs
	d.	participation

Answer 1

b) we have all the information

unique name of clown and unique victom numbers are primary keys

A clown can eat 0 or many victims is cardinality

and victom will only be added if it has actually been eaten shows the participation

so we have everything