Data Base week6_1

01/03/2010

 

Auckland Business School

Auckland Business School employs many teachers to teach their various courses each year. A teacher can teach several different courses as long as he or she is qualified to teach the material. Each course must have one teacher.

Students from different programmes enroll themselves into courses. For example, first Semester courses are offered as core courses and the students from Bachelors programme and Graduate/Post Graduate Diploma will have to do. Course, therefore, can be attended by several different students.

At the beginning of each semester, courses are assigned to individual classrooms where the class meets on a regular basis

• 
  
  Identify the main entity types of the Auckland Business School.
  Teacher, Qualification, Course, Program, Classroom, Enrollment, Student
  
• Identify the main relationship types between the entity types described in (a) and represent each relationship as an ER diagram.
  
• Determine the multiplicity constraints for each relationship described in (b). Represent the multiplicity for each relationship in the ER diagrams created in (b).
  
• Identify attributes and associate them with entity or relationship types. Represent each attribute in the ER diagrams created in (c).
  
• Determine candidate and primary key attributes for each (strong) entity type.
  
• Using your answers (a) to (e) attempt to represent the data requirements of the Auckland Business School as a single ER diagram.
  
• State any assumptions necessary to support your design.