Consider a small private airport database that is used to

Reference no: EM13363792

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. Find at least two business process

2. Check a grain from each business process

3. Show the star schema for any one of the business process

4. Prepare atleast two OLAP reports

Reference no: EM13363792

Questions Cloud

If a company has sales of 1000 units and 100 per unit last : if a company has sales of 1000 units and 100 per unit last year. the market manger projects a 10 percent decrease in

One year ago alpha supply issued 15-year bonds at par the : one year ago alpha supply issued 15-year bonds at par. the bonds have a coupon rate of 6.5 percent and pay interest

Findings financial statements and information used in the : findings. financial statements and information used in the analysis including ratios trends and statistics and all

Projected financial statements can be used to assess the : projected financial statements can be used to assess the sensitivity of all of the following excepta firms liquiditya

Consider a small private airport database that is used to : consider a small private airport database that is used to keep track of airplanes their owners airport employees and

You are planning on purchasing a 70000 yacht you would like : you are planning on purchasing a 70000 yacht you would like to own the yacht outright. the yacht dealership offers two

Challenge problem consider a market with only the following : challenge problem consider a market with only the following three risky assetsexpected return per month risk

Allgreens expects its sales to reach 33000 with an : allgreens expects its sales to reach 33000 with an investment in total assets of 10750. net income of 1225 is

Today many companies face budgetary challenges on a : today many companies face budgetary challenges on a continual basis. two critical aspects that businesses lack are

User Account

All Pages