ScholarMatic | 24/7 Homework Help

ScholarMatic Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Database Design

by | Nov 29, 2023 | questions

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)

ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99


  

Click Order Now to get 100% Original Answer Customized to your instructions!

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

ScholarMatic: Get Started

Assignment Writing Service

Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!