Cis5100: Database Management System Assessment Answer
IT Assignment Help:
Task: Assignment 1: Part A (Database Management System) Your firm’s Systems Analyst has developed a database structure that has been determined to be suitable to create a database to store Dr Wagner’s customer, item, supplier and order data for the business, which has been provided as follows: Dr Wagner has provided to us a partial list of the business’s customers, stock items, and suppliers and a partial list of her postal orders for the third quarter 2017 (Jul – Sept) to use as test data in four comma delimited text files which can be found on your firm’s Intranet (CIS1000 Study Desk). Mrs Georgie Handel, your manager, has set up the following tasks for you to complete for this phase of the project: 1. Create a Database and import the four (4) Text files into four (4) Tables 2. Modify Table Design 3. Set Primary Keys 4. Create Relationships between the Tables 5. Edit Customers Table 6. Create Data and Update Queries 7. Create an Invoice Report 8. Create an End of Project Presentation to the Client Task 1: Create and Import Task 2: Modify Table Design Task 3: Set Primary Keys Task 4: Create Relationships between the Tables Task 5: Edit Customers Table Task 6: Create Data and Update Queries Assignment 1: Part B (Decision Support System) Mrs Georgie Handel, your manager, has set up the following tasks for you to complete for this phase of the project: 1. Create a Spreadsheet and import the four (4) Access Tables into four (4) Worksheets 2. Data Validation Check 3. Create an Index Worksheet 4. Create a Data Input Worksheet Template for later use 5. Create a Calculations Worksheet Template for later use 6. Create Name Ranges for the Customers, Items, and Suppliers data 7. Create a Report Worksheet and set up the column headings 8. Modify the Report Worksheet by Cell Referencing all the Orders Table data 9. Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data 10. Modify the Data Input Worksheet to include extra data needed for later tasks 11. Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU) 12. Modify the Report Worksheet by using a Nested IF to calculate Selling Price 13. Modify the Report Worksheet by using a Nested IF to calculate Freight Cost 14. Modify the Report Worksheet by using a AND / IF to calculate Item Discount 15. Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount 16. Modify the Data Input Worksheet to include extra data needed for later tasks 17. Modify the Calculations Worksheet by using simple formulas 18. Modify the Data Input Worksheet by Cell Referencing all the Calculations data 19. Create eight (8) Scenarios on the Data Input Worksheet 20. Create a Scenario Summary of the eight (8) Scenarios 21. Create a Documentation Worksheet 22. Create an Analytical Essay to describe the findings made using the SpreadsheetBuy Cis5100: Database Management System Assessment Answer Online
Talk to our expert to get the help with Cis5100: Database Management System Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
Get Online Support for Cis5100: Database Management System Assessment Answer Assignment Help Online
Resources
- 24 x 7 Availability.
- Trained and Certified Experts.
- Deadline Guaranteed.
- Plagiarism Free.
- Privacy Guaranteed.
- Free download.
- Online help for all project.
- Homework Help Services
