Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
Instructions:
Visualizing Business Problems
Gregory Dayes
Colangelo College of Business, Grand Canyon University
MIS 605
Gregory Daye Visualizing Business Problems
Instructor Name: Helen Craig
June 29, 202
Visualizing Business Problems
Explain what methods will be used to set the parameters for the query.
To begin with, we will first identify the product ID using the name of the product given in the problem. This method is because product ID is one of the primary keys that connects with most of the Production and Sales schema tables. Secondly, we will determine the quantities sold and their prices.
Define the specific questions that need to be asked and answered to address the specified business problem.
To get an understanding, we should ask the following questions:
How many products are available in stock, and how many are sold daily?
Where the product is being stored, and how is communication working. This idea will help address any questions on the productivity and availability of the product.
How many products are available in Inventory, and at which location?
Explain how the entity-relationship diagram (ERD) was used in addressing questions 1-2 above.
ER diagram is attached above. Production.Product Table is linked with Sales.SalesOrderDetail by ProductID tells us how many items with model ‘LL Road Frame-Black 60’ were sold and at what unit price. Additionally, we can identify using Production.product inventory Table to know the available quantity of the LL Road Frame – Black, 60 at each location. Also, we can narrow down our search by including ProductSubcategory Table, which is directly linked to the Product table and Product Category. We will also use Production.Location table to identify the count of products at each location.
Describe ethical dilemmas that could be encountered due to the research being done to address the business problem.
DB Administrator’s ethical dilemma may be regarding the repercussions of drilling onto any personal information, ultimately leading to criminal activitiesfor instance, having access to employees, customers, vendors, and management personal and private information. It is essential to establish a code of conduct and perhaps an organization that DBM/DBA affiliates with to ensure professionalism is conducted and scrutinized (Karale, 2021).
Explain what resources you will use to assist with addressing ethical dilemmas.
To maintain a high level of professional ethics, we will look forward to identifying potential risks involved and how such situations can be handled within the boundary of law without hampering the company’s reputation if I find myself spotting activity that should be reported. This method will enable me to have the confidence and know-how to report abuse or criminal activity by employees. As well as, every organization has a policy guiding such activities; we can always refer them and make sure all the employees go through such training from time to time (Ljubuncic & Litterer, 2019).
References
Karale, A. (2021). The Challenges of IoT addressing Security, Ethics, Privacy and Laws. Internet of Things, 100420. https://www.sciencedirect.com/science/article/pii/S2542660521000640
Ljubuncic, I., & Litterer, T. (2019). System Administration Ethics. Apress. https://link.springer.com/content/pdf/10.1007/978-1-4842-4988-8.pdf
RUBRIC |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow |
Gregory Daye Visualizing Business Problems