Assignment 5: Using Database Software to Design a Customer System for Auto Sales Assignment 5 is worth 15 percent of your final grade for this course. Read the Hands-on MIS project ImprovingDecision Making: Using Database Software to Design a Customer System for Auto Sales on pages 433–434 of the textbook. Follow the instructions below.Instructions:This assignment builds on your first two Access assignments and asks you to consider the process of designingand implementing a database system solution.The first step in this assignment is to create a systems analysis report as outlined on page 434 of the textbook.This is a critical step in the systems development process as it helps you to define the requirements for the work you will go on to do. Add a section called “Project Management Considerations” to this report; in this section, explain the project management considerations that the organization must take into account if they go ahead withthis project.You do NOT have to create any data input forms for this assignment. You do NOT have to consider whether ornot to use Ace's existing customer database.The next step in the assignment is to create the database suggested in your report. Note that one of the requirements here is that it must align with the report you have created – that is, it satisfies all of the requirements noted, but only the requirements noted.After the database is created, populate each table with at least 10 records.For this assignment, you must hand in:a Word document containing your systems analysis report which must include the information specified on page 434 an Access database with tables, reports, and queries as described in the textbook and in these instructionsMarking criteria:You will be marked according to the following criteria:Database Design (20 marks total)Your database must conform to the relational database guidelinesTables are structured correctly with appropriate keys. (12 marks)Tables are related correctly. (4 marks)Database has minimum number of records in each table as specified in assignment instructions. (2 marks)Database has all test data as specified in assignment instructions. (2 marks)Reports and Queries (10 marks total)Queries and reports identified in the system analysis report have been created and include thequestions managers are considering based on the mini-case on pages 433-434. (2 marks)Queries are correct. (4 marks)Reports are professional looking and readable. (4 marks)Systems Analysis Report (20 marks total)understandable (clearly defines the solution), professionally written, and organized (2 marks)comprehensive (includes all requirements listed on page 434) (15 marks)

SmartExpert

(118)

Status NEW Posted 20 Jun 2017 02:06 AM My Price 12.00

Ass-----------ign-----------men-----------t 5-----------: U-----------sin-----------g D-----------ata-----------bas-----------e S-----------oft-----------war-----------e t-----------o D-----------esi-----------gn -----------a C-----------ust-----------ome-----------r S-----------yst-----------em -----------for----------- Au-----------to -----------Sal-----------es-----------

Attachments

file 1497925491-Assignment 5 Using Database Software to Design a Customer System for Auto Sales.docx preview (1662 words )

A-----------ssi-----------gnm-----------ent----------- 5 -----------Usi-----------ng -----------Dat-----------aba-----------se -----------Sof-----------twa-----------re -----------to -----------Des-----------ign----------- a -----------Cus-----------tom-----------er -----------Sys-----------tem----------- fo-----------r A-----------uto----------- Sa-----------les----------- S-----------tud-----------ent----------- Na-----------me ----------- Na-----------me -----------of -----------the----------- in-----------sti-----------tut-----------e -----------Pro-----------fes-----------sor----------- D-----------ate----------- C-----------ont-----------ent-----------s ----------- TO-----------C \-----------o &-----------quo-----------t;1------------3&-----------quo-----------t; -----------\h -----------\z -----------\u -----------Ass-----------ess-----------men-----------t I-----------tem----------- 4(-----------Ass-----------ign-----------men-----------t 1----------- Pa-----------rt -----------1) -----------PAG-----------ERE-----------F _-----------Toc-----------389-----------091-----------824----------- \h----------- 4T-----------ask----------- 1 -----------(SW-----------OT -----------Ana-----------lys-----------is)----------- PA-----------GER-----------EF -----------_To-----------c38-----------909-----------182-----------5 \-----------h 4-----------Tas-----------k 2----------- PA-----------GER-----------EF -----------_To-----------c38-----------909-----------182-----------6 \-----------h 5-----------2.1----------- Pr-----------oje-----------ct -----------Cha-----------rte-----------r P-----------AGE-----------REF----------- _T-----------oc3-----------890-----------918-----------27 -----------\h -----------52.-----------2 P-----------roj-----------ect----------- Ap-----------pro-----------ach----------- PA-----------GER-----------EF -----------_To-----------c38-----------909-----------182-----------8 \-----------h 5-----------2.3----------- Pr-----------oje-----------ct -----------Sta-----------keh-----------old-----------er

Not Rated(0)

• Buy Answer