Athabasca Assignment

Assignment 1 Using a database for strategic personal credit line Development Assignment 1 is worth 5 percent of your final grade for this course. Answer all questions in the Hands-on MIS undertaking Improving Decision Making Using a Database to Clarify Business Strategy on knaves 9293 of the textbook. Read the identification instruction manual in the textbook c befully and follow all instructions. Background relational entropybases are not new technology. Commercially, they gained importance in the early eighties with the introduction of Oracles relational database, and since therefore they take on been an meaty tool for most business enterprisees.Databases are critical tools that help to support mingled business functions in an organization. These instruction systems help a business to framing and maintain competitive advantage. Databases not only support the operational levels of businessthey are also used to support the activities of managers. For this assignment, y ou give be analyzing the data in a simple, one-table database by creating queries and musical compositions in Microsoft entrance fee. The system you are ontogenesis volition be used by The Queens hostel in St. Johns, Newfoundland for strategic business development purposes.Remember that Access, Excel, and even FrontPage, are all tools. This assignment will help you discover how to use a database tool to support a business. You will be analyzing the data in the database and answering the questions in the exercise to create the queries and reports that are necessary to suss out what the Inns current business situation is. Instructions * If you have not yet set up your access to MyMISLab, go to the learning Materials paginate for the proper steps and codes. It is vital that you set up MyMISLab mightily to ensure you have access to the resources for CMIS 351. Go to MyMISLab and floorload the Exercise Data File MIS11ch03 for this assignment from the Assignment 1 folder (after l ogging in, tick off Course Content, choose View All Content, then scroll down to the Assignment 1 folder that appears after the 15 Lesson folders). You may download either the 2003 or the 2007 database file. If the data file doesnt open, check your browsers pop-up blocker settings or try holding down the Ctrl signalise when clicking the file name. * After you have downloaded and opened the file, click FILE SAVE AS, then SAVE the file to your hard drive according to the following assignment naming standards ourlastname_CMIS351_assign1. mdb Once the file has been saved, you can open it and start work on your assignment. * Analyze the data in the database and in the application exercise. * To do this assignment, you will need to do data calculations. Remember to follow skinny database practice here by not saving your calculations as wear of the data table itself (they should appear only in your queries). * Create queries and reports that will provide information to help manageme nt at the Queens Inn to be more competitive and profitable.If you look at the current database you downloaded, you will see that it provides suggestions for the three reports that should be created for The Queens Inn. These reverse templates will give you an indication of what queries and reports you must create for this assignment. * If you need a refresher on using Access databases, see the resources on the subsidiary Information for Access Assignments scallywag. * Write a brief report (1-2 pages) describing what database information (from your analysis) would make the business more competitive and profitable.Your report must include, at a minimum, answers to the four questions in the last paragraph of the exercise on page 93 of the textbook. For this assignment you must hand in * an Access database with reports and queries as described above (the number of queries and reports will be up to you) OR * if you do not have access to a ready reckoner on which you can install Micr osoft Access, you may use another database tool. If you do this, you must also submit the following * an E-R diagram of your database that clearly shows the basal and foreign keys for each table. a screen shot of the first page of the contents of each table. Alternatively, you may create a report that dumps the contents of a table and submit a single page of that report. * queries that you normaled to create each report. Show both the query design and the query output. * the reports inevitable in the assignment In either case, you must also submit a Word document containing a report as described in the assignment instructions on page 93. When you are ready to submit your assignment, listen to this message from your Course Coordinator.Marking criteria You will be marked according to the following criteria. Database 4 marks * enforced correctly * queries are correct Reports 3 marks * provide required information * comprehensive * readable (accurate spelling and grammar) Writt en report 3 marks * professional, business-like * relevant * correct (covers required information) Once you have completed the assignment, you must return to this Web page and follow the instructions on the right to submit your assignment for marking.