New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

41 Pages
ICT707 Data Science Practice

Questions: Assessment and Submission Details Marks: 40% of the Total Assessment for the Course   Submit your assignment to Blackboard Task 3. Please follow the submission instructions in Bl ...

Course

ICT707

Type

Programming

Subject

Database

University

University of the Sunshine Coast

5 Pages
Management

Create one questionnaire that you would send to one stakeholder group with an aim to help you identify further details about the environment, the problem area and/or how the system would operate to he ...

Type

Essays

Subject

Database

43 Pages
Information Technology

This is a chance for you to learn to create DFD's hands on. See attached rubric for grading standards. DELIVERABLE 1. Provide a cover page with the team's number and all teammate names. 2. Create the ...

Type

Programming

Subject

Database

20 Pages
ICT200 Database Design and Development

Question: Task 1 Essay Write an essay on evolution of databases post year 2000, identify new technologies that are replacing RDBMS or o ...

Course

ICT200

Type

Programming

Subject

Database

University

Kings Own Institute

Management

Question

Answered

Assessment name: Short Essay Type: Individual Format: Written report Length: 5 questions, 250 minimum to 300 maximum words per question Students will acquire knowledge and be able to demonstrate the application of this knowledge, including specifically: The use of information technology terms and concepts. Gathering and analysing business user problems and requirements. Modelling business problems and designing integrated solutions. Creating business solutions that support professional practice and ethical behaviour. This is a final assessment of the ISYS2109 Business Information Systems course. The assessment will evaluate key knowledge that you have learnt in the course and whether you can apply it to a case study, the Small Appliances Specialist, Inc. Small Appliances Specialist, Inc. (a fictitious company) is an electronics retailer. The company buys small appliances from different manufacturers and then sells them to their customers. Small Appliances Specialist uses MS Excel to track its sales transactions and sales data for three months of 2017 is included in the provided Excel file. You are required to answer 5 questions in short essay format (i.e in a paragraph with proper opening, body and closing arguments) within 250 minimum to 300 maximum words per question. Utilize the provided dataset of Small Appliances Specialist, populate the data in any way that you prefer to have the results that you can use to support your answers. You can even import the dataset into an Access database for utilizing database functions of query and report to further illustrate your arguments. You are also expected to perform a literature review and provide citing and referencing in your answers if you use information from different sources to support your answers. Academic references (i.e. journal articles, book chapters) are preferred. 5 short Essay Questions: Question 1 - Business Analytics (5 marks): 1.1. What is business analytics? Identify and explain three common techniques that can be used in conducting business analytics. (2 marks) 1.2. Explain how business analytics can be used to help Small Appliances Specialist understand its sales performance (choose one of the following topics: by staff, customer, product item, product category, actual profit vs. target profit). You need to provide clear examples from the case study to demonstrate your arguments. (3 marks) Question 2 - Data Visualization (5 marks): 2.1. What is data visualization? Identify and explain the benefits of three data visualization tools: chart, graph and map (or software). (2 marks) 2.2. Use Small Appliances Specialist’s dataset to populate pivot table so that you can draw a data visualisation chart to compare the percentage of sales vs. percentage of profit for each product category. Describe a problem that you notice by viewing the chart and what recommendations you suggest the business to take to mitigate the problem. (3 marks) Question 3 - Database Design (5 marks): 3.1. The owner of Small Appliances Specialist would like to use MS Access database to replace Excel. Your task is to design an Entity Relationship Diagram (ERD) for Small Appliances Specialist’s Access database based on the information in the Excel dataset. The ERD should have at least three entities that have relationships with each other (sales staff, customer, product, product category, MSRP price, buying cost, discount rate, delivery charges, etc...). The following scenarios should be considered when designing the relationships among your entities, such as a sales staff can sell one or more small appliances; each small appliance has a product category, sales price, buying cost, discount rate, and delivery charge. Your output ERD must show all entities, attributes, primary keys, foreign keys and relationship using proper conventions to support the business. You can use software such as Paint in school’s desktop or draw the diagram on paper. Take a picture or scan your diagram and paste into your short essay submission file. (2 marks) 4.2. Based on your work on the Access database, discuss three benefits of using a relational database for Small Appliances Specialist over MS Excel. (3 marks) Question 4 – Ethics and Security (4 marks): 4.1. Explain your understanding of Ethics in business. Why is it important for companies to be ethical in business? (2 marks) 4.2. Define cybersecurity and its role in business? Discuss two methods to lessen the cybersecurity risks. (2 marks) Question 5 - Designing Business Solutions (6 marks): 5.1. What is system thinking? Explain why applying system thinking in problem-solving is desirable? Discuss the 5 steps of the problem-solving process in designing a business solution. (3 marks) 5.2. Identify an issue or challenge which Small Appliances Specialist might face in the near future (should be different from the problem identified in question 2). Apply the problem-solving process to address this problem. Feel free to manipulate/populate the data using Excel or Access Database to support your arguments. (3 marks)

Management

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

20 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com boasts highly qualified and experienced coursework experts who know the art of writing best quality coursework assignments on any given topic. With a decade experience in this industry, we have become one of the most recognized coursework help services providers in USA. Our coursework writing services include essay writing help, dissertation writing services, term paper writing help, case study help, etc. Our experts are well acquainted with all types of coursework assignments and help students with writing any type of coursework assignment effortless. This is why numerous students prefer to buy coursework online from us.

More Management: Questions & Answers

Q
icon

We aren't endorsed by this University

ICT707 Data Science Practice

Questions: Assessment and Submission Details Marks: 40% of the Total Assessment for the Course   Submit your assignment to Blackboard Task 3. Please follow the submission instructions in Blackboard. The assignment will be marked out of a total of 100 marks and forms 40% of the total asse ...

View Answer
Q

Management

Create one questionnaire that you would send to one stakeholder group with an aim to help you identify further details about the environment, the problem area and/or how the system would operate to help solve the problem.•    Identify which stakeholder you are going to send the q ...

View Answer
Q

Information Technology

This is a chance for you to learn to create DFD's hands on. See attached rubric for grading standards. DELIVERABLE 1. Provide a cover page with the team's number and all teammate names. 2. Create the diagrams in Lucidchart, then use "File > Download As > .PNG" and select "Crop to Content". 3. ...

View Answer
Q
icon

We aren't endorsed by this University

ICT200 Database Design and Development

Question: Task 1 Essay Write an essay on evolution of databases post year 2000, identify new technologies that are replacing RDBMS or other traditional approaches. Using a case study explain how these advanced database technologies are ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?