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...
-
Explain the auditors responsibility to consider compliance with laws and regulations. How does this responsibility differ for laws and regulations that have a direct effect on the financial...
-
What are the steps involved in reversing an impairment loss?
-
Janes Cream Soda, Inc., makes specialty soft drinks. At the end of 2010, Janes had total assets of \($300,000\) and liabilities totaling $220,000. Requirements 1. Write the companys accounting...
-
FlashCo. manufactures 1-GB flash drives (jump drives). Price and cost data for a relevant range extending to 200,000 units per month are as follows: Sales price per unit (current monthly sales volume...
-
Ames Company manufactures and sells three products. Relevant per unit data concerning each product are given below. Selling price Variable costs per unit Machine hours to produce A Product B C $6 $12...
-
The marketing manager of Gilroy Incorporated accepted a rush order for a non-stock item from a valued customer. The manager filed the necessary paperwork with the production department, and a...
-
Bramble.com sells 5800 units of its product for $450 each. The selling price includes a one-year warranty on parts. It is expected that 3% of the units will be defective and that repair costs will...
-
Do you think more of an effort should be made to increase public perception of public defenders given the amount of criticism they receive?
-
Given that indigent defendants have no right to choose the counsel that is appointed to them, what do you think should be the solution if they do not like the attorney appointed them or cannot work...
-
Do you think the two-pronged test announced in Strickland creates too high of a standard by which to judge the effectiveness of assistance of counsel?
-
If you were a defense attorney and thought that your client was guilty, how would you weigh this against your duty to ethically represent him or her and safeguard this person's rights?
-
Given that research shows that there is little difference in the outcome achieved when a client is represented by a private attorney as opposed to an appointed one, why would someone prefer to hire...
-
Find d'y dx if -2x + 7y4 10.
-
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?
-
The critical speed of a rotating shaft depends upon (a) mass (b) stiffness (c) mass and stiffness (d) mass, stiffness and eccentricity.
-
An involute pinion and gear are in mesh. If both have the same size of addendum, then there will be an interference between the (a) tip of the gear tooth and flank of pinion (b) tip of the pinion and...
-
Given \(\theta=\) angle through which the axis of the outer forward wheel turns \(\phi=\) angle through which the axis of the inner forward wheel turns \(a=\) distance between the pivots of front...
Study smarter with the SolutionInn App