{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

GroupProjects - BUS311 Spring 2011 Group Project Assignment...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
BUS311 Spring 2011 Group Project Assignment Students will work in their assigned groups to analyze a business process and to develop a working information systems prototype (using primarily MS Access and Excel) to improve that business process (or set of processes). Each group will begin with a basic scenario and then be required to map out the business process (flow chart), design an E-R diagram, implement that data model using MS Access, design usable forms and reports using whatever tool the team deems most appropriate (Access and/or Excel), and analyze the information security issues associated with this potential solution. Group members will draw from their own experiences, Internet research, the textbook, and/or colleagues with relevant experience in addition to me (for a small fee) in order to develop the prototype. The group project deliverables will include the following: 1. A prototype information system developed primarily in Access should include at a minimum the following components (50 points): a. A data model that effectively solves one of these business problems will generally have at least four or five main entities (not including entities that solve many-to- many relationships and other potential lookup tables). b. The database should include properly formatted attributes/fields to ensure data are inputted correctly and consistently throughout the database (i.e. input masks, correct data types, etc). c. Depending on the business scenario, a good database should have a minimum of two or three forms designed to help with data entry. d. The queries will be a big part of the database. Depending on the business problem, a good solution may have anywhere from five or six queries to as many as fifteen or sixteen. It all depends on the questions you are trying to answer and the business problem being solved. e. A good solution will include several reports (probably based off of the queries you built in the previous section) that will be useful tools for managers. Some of the reports may be better made in Excel while others may make more sense done in Access. f. Sufficient test data needs to be loaded into the database in order to demonstrate the prototype, queries, reports, and so on. 2. Report should include at a minimum the following items (25 points): a. Description of the overall business scenario (elaboration from the materials provided with the project start-up). b. A description of the business process or processes in the business scenario, which the prototype information system would support with explanation of each process. What was the business process before implementing this information system and what will it look like after? c. Purpose of the information system and the role of the participants. Which users will perform which tasks? How will they interact with the system? Will they use Page 1 of 5
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
BUS311 Spring 2011 Group Project Assignment forms, queries, reports or interact directly with the tables?
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern