Instructions:
This assignment builds on your first two Access assignments and asks you to consider the process of designing and implementing a database system solution.
The first step in assignment is to create a systems analysis report 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 with this project.
You do NOT have to create any data input forms for this assignment. You do NOT have to consider whether or not 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.
How to use a database, review this document titled Supplementary Information.
If you do not have access to a computer on which you can install Microsoft 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 primary 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 designed to create each report. Show both the query design and the query output.
• the reports required in the assignment
Database Design
Your database must conform to the relational database guidelines as outlined in of the textbook and in the Access e-text.
• Tables are structured correctly with appropriate keys.
• Tables are related correctly.
• Database has minimum number of records in each table as specified in assignment instructions.
• Database has all test data as specified in assignment instructions.
Reports and Queries
• Queries and reports identified in the system analysis report have been created and include the questions managers are considering based on the mini-case.
• Reports are readable and professional looking.
Systems Analysis Report
• understandable (clearly defines the solution), professionally written, and organized
• comprehensive
• project management considerations are appropriate and draw on the theory explained.