Assignment 2 (Technical)

MIS 671 – Sec O1 - Fall 2014

Assignment 2 (Technical) – Database/Spreadsheet - 30 Points

Due: Saturday, October 18, 2014 11:45 P.M. (U.S. CST)

This assignment is straight out of the “Stair & Reynolds textbook chapter 2”. Page 89 (verify the Page in the e-book). Refer to “PROBLEMS-SOLVING EXERCISES”.

Follow the instructions specified in Problem 1 and Problem 2.

· Problem 1 is based on your knowledge on using database management system (Access or any relational DBMS). After completing the exercise save the solution file as “Assignment 2_DB_initials of your name”. Specify the name of the DBMS you use (if other than Access).

· Problem 2 is based on your knowledge on using analytical software (Excel specifically). After completing the exercise save the solution file as “Assignment 2_Excel_initials of your name”

· Write one page report (for each problem) on your findings as a result of solving these two problems. Save the report as “MyFindings_initial of your name”

· Submit the three files (Access solution, Excel solution, and Report) via the assignment 2 link.

NOTE:

If you use any sources for reference then you must provide the details of these sources.

State any assumptions you make in developing the solutions to the above problems.