Assessed Module Learning outcomes ALO1: Critically evaluate the appropriateness of how software is structured and how...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assessed Module Learning outcomes ALO1: Critically evaluate the appropriateness of how software is structured and how a database is designed. AL02: Apply good software development practice by employing a programming language in combination with the design and implementation of relational databases. . • ALO3: Design and implement a computer program of moderate size and complexity. ALO4: Plan and implement testing and verification of the implemented system 1. DESCRIPTION OF THE COURSEWORK. IBM have made available a data set that describes the working of a small chain of coffee shops in the USA. The csv files are available from https://www.kaggle.com/vichang/coffee-shop-sample-data-1113 and the DLE. • Dates.csv • customer.csv generations.csv (The data from this file should not be used in this coursework) • pastry inventory.csv • product.csv sales targets.csv (The data from this file should not be used in this coursework) sales_outlet.csv staff.csv 201904 sales reciepts.csv The files describe the staff, shops and products. The shops sell pastries. An important issue is that if the pastries are not sold then they are thrown away. The file "pastry inventory.csv" contains information about the pastries thrown away as waste. The file "staff.csv" contains a reference to HQ. Please assume the HQ has the same address as the warehouse. Design a database to store the data in the csv files. The database design should include an entity relation diagram, using the crowsfoot notation. You can either use MySQL workbench or https://app.diagrams.net/, or another graphical package approved by the module leader. The database design should follow the third normal form (3NF). A SQL schema for all the tables should be produced. Write a short discussion of the design choices for the database. Write a python script to read in the csv files and populate the database. The database should be stored in a SQLite database in a single file. The data from the csv files may have missing values. Discuss how you cleaned up the data. Write a GUI interface, using for example Tkinter, to input new customers to the database. Coursework 2021-22 Page 2 of 4 COMP5000 Demonstrate that the information about the new customer has been correctly added to the database by including a screenshot. Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL. • Calculate the total numbers of customers who are Baby Boomers (ages between 1946 and 1964.) • Draw a histogram of the "% waste". • Calculate the mean waste for the sales outlets. Provide screen-shots to show the statistical analysis part of the GUI working. < What you need to submit to the DLE a) A document (in pdf or word) with a summary of your results. This docum formal academic report. The document should include: i) The entity relationship diagram and the design choices for the databa ii) The SQL schema for all the tables. iii) A discussion of any data cleaning required, if there are for example missing values. 06:14 Demonstrate that the information about the new customer has been correctly added to the database by including a screenshot. Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL. • Draw a histogram of the "% waste". . Calculate the mean waste for the sales outlets. Provide screen-shots to show the statistical analysis part of the GUI working. • Calculate the total numbers of customers who are Baby Boomers (ages between 1946 and 1964.) What you need to submit to the DLE a) A document (in pdf or word) with a summary of your results. This document is not a formal academic report. The document should include: 2. MARKING SCHEME The total number of marks for this coursework is 100. 3 Subtask 1 The entity relationship diagram. 2 The written discussion of the design choices for the database. The SQL schema for the tables. 4 5 6 7 8 9 i) The entity relationship diagram and the design choices for the database. ii) The SQL schema for all the tables. iii) A discussion of any data cleaning required, if there are for example missing values. iv) The screen-shots showing the working of the GUIS. b) All the python code written for the coursework. I suggest you put all the python code in a zip file. c) The SQLite database you created. The discussion on how you cleaned the data up. The python code to create the database. A brief report about any data cleaning required. The GUI to add a customer to the database. 4G The analysis part of the GUI which produces the histogram plot of waste (5 marks), the mean waste for each sales outlet (5 marks), and the number of customers who are baby boomers (5 marks). The documentation in the python scripts. 3. GRADE CRITERIA Coursework 2021-22 50-59% 60-69% More than 70% When awarding marks for individual criteria, I shall employ the following guidelines, Mark 0-49% < Page 3 of 4 R Weighting 15 marks 10 marks 5 marks 10 marks 10 marks 10 marks 20 marks 15 marks 5 marks Criteria The quality of the work has not met the learning outcomes. The understanding and application of fundamental concepts and techniques is COMP5000 questionable. Work of this quality would not be acceptable in professional employment. The quality of work has only met the threshold level but still requires further work to get it to a better standard. The submission contains logical or analytical errors related to analysis and design techniques. It only demonstrates a basic understanding of the subject competence. Further improvement is required to demonstrate personal thoroughness, effort and independent learning. The quality of the work submitted suggests that you are able to apply the analysis and design techniques well. The work you have submitted is substantially correct and complete. It demonstrates a good unders subject competence and personal thoroughness, effort and indep learning. The quality of work is outstanding with no significant flaws. It dem high level of subject knowledge and competence; personal thorough effort and independent learning; and possibly significant additional analytical/critical thought. Well done! Assessed Module Learning outcomes ALO1: Critically evaluate the appropriateness of how software is structured and how a database is designed. AL02: Apply good software development practice by employing a programming language in combination with the design and implementation of relational databases. . • ALO3: Design and implement a computer program of moderate size and complexity. ALO4: Plan and implement testing and verification of the implemented system 1. DESCRIPTION OF THE COURSEWORK. IBM have made available a data set that describes the working of a small chain of coffee shops in the USA. The csv files are available from https://www.kaggle.com/vichang/coffee-shop-sample-data-1113 and the DLE. • Dates.csv • customer.csv generations.csv (The data from this file should not be used in this coursework) • pastry inventory.csv • product.csv sales targets.csv (The data from this file should not be used in this coursework) sales_outlet.csv staff.csv 201904 sales reciepts.csv The files describe the staff, shops and products. The shops sell pastries. An important issue is that if the pastries are not sold then they are thrown away. The file "pastry inventory.csv" contains information about the pastries thrown away as waste. The file "staff.csv" contains a reference to HQ. Please assume the HQ has the same address as the warehouse. Design a database to store the data in the csv files. The database design should include an entity relation diagram, using the crowsfoot notation. You can either use MySQL workbench or https://app.diagrams.net/, or another graphical package approved by the module leader. The database design should follow the third normal form (3NF). A SQL schema for all the tables should be produced. Write a short discussion of the design choices for the database. Write a python script to read in the csv files and populate the database. The database should be stored in a SQLite database in a single file. The data from the csv files may have missing values. Discuss how you cleaned up the data. Write a GUI interface, using for example Tkinter, to input new customers to the database. Coursework 2021-22 Page 2 of 4 COMP5000 Demonstrate that the information about the new customer has been correctly added to the database by including a screenshot. Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL. • Calculate the total numbers of customers who are Baby Boomers (ages between 1946 and 1964.) • Draw a histogram of the "% waste". • Calculate the mean waste for the sales outlets. Provide screen-shots to show the statistical analysis part of the GUI working. < What you need to submit to the DLE a) A document (in pdf or word) with a summary of your results. This docum formal academic report. The document should include: i) The entity relationship diagram and the design choices for the databa ii) The SQL schema for all the tables. iii) A discussion of any data cleaning required, if there are for example missing values. 06:14 Demonstrate that the information about the new customer has been correctly added to the database by including a screenshot. Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL. • Draw a histogram of the "% waste". . Calculate the mean waste for the sales outlets. Provide screen-shots to show the statistical analysis part of the GUI working. • Calculate the total numbers of customers who are Baby Boomers (ages between 1946 and 1964.) What you need to submit to the DLE a) A document (in pdf or word) with a summary of your results. This document is not a formal academic report. The document should include: 2. MARKING SCHEME The total number of marks for this coursework is 100. 3 Subtask 1 The entity relationship diagram. 2 The written discussion of the design choices for the database. The SQL schema for the tables. 4 5 6 7 8 9 i) The entity relationship diagram and the design choices for the database. ii) The SQL schema for all the tables. iii) A discussion of any data cleaning required, if there are for example missing values. iv) The screen-shots showing the working of the GUIS. b) All the python code written for the coursework. I suggest you put all the python code in a zip file. c) The SQLite database you created. The discussion on how you cleaned the data up. The python code to create the database. A brief report about any data cleaning required. The GUI to add a customer to the database. 4G The analysis part of the GUI which produces the histogram plot of waste (5 marks), the mean waste for each sales outlet (5 marks), and the number of customers who are baby boomers (5 marks). The documentation in the python scripts. 3. GRADE CRITERIA Coursework 2021-22 50-59% 60-69% More than 70% When awarding marks for individual criteria, I shall employ the following guidelines, Mark 0-49% < Page 3 of 4 R Weighting 15 marks 10 marks 5 marks 10 marks 10 marks 10 marks 20 marks 15 marks 5 marks Criteria The quality of the work has not met the learning outcomes. The understanding and application of fundamental concepts and techniques is COMP5000 questionable. Work of this quality would not be acceptable in professional employment. The quality of work has only met the threshold level but still requires further work to get it to a better standard. The submission contains logical or analytical errors related to analysis and design techniques. It only demonstrates a basic understanding of the subject competence. Further improvement is required to demonstrate personal thoroughness, effort and independent learning. The quality of the work submitted suggests that you are able to apply the analysis and design techniques well. The work you have submitted is substantially correct and complete. It demonstrates a good unders subject competence and personal thoroughness, effort and indep learning. The quality of work is outstanding with no significant flaws. It dem high level of subject knowledge and competence; personal thorough effort and independent learning; and possibly significant additional analytical/critical thought. Well done!
Expert Answer:
Answer rating: 100% (QA)
Creating a comprehensive solution for your coursework involves several steps Below is a breakdown of ... View the full answer
Related Book For
Auditing Cases An Interactive Learning Approach
ISBN: 978-0133852103
6th edition
Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt
Posted Date:
Students also viewed these programming questions
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Key West Electronics, located in Miami, was just ten years old in early 2010, with sales expected to pass the $500 million and net income just beginning to turn positive after years of losses or near...
-
Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...
-
Consider the pooled t variable Tp from part (b) of the previous exercise. a. Use this t variable to obtain a pooled t confidence interval formula for 1 2 . b. The article Effect of Welding on a...
-
Emcee Inc. manufactures and sells two fruit drinks: Kostor and Limba. Budgeted and actual results for 2017 are as follows: Required: 1. Compute the total sales-volume variance, the total sales-mix...
-
How close should the supervisor be to the activity?
-
Describe trends in managerial accounting.
-
Carol Carpet manufactures broadloom carpet in seven processes: spinning, dyeing, plying, spooling, tufting, latexing, and shearing. In the Dyeing Department, direct materials (dye) are added at the...
-
At what rate will an expected value of GH100 in 25 years offer if an investment value of GH 29 is offered today? A. 6.02% B. 8.54 C. 5.08% D. 4.83%
-
WRITE IN PYTHON AND IN THE GIVEN CODE coderbyte medium Back-end Challenge In the Python file, write a program to perform a GET request on the route Time left: Unlimited time...
-
I am attempting to figure out how to 36.125 was calculated for New Projects Weekly Average Demand. I am looking for an explanation with an example using one of the products below. All information is...
-
I have attached a case study, primarily based on your textbook chapter reading assignments. The background material for the case also references chapters 3 and 15, not assigned for this course....
-
On December 1 , 2 0 2 5 , Sandhill Distributing Company had the following account balances.DebitCash$ 7 , 1 0 0 Accounts Receivable 4 , 5 0 0 Inventory 1 1 , 9 0 0 Supplies 1 , 2 0 0 Equipment 2 2 ,...
-
Cindy Greene works at Georgia Mountain Hospital. The hospital experiences a lot of business closer to summer when the temperature is warmer. Cindy is meeting with her supervisor to go over the budget...
-
Use z scores to compare the given values. Based on sample data, newborn males have weights with a mean of 3247.4 g and a standard deviation of 575.4 g. Newborn females have weights with a mean of...
-
Gignment FULL SCAL Exercise 4- The following ndependent situations require professional judgment for determining when to recognize revenue from the transactions. Identify when revenue should be...
-
Kohler Corporation reports the following components of stockholders' equity on December 31, 2017. Common stock-$20 par value, 100,000 shares authorized, 60,000 shares issued and outstanding Paid-in...
-
Find the equations of the ellipses satisfying the given conditions. The center of each is at the origin. Passes through (2, 2) and (1, 4)
-
Go to the Global Reporting Initiative's website (try www.globalreporting.org) and obtain the G4 Sustainability Reporting Guidelines Part 2 Implementation Manual and read the assurance guidance...
-
What can professionals do to overcome the confirmation tendency?
-
How might the availability tendency contribute to poor choices in the sampling process? How might an auditor mitigate the effects of this tendency?
-
Toby Kelly is the recently appointed Marketing Director of Global International plc. The company is multinational marketer of sports equipment, selling a range of well-known brands in virtually every...
-
Assume that a U.S. company has a French subsidiary whose functional currency is the French franc. Explain why the translation adjustment is not included as a component of net income on the...
-
P 11-11 Workpaper for proportionate consolidation (joint venture) Pop Corporation owns a 40 percent interest in Son Company, a joint venture that is organized as an undivided interest. In its...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App