Consider a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots. From the requirements of this database, the following information particular hangar. Each Plane_type has a model number, a capacity and a weight. Each Hangar has a number , a capacity and a location. The database also keeps track of the owners of each plane and the Employees was collected. Each airplane has a registration number of a particular plane_type and is stored in a who have maintained the plane. The database also keeps track of types of plane each pilot is authorized to play
1. Identify at least two business process
2. Identify a grain from each business process
3. Draw the star schema for any one of the business process
4. Generate atleast two OLAP reports