Section 1: - Information Systems for Business and Beyond: - (Please Refer below PPT 1) and Reference: - https://opentextbook.site/informationsystems2019/chapter/chapter-3-software-information-systems-introduction/ Study Questions: - Develop your own definition of software being certain to explain the key terms.What are the primary functions of an operating system?Which of the following are operating systems and which are applications: Microsoft Excel, Google Chrome, iTunes, Windows, Android, Angry Birds.What is your favorite software application? What tasks does it help you accomplish?How would you categorize the software that runs on mobile devices? Break down these apps into at least three basic categories and give an example of each.What does an ERP system do?What is open-source software? How does it differ from closed-source software? Give an example of each.What does a software license grant to the purchaser of the software? Exercise Questions: - If you were running a small business with limited funds for information technology, would you consider using cloud computing? Find some web-based resources that support your decision.Review this article(https://www.zdnet.com/article/six-open-source-security-myths-debunked-and-eight-real-challenges-to-consider/) on the security risks of open-source software. Write a short analysis giving your opinion on the different risks discussed.List three examples of programming languages? What features in each language makes it useful to developers? Section 2: - Information Technology and Organizational Learning: - (Please refer to below PPT 2) and Reference: - Langer, A. M. (2018). Information Technology and Organizational Learning. 3rd edition. Taylor & Francis Group, LLC. ISBN: 978-1-138-23858-9 Review the strategic integration section. Note what strategic integration is and how it ties to the implementation of technology within an organization.Review the information technology roles and responsibilities section. Note how IT is divided based on operations and why this is important to understand within an organization.

Write a four-page essay describing the process you would follow to design a relational database. Make sure to describe the tools and techniques available to design an efficient data base. Describe the different types of diagrams used in the database development process and the normalization process. The essay must include a cover page, an abstract, a table of content, an introduction, the description of the process to design a Relational Database, conclusions, and a list of references. A minimum of five references are required and they must be cited in the body of the essay.The references must be from reliable sources such as academic books, peer-reviewed journals, or peer-reviewed industry magazines. The entire essay must be formatted and written following the recommendations of the 6th edition of the APA Manual of Style.

Mini Case: Campus BikesIn Chapter 6 (Please see hw 5 description), you learned that Campus Bikes is a popular bicycle shop located near a major university. The shop sells several brands of new bikes, including everything from high-end racing models to beach cruisers. In addition to sales of new bikes and accessories, Mark’s service department is always busy. The staff includes Mark himself, a bookkeeper, two part-time sales reps, a full-time mechanic, and several part-time service helpers who assemble bikes.BackgroundUntil now, the owner, Mark Turner, kept the business records on his personal computer. He cre- ated a simple database to keep track of inventory, but it is not always up-to-date. He also developed spreadsheets to track expenses and payroll. The business has grown and Mark wants to install a new computer system to handle all business functions.You are a lab assistant in the computer information department at the college. You earneda computer science degree at a two-year school, and you recently decided to work toward your four-year degree. Mark recently asked you to help him plan a system for Campus Bikes. You used an object-oriented approach to create a model of the business functions and actors involved.Now Mark wants you to do a “make or buy” analysis. Specifically, you will look into the pros and cons of in-house development versus purchase of a software package. Your research indicates that the most popular bike shop package is offered by a vendor called BikeData.In your last meeting, Mark said that tangible savings for a new system would be hard to measure, but improved customer care, better service department records, and increased productivity are expected. Mark estimates that these benefits will add up to about $3,000 per year, whether the system is developed in-house, or purchased from BikeData.You decide to compare relative costs to establish a total cost of ownership (TOC) over the use- ful life of the system. Based on your research, you put together the following summary:Costs for Option A: Develop In-houseThe system will have a six-year useful life, be very flexible, and easiest to maintain.It will cost $15,000 to develop, install, and configure the system, and $1,000 to load existing data.Mark and the bookkeeper can handle day-to-day support with no added expense. Costs for Option B: Purchase BikeData Software PackageThis is a vertical package with a four-year useful life.The software is less flexible than an in-house system and some customizing will be needed.It will cost $8,000 to purchase, $1,500 to install and configure, $2,500 to load existing data, and $1,000 additional hardware will be neededSupport is free for the first year, then there is a $2,000 annual fee Benefits for Both Options: $3,000 per yearTasks(30 pts) Prepare a detailed list of pros and cons of in-house versus software purchase.(20 pts) Calculate ROI for both options.(20 pts) Calculate NPV for both options. Use an 8% discount factor.(30 pts) Create one sheet word document for Mark showing the results of your analysis, including recommendations and reasons.RubricCS4447_HW6CS4447_HW6CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeTask 1Prepare a detailed list of pros and cons of in-house versus software purchase.30.0 ptsFull Marks15.0 ptsPros or Cons Missing0.0 ptsNo Marks30.0 ptsThis criterion is linked to a Learning OutcomeTask 2Calculate ROI for both options. To get full credit, you should show all of your computation.20.0 ptsFull Marks10.0 ptsPartial calculation provided7.0 ptsOnly Final Answer Provided0.0 ptsIncorrect/Missing Answer20.0 ptsThis criterion is linked to a Learning OutcomeTask 3Calculate NPV for both options. Use an 8% discount factor. To get full credit, you should show all of your computation.20.0 ptsFull Marks10.0 ptsPartial calculation provided7.0 ptsOnly Final Answer Provided0.0 ptsIncorrect/Missing Answer20.0 ptsThis criterion is linked to a Learning OutcomeTask 4Create one sheet word document for Mark showing the results of your analysis, including recommendations and reasons.30.0 ptsFull Marks15.0 ptsAnalysis IncompleteYou should provide cost, ROI, NPV for both cases here and make a reasonable recommendation based on numbers.0.0 ptsNo Marks30.0 ptsTotal Points: 100.0