-Assignment # 11

due Thursday, February 23^rd

40 points maximum – 1 for name

This may be done in a group or individually.

Name(s) of submitters: _________KEY______________________________

Download the Jefferson Dance Club (JDC) on Blackboard (under Course Documents).

Note: you may add additional rows if you need them or not use all those that are here.

List the entities – that you see from reading the description -

1 point each row to maximum of 8 points – any one of the three columns is okay

	Lesson	Lesson
Private Lesson	Private Lesson	Private Lesson
Group Lesson	Group Lesson	Group Lesson
Teacher	Teacher
Full time teacher	Full time teacher	Full time teacher
Part time teacher	Part time teacher	Part time teacher
Student/Customer	Student/Customer	Student/Customer
Dance	Dance	Dance

For each entity above write its name below and check or fill information in any box that applies –

Compare rows with the entities above. 2 points for each row that maches – maximum of 16 points

Entity	Strong	Weak	Subtype (indicate supertype)	Inclusive/Exclusive Subtype
Lesson	X
Private Lesson		X	X- lesson	X – exclusive
Group Lesson		X	X- lesson	X – exclusive
Teacher	X
Full time teacher		X	X - teacher	X – exclusive
Part time teacher		X	X - teacher	X – exclusive
Student/Customer	X
Dance	X

Tell what entities are related to each other and what the cardinalities are. – 3 points each row (15 points total)

Entity 1	Entity 2	Cardinality
Teacher	Dance	N:M
Teacher	Private Lesson	2:N
Teacher	Group Lesson	1:N
Private Lesson	Customer	2:N
Group Lesson	Customer	N:M