killster
Mar 14, 2011, 02:33 AM
1. SuperAvion is a company which sells aircraft. The aircraft are divided into three major categories i.e. passenger, cargo, UAVs (pilotless aircraft every aircraft has a serial No, model, year of manufacture, max altitude and a manufacturer. Some of the aircraft have some additional attributes which are not the same as other aircraft like passenger aircraft has seating capacity (number of passengers), cargo aircraft has maximum load capacity whereas the UAVs do not have any additional attributes.
2. Orient Institute of IT and Multimedia is a college which teaches multimedia and IT courses. The college has a faculty and the faculty has three types of teacher full time, part time and visiting. All the teachers have an ID, name, joining date, gender, and date of birth, but some of the teachers have some additional attributes which are not common like part time teachers and visiting teachers have rates fixed on hourly basis and do not have a fixed salary, similarly visiting teachers have maximum number of contact hours and they cannot teach more than that, similarly full time teachers get their salaries deposited in their respective bank accounts whereas other teachers are paid via cheque.
2. Orient Institute of IT and Multimedia is a college which teaches multimedia and IT courses. The college has a faculty and the faculty has three types of teacher full time, part time and visiting. All the teachers have an ID, name, joining date, gender, and date of birth, but some of the teachers have some additional attributes which are not common like part time teachers and visiting teachers have rates fixed on hourly basis and do not have a fixed salary, similarly visiting teachers have maximum number of contact hours and they cannot teach more than that, similarly full time teachers get their salaries deposited in their respective bank accounts whereas other teachers are paid via cheque.