Reference no: EM132619111
CIS5100 Professional Skills for Information Systems Assignment - University of Southern Queensland, Australia
Assessment Title - Database Management System (DBMS) & Decision Support System (DSS)
ASSIGNMENT REQUIREMENTS -
LEARNING OBJECTIVES - Applicable course objective:
Course Objective 1: critique information systems concepts to identify and resolve organisational problems and to develop ethical considerations within a business context.
Course Objective 2: identify the appropriate information systems to develop practical solutions within a business context.
Course Objective 3: communicate information systems concepts to both technical and non-technical audiences within a business context.
PREAMBLE - Dr Rod N Berry retired in 2018 after a long career in General Practice Medicine. To keep busy and to fulfil a lifelong dream, Dr Rod N Berry started a Memorabilia mail order business, specialising in importing "Star Trek" related products, called "The Borg Collective". The business specialises in imported Trek merchandise such as statues, iPhone skins, giftware, bobbleheads, mugs, clothing and other assorted Star Trek related paraphernalia to customers via mail order around Australia.
Star Trek merchandise has become very popular, since the release of the new Star Trek: Discovery and Star Trek: Picard television series have brought the phenomenon back into the public's attention; and Dr Rod N Berry's business has experienced a rapid growth in their mail orders. When Dr Rod N Berry first retired, the business bought a personal computer to help manage the books and finances.
The Borg Collective is located at Shop 19, 63 James-Tiberius Boulevard, Toowoomba (about 100 km west of Brisbane). Their ABN is 126 279 410. Dr Rod N Berry can be contacted via phone on (07) 4632 1701;
Dr Rod N Berry is extremely impressed with our computing firm "Federation Systems" and the business has contracted our firm to assist them in setting up their various computer-based information systems.
Part A: The first computer-based information system that Dr Rod N Berry is interested in is a Database Management System (DBMS) utilising Microsoft Access (any version from Access 2007 to current). The DBMS will store all the business's customer details, information about the stock items that the business sells, the suppliers that the business uses and all postal order transactions for the business. It will allow Dr Rod N Berry to run several queries on the data, which the business has specified below, and they wish to be able to print out an invoice for each customer at the end of each month.
Part B: The next computer-based information system that the business is interested in is a Decision Support System (DSS) utilising Microsoft Excel (any version from Excel 2007 to current). The DSS will analyse sales trends for the business to determine future courses of action for the business.
Dr Rod N Berry would like the information in the Database Management System (DBMS) (Assignment 1 Part A) imported into Microsoft Excel (any version from Excel 2007 to current) so that the information can be summarised as a report and some future analysis of sales trends performed. The suppliers used by the business, source items from either Montenegro (ME) or Belize (BZ). They allow the business to select from either of these two regions on an ad hoc basic depending on the most favourable exchange rate at the time.
Dr Rod N Berry has noted that several the business's competitors are providing a discount to customers who place large orders. The business would like to see what affect adopting a similar policy would have on the business. The business has also noted a growing number of online businesses are starting to provide free freight delivery as a way of encouraging more online business; the business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination for the business if they were to adopt this policy too.
Part C: Dr Rod N Berry also has several questions relating to the two computer-based information systems in Part A & Part B that he would like you to answer, prepare an Essay to answer these questions he has listed.
Assignment 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 Rod N Berry's customer, item, supplier and order data for the business, which has been provided as follows:
Dr Rod N Berry has provided to us a partial list of the business's customers, stock items, and suppliers and a partial list of the business's postal orders placed between January and June 2019 to use as test data in four comma delimited text files, which can be found on your firm's Intranet (CIS5100 Study Desk).
Dr Sev N O'Nine, 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
Assignment Part B (Decision Support System)
Dr Sev N O'Nine, 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 Spreadsheet
Assignment Part C (Analytical Essay)
Dr Sev N O'Nine has asked you to develop an analytical essay (between 750 and 1000 words in length) to the client, Dr Rod N Berry outlining the major issues that the Decision Support System's results have highlighted. Create a Word Document (using Word 2007 to current) and name it '[lastname] [initial] _ [student number] _ [course code] _ [assignment number_(part_c)' eg. genrichr_0050051005_cis1000_assign1_(part_c).docx).
The body of your essay should consider the following issues:
From Part A (Approx. 250 - 350 words):
Define what a Database Management System is.
Explain why a Database Management System is the appropriate tool for this project.
From Part B (Approx. 500 - 650 words):
Define what a Decision Support System is.
Explain why a Decision Support System is the appropriate tool for this project.
From the results of the Decision Support System results discuss the following (keeping in mind the information provided in the preamble on page 2):
Which Mark-up Type would be most appropriate for the business? Why?
What would be the impact on the business's profit if the plan to provide a discount to large orders were implemented? Why?
Which Recommended Freight Type would be most appropriate for the business? Why?
Which country would be most appropriate for the business to import from at the moment? Why?
Attachment:- Professional Skills for Information Systems Assignment Files.rar