MIS homework

mark39

MIS3003Chapter6HomeworkInstruction.pptx

Home >Information Systems homework help >MIS homework

MIS 3003 Chapter 6

Homework Instructions

Be careful! All instructions here are not for your homework questions, but just some very similar questions!!!

Question

Assume you have been asked to create an Office application to estimate cloud computing costs. You decide to create a spreadsheet into which your customer can provide their cloud computing needs and which you can then import into an Access database and use queries to compute cloud computing costs.

Figure AE-6 shows the structure of the spreadsheet into which your customers will input their requirements. You can download this spreadsheet in the Excel file Ch06Ex02_U7e.xlsx. Figure AE-7 shows an Access table that has costs corresponding to the requirements in Figure AE-6. You can download this database in the Access file Ch06Ex02_U7e.accdb.

Question

It’s not an easy question, because you will need to learn how to write formulas query in access database.

The most useful formulas we can write in access query, it’s the inner and outer product. Read the two tables, we need to multiply our two vectors to get the results. And in this case, we need outer product.

Question

Outer Product

So, for example, if you want to have the cost for each resource for each month, you will outer product each month’s vector to the unit cost we have in CloudCosts table.

e.g. Jan-Extra Small Instance = 1800 * 0.05 = 90, Small Instance = 2000 * 0.12 = 240.

Question

Import the spreadsheet data into the Access database

External Data->Excel->Ch06Ex02_U7e.xlsx

ResourceHours->First Row Contains Column Headings (checked)Let Access add primary key-> Finish.

Clean the data

You can use ResourceID as primary key if you like.

Question

Write queries to compute the cost of each resource.

We need to close both tables first.

We need to create a relationship between CloudCosts and ResourceHours. In this case, it’s one-one relationship.

Database Tools->Relationship Tools->Add both table-> Link ID (CloudCost) to Resource ID(ResourceHours) (Make sure two fields have the same data type, if not, change it to same, possibly change ResourceID in ResourceHours table from double to long integer)

Question

Write queries to compute the cost of each resource.

Create the query to calculate the costs

Create->Query Design->add both tables

Right in Field-> Select “Build…” -> In the dialog, you can either choose from the field, or just write: “JanCost: [Cost]*[Jan]”

You can run the query to see the results. Make sure the outer product works.

Question

For more details about build an expression, please check the link: https:// support.office.com / en -us/article/Build-an-expression-20c385ee-accd-4306-bc7b-adf11f26948a

Go back to design view

Now you can copy the formula in other columns, and change the caption from JanCost to FebCost, MarCost, AprCost, MayCost, JunCost.

Also change the [Jan] in your formula to [Feb], [Mar], [Apr], [May], and [Jun]

Add another field, write formula like Total:[JanCost] + [FebCost] + [MarCost] + [AprCost] + [MayCost] + [JunCost]

Run the query to check, and then save it.

Question

Create report that shows the cost for each type of resource for each month. Show the total costs for the 6-month period for each resource as well. Include a grand total of all the costs

Create-> Report Wizzard-> Choose Your Query created in question b -> click >> to put all fields to right -> Finish

Go to Layout View, Select Column under JanCost -> Design-> Totals->Sum

Do it repeatly for FebCost, MarCost, AprCost, MayCost, JunCost, Total.

Question

Assume that processing costs increase by 20 percent across the board. Repeat parts b and c for the changed cost.

You can copy your previous query and modify the formula.

Think about how to increase a cost by 20%?

You can multiply the cost by (1+20%), which is actually 1.2.

Save the query, and create the report again, calculate the total again.

Question

Upload to d2l

I will need you to upload only the access database to dropbox.