1. Given the following scenario:

In an “Application Store” portal, items are managed for mobile users. Users can browse, download and install items of their interest from “Application Store” to their mobile device.  You are required to draw an Entity Relationship Diagram (ERD) to present above scenario. Apply appropriate cardinality and modality among entities of ERD.

1. Given the following scenario:

In campus management system, one of the work flows has following description;

A Student submits admission form to apply for admission in university. The form is evaluated and approved forms are shortlisted. Shortlisted students are invited for interview. After interview of students, selected forms are stored in database. You are required to draw a Data Flow Diagram of above scenario.   

1. Given the following scenario-

• Office building, 3 stories, 3000 square feet (SF) gross interior floor space each, 2 tenants per floor, 1
• 350 sf of the building is used for hallways, common bathrooms, stairs, elevator, and lobby. 
• The owner wants a gross rent of $135,000 per year.

     (First, establish the Load Factor)

1. What is the rent that the Owner should charge per square foot?  If Tenant Z rents 1200 sf of usable area, what will be his monthly rent?
2. If the building has an operating expense ratio of 28% of gross rents, including vacancy and reserves, what is the Net Operating Income?  
3. The sale price at a 9% CAP rate?