Data Model UI Make a data model for courses in an evening

Data Model | UI

----------------------------------------------------------------------

Make a data model for courses in an evening school. The data to be included are illustrated by this list of participants for a Course: Course: 2306 Greek for beginners Period: Spring 2012 Teacher: Ted Petrides Participants. Name Price 100830-0217 $42 Peter Hansen 160950-0128 Susan Ritz $84 a) Show the model when there is no fixed price for participating in the course. Each participant may negotiate his own price depending on his specific situation. Also, assume that each course has only one teacher. b) Modify the model so that there are different groups of participants, for instance normal, students and senior Participants cannot negotiate a price, but are charged a fixed price according to the group they belong to co Modify the model further so that there are also different groups of courses, for instance short, long and advanced courses. The price for a course now depends on the participant group as well as the course group, for instance according to this table Course group Prices Participants Short Advanced Long $50 $84 $110 Normal $35 $56 $80 Students $25 $42 $60 Senior a) Finally, modify the model so that teachers may teach some courses and be participants in other courses. Also allow a course to have more than one teacher

Solution

a)

ParticipantId

Name

Price

b)

GroupId
ParticipantId

Groups

SubGroups

Prices

b)