Athabasca Assignment

Assignment 1 Using a Database for Strategic Business Development Assignment 1 is worth 5 percent of your final examination grade for this course. Answer all questions in the Hands-on MIS project Improving Decision Making Using a Database to Clarify Business Strategy on pages 9293 of the textbook. Read the date instructions in the textbook cargonfully and follow all instructions. Background Relational databases be not unexampled technology. Commercially, they gained importance in the early 1980s with the introduction of Oracles relational database, and since then they have been an essential tool for most businesses.Databases are fine tools that help to documentation various business functions in an organization. These knowledge systems help a business to build 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, you will be analyzing the data in a simple, o ne-table database by creating queries and give notice (of)s in Microsoft get to. The system you are developing will be used by The Queens Inn 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 tell the questions in the exercise to create the queries and narrations that are necessary to determine what the Inns current business situation is. Instructions * If you have not even so set up your gravel to MyMISLab, go to the Learning Materials page for the proper steps and codes. It is vital that you set up MyMISLab correctly to ensure you have access to the resources for CMIS 351. Go to MyMISLab and download the Exercise Data File MIS11ch03 for this assignment from the Assignment 1 folder (after logging in, click Course Content, choose View both Content, then s croll 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 key when clicking the file name. * After you have downloaded and opened the file, click FILE hold open 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 works on your assignment. * Analyze the data in the database and in the application exercise. * To complete this assignment, you will need to do data calculations. Remember to follow good database radiation pattern here by not saving your calculations as part of the data table itself (they should appear only in your queries). * Create queries and reports that will provide information to help management at the Queens Inn to be more competitive and profitable. If you look at the original database you downloaded, you will see that it provides suggestions for the collar reports that should be created for The Queens Inn. These empty 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 Supplemental Information for Access Assignments page. * 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 calculator on which you can install Microsoft Access, you may use another database tool. If you do this, you m ust also submit the following * an E-R diagram of your database that clearly shows the primary and contradictory 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 designed to create each report. Show both the query design and the query output. * the reports required 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 * implemented correctly * queries are correct Reports 3 marks * provide required information * comprehensive * readable (accurate spelling and grammar) Written report 3 marks * professional, business-like * relevant * cor rect (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.