• Between 2000 - 2010:
• What are the main goods and services the United States traded internationally?
• What trade barriers were in place during that decade?
• What are two pros and two cons of the trade barriers used?

INTRODUCTION TO WEB APPLICATION DEVELOPMENT

1. Explain and apply the key features of advanced Web design and programming features (MVC and Razor).

2. Create a web application by using web server controls, event handlers, application state, and session state.

3. Develop client-server applications with form validations using client-side scripting and server-side database connectivity.

4. Analyze security requirements and build websites with authentication and authorization features.

5. Develop service-oriented applications (SOAs) using web services and standard communication frameworks.

6. Enforce quality and reliability to debug, troubleshoot, deploy, and monitor Web applications.

Introduction:

This document consists of a series of Practice/Tutorial type workshops that introduces the foundation concepts in self-learn style workshops. The workshops would facilitate the learners to pick up the rudiments of ASP.NET technology and prepare them to proceed with more serious development work.

To keep the workshops meaningful, all examples are drawn from Aerolion video rental company a brief description of the airline company is given below. Students may augment the ideas presented in these workshop activities to drive towards building an enterprise application for the Aerolion video rental Company. Copyright © 2015-2020 VIT, All Rights Reserved.

DESCRIPTION OF THE COMPANY:

The owner of a local video store wanted to create a new business plan where everything about renting a video (except the picking up and returning of videos) was done online. Therefore, the new system will allow the following functionality online: to search for videos, to become members, to rent videos, to modify membership information, and to pay overdue fees. The store personnel may use the system to process the rented or returned videos, to add or remove videos to/from his store's video inventory and to update video information.

GENESIS OF THE COMPUTING/IT SYSTEM:

You (read you as ISS Consultants) are tasked to develop an Internet based movie renting system. You are required to use the .NET4 platform and would deliver the solution using ASP.NET Webforms, C#, and SQL 2008. The company also intends using n-tier development model to avoid shipping the business layer to the web server. However, at this point the company wants a ITAP2003 Lab Tutorial 1 Copyright © 2015-2018 VIT, All Rights Reserved. 3 prototype of one of the functionalities (use case) that would be in NLayer architecture (without the need to actually use distributed deployment).

DESCRIPTION OF THE SYSTEM

This section describes the broad scope of AeroLion’s reservation system. You may need to refine it further and re-specify the requirements based on discussion. Thus, you may add features or simplify/make assumptions on some of the features/functionality. If you are using as model specs for CA it is important not to over-simplify and at the same time it is equally important to keep the complexities within reach since this is a coursework project with limited time duration. You would strategise based on their strengths and weakness to provide a clear and detailed specification as intermediate report and then proceed on to build the system.

The system (Phases I & II) is envisaged to contain the following features:

1. Logon features

2. Maintenance of user logon and password

3. Maintenance of customer details

4. Maintenance of movie renting A. Assume the store consists of 100 movies. B. 10 video per movie.

5. Borrowing and returning of movies

6. There are various types of movies and member categories. Member with category A can borrow all types of movies but the other two types are limited to borrow all types in the same time.

7. Reporting feature:

▪ Customer by member type

▪ Movies by movie type

▪ All movies

The other use case that bears similarity to the Phase 1 would be the Customer Maintenance. AeroLion is aware of the rich and power packed features of ASP.NET4 and wish to use a rich client feel for the Customers to maintain their data. That said, users would not be able to add customers or delete customers – they would merely be able to update changeable data.

The system would require a feature for new customers to register – so a Customer Registration use case which may bare some relation to the maintain customer details use case may be required. The Customer Registration process is essential, and customers may need to register before booking seats. Finally, the customers may require some means of tracking their previous and current bookings. This and a few other reporting/enquiry forms are identified in the function specifications. For guest users (public and naturally customers too have these facilities) there would be a page through which they could make enquiries to the flight schedule and fares.

SUBMISSION GUIDELINES:

1. You need to put all the description about the steps you are going to create this project, and the screenshots of this project in one .doc or .pdf file. Don’t forget to take the screenshots for all the functionalities in your project.

2. Submit your project before the due date.

3. Penalties will be applied for the late submissions.

4. Incidence of plagiarism will not be tolerated in any circumstances.

Cane Company manufactures two products called Alpha and Beta that sell for $165 and $130, respectively. Each product uses only one type of raw material that costs $8 per pound. The company has the capacity to annually produce 113,000 units of each product. Its average cost per unit for each product at this level of activity are given below:

The company considers its traceable fixed manufacturing overhead to be avoidable, whereas its common fixed expenses are unavoidable and have been allocated to products based on sales dollars.

1-1. What is the total amount of traceable fixed manufacturing overhead for each of the two products? (Alpha / Beta)

1-2. What is the company’s total amount of common fixed expenses?

2-1. Assume that Cane expects to produce and sell 89,000 Alphas during the current year. One of Cane's sales representatives has found a new customer who is willing to buy 19,000 additional Alphas for a price of $116 per unit. What is the financial advantage (disadvantage) of accepting the new customer's order?

2-2. Assume that Cane expects to produce and sell 99,000 Betas during the current year. One of Cane’s sales representatives has found a new customer who is willing to buy 2,000 additional Betas for a price of $48 per unit. What is the financial advantage (disadvantage) of accepting the new customer's order?

2-3.

Assume that Cane expects to produce and sell 104,000 Alphas during the current year. One of Cane's sales representatives has found a new customer who is willing to buy 19,000 additional Alphas for a price of $116 per unit; however pursuing this opportunity will decrease Alpha sales to regular customers by 10,000 units.

What is the financial advantage (disadvantage) of accepting the new customer’s order?

3-1. Assume that Cane normally produces and sells 99,000 Betas per year. What is the financial advantage (disadvantage) of discontinuing the Beta product line?

3-2. Assume that Cane normally produces and sells 49,000 Betas per year. What is the financial advantage (disadvantage) of discontinuing the Beta product line?

6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0.

a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places.

b) Set up a table of (x, y) values to be used for a least squares model and find a linear least squares model y ax b = + for the data. Express the coefficients a and b accurate to 3 decimal places. Also, what is the 2 R value accurate to 3 decimal places?

c) Use your least squares model to predict the revenue in 2020 accurate to 3 decimal places and graph the actual and predicted revenue data superimposed on the same graph.

A random survey was conducted at Disneyland to determine how long park guests waited in line for Space Mountain (in minutes). The collected data is provided below:

65 67 54 57 72 64 55

71 64 60 84 54 74 76

62 60 71 59 58 53 63

65 68 69 90 74 59 75

63 51

The posted wait time was listed to be 60 minutes. At the 1% significance level, perform and interpret a hypothesis test to determine if the actual wait time for Space Mountain was more than 60 minutes.

Use RStudio. To test if a middle school class on geography is working, a pre- and post-test were given to students at the start and end of the semester. Assume that the scores were randomly selected from the two tests. Also, assume that that they are pairs of scores for ten students. Use the following data to test if the class improved students’ knowledge of geography. (hint: use “var.equal=TRUE” in your argument)

Scores

Pre-test:     77, 56, 64, 60, 57, 53, 72, 62, 65, 66

Post-test: 88, 74, 83, 68, 58, 50, 76, 64, 74, 60

FIFO and LIFO Costs Under Perpetual Inventory System

The following units of a particular item were available for sale during the year:

The firm uses the perpetual inventory system, and there are 13 units of the item on hand at the end of the year.

a. What is the total cost of the ending inventory according to FIFO?
$

b. What is the total cost of the ending inventory according to LIFO?
$

When answering each of the following, the random variable Y is normally distributed with a mean of 65 and a standard deviation of 4.

1. The value of z for being able to determine P(Y ≤ 62) is _______

The P(Y ≤ 62) is ________

2. The 2 values of z for being able to determine P( 69 ≤ Y ≤ 74) are _______ and ________

The P( 69 ≤ Y ≤ 74) is _________

3. The value of z for being able to determine P(Y ≥ 72) is _______

The P(Y ≥ 72) is ________

4. The value of z for being able to determine the value of y such that 10% of the values Y are less than that y

Is ________

         The value of y such that 10% of the values Y are less than that y is _________

2. For each 3*3 matrix and each eigenvalue below construct a basis for the eigenspace Eλ.

A= (9 42 -30 -4 -25 20 -4 -28 23), λ = 1,3

A= (2 -27 18 0 -7 6 0 -9 8), λ = −1,2

3. Construct a 2×2 matrix with eigenvectors(4 3) and (−3 −2) with eigen-values 2 and −3, respectively.