A company in Florida provides certified flight-training programs for aspiring new pilots of small aircraft. Although awarding a pilot”s license requires one-on-one flight time, there is also much preparatory training conducted in classroom settings. The company needs to create a conceptual data model for its classroom training program, using an entity-relationship diagram. The company provided the following information:
Floridian Flight, Inc., has ten instructors who can teach up to 30 pilot trainees per class. The company offers ten different courses, and each course may generate up to eight classes.
Identify the entities that should be included in the entity-relationship diagram:
- Instructor, Floridian Flight Inc., pilot trainee
- Instructor, Floridian Flight Inc., course, enrollment, class
- Floridian Flight Inc., enrollment, course, class, pilot trainee
- Instructor, course, enrollment, class, pilot trainee