Wk 3 Part 1In light of the following comments, discuss the questions listed below:Added value is the portion of the total value created by an organization that would be lost if the organization did not take part in the exchange of information. It is the unique portion of the total value created that is contributed by the organization itself, and depends on the effects of existing competition.Provide two examples of organizations that you think have been able to create value using IS. The first organization should have focused on the customers’ willingness to pay, while the second organization should have focused on supplier opportunity cost.Think about the last time you bought something that you felt was a “great deal.” Why do you think the product or service was a great deal? Do you think the firm you acquired the product or service from considered the transaction “great”? Why or why not?Provide an example of a firm that you think currently has added value. Explain your example using value analysis.Part 2IS Strategic PlanningThe strategic IS planning process defines how an organization plans to use and manage its IS resources to fulfill its strategic objectives. In this phase of your project and based on your understanding of current operations and also based on the requirements you gathered in Week 2, you will be required to go through the different phases of the IS strategic planning process for your case study. In doing so, you will use the tools and techniques you covered in the online lecture and in your textbook. In your report, make sure to cover and develop topics around:Strategic impact gridValue creationDifferent cost elementsYour report should introduce the high level recommendations for the new initiatives of the IS system based on your IS strategic planning process.Submission Details:Submit your plan in a 8–12 page Microsoft Word document, using APA style.

Your task is to develop a network infrastructure design that meets the requirements above for the Honolulu, Hilo, and Lihue sites and create a network drawing using Visio or Draw.io, specific to Kamehameha Institute, listing the network's topology. Please see the attached document for more details.

1) Define a table validation rule for the tblCourse table to verify that StartDate field values precede EndDate field values in time. Use The course start date must come before the course end date as the validation message. Save your table changes, and then test the table validation rule, making sure any tested field values are the same as they were before your testing.2) Create a query to display the InstanceID, TotalCost, and BalanceDue fields from the tblRegistration table and the Phone and Email fields from the tblStudent table. Find all records for which the BalanceDue value is greater than 0. Add a calculated field named Payer as the first column that concatenates FirstName, a space, LastName, and (student) if the BillingLastName field is null. Otherwise, the calculated field should concatenate BillingFirstName, a space, BillingLastName, and (billing). Sort the results on the calculated field in ascending order. Save the query as qryBalanceContacts, run the query, resize all columns to their best fit, and then save and close the query.I cant attach the database that your supposed to do these two assignments on in the post so just give step by step examples and photos if you can.