The Assignment
You are required to develop an information system prototype that helps to automate data flows and information products for some sort of information-handling process. It can be for an organization, a small business, or some personal need.
You are NOT required to develop an entire suite of operational systems for a business or organization; rather you are asked to choose one specific information-handling process to automate. You may develop a prototype to support some business process at a family business, or one to automate some information management aspect of a fraternity/sorority or social club (e.g. membership participation in service events).
Further, you may develop a prototype system that demonstrates some sort of analytical technique you have learned in another course. As this is an individual assignment, it can be a fairly simple project - part of the assignment is to develop what the project is/will be.
An Information System Prototype
What you will build is an information system prototype. You should discuss the information systems that might be required to conduct business for your chosen organization (or an individual information processing need), or use one of the scenarios provided below.
In the written report (submitted as a PowerPoint slide deck) below you are required to discuss how the system you built fits within whatever overall systems environment you've chosen. For an organizatonal system, it should fit with the needs and systems of the organizaton. If for an individual, the same. The IS must be sufficient to support the application or process you have chosen, but at minimum it should be of a level of rigor that suggests university-level business education.
If you are not sure if you have chosen a system with enough complexity, or conversely one with too much complexity, try to sketch out the system then check with your instructor to confirm your choice. You should do such a thing (i.e. sketch out what you intend to do) anyway - it's part of good development practice and it's part of the assignment.
Specific Requirements for the New Information System Prototype
• Your prototype should include some system that automates or supports data/information processing, or something that could be used by an individual to make a fairly complex decision. You may use either of the two applications you have been provided with in class (i.e. Access for building a database, or Excel for some sort of analytical task). However, you may also use any other system or tool that is available (e.g. MySQL or some Web development package).
• Your system should be appropriately documented. In the case of databases, this means metadata and field/table descriptions, and a data model. For other applications, this means written documentation describing the purpose and function of what you have built. Regardless of what type of system you build, there should be the appropriate use of context and decomposition diagrams (don't worry - we learn about these in the class).
• Your system should have a level of completeness that enables it to function well enough to be evaluated as to its performance. If you are doing a database, this means data in the tables, along with queries and reports that draw upon multiple tables. For an Excel assignment, it should be able to process data to arrive at a conclusion to a problem, and appropriately rigorous analytics (i.e. don't just use the "sum" function).
• Your system should be sufficiently rigorous to represent university-level work. For those building databases, this can be represented by a data model that resolves at least one M:N relationship, and with queries that draw on multiple tables along with calculations/averages, etc. For a spreadsheet, more sophisticated analyses such as regressions, or NPV would be appropriate.
Attachment:- The Assignment.rar