Assignment 2 (Technical)

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.