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...
-
1. What would have happened if HTSL tried to develop a system like ALM on its own instead of turning to Kovair? Discuss both pros and cons of the likely outcome. 2. The ALM software is intended to...
-
The fictional balance sheet of MAC Company using IFRS is shown below. Review it and describe at least three differences in their presentation from what is shown in Exhibit 411. Ignore the fact that...
-
Suppose $N$ experimental units are randomly assigned to treatment or control by tossing a coin. A unit is assigned to treatment if the coin toss comes up heads. Assume that the probability of tossing...
-
Anzola Company had the following data (in millions) for a recent period. Fill in the blanks. There was no beginning or ending inventories. a. Sales $920 b. Direct materials used 350 c. Direct labor...
-
Carefully read the following two reports, from the leading security firms (available for downloads from the stream website), produced in the last couple of years that analyse and predict threat...
-
Surkis Company acquires equipment at a cost of $42,000 on January 3, 2017. Management estimates the equipment will have a residual value of $6,000 at the end of its four-year useful life. Assume the...
-
Nickles Motors Acceptance Corporation ("NMAC") has a judgment against Markell for $10,000 and, in an effort to satisfy the judgment, serves a writ of garnishment on Markell's employer. Unbeknownst to...
-
Briefly summarize the elements of conspiracy.
-
Compare and contrast conspiracy at common law and under modern-day statutes.
-
Does solicitation require that the crime that was solicited actually be completed?
-
Explain the two levels of mens rea for the purposes of complicity.
-
Compare and contrast the two main varieties of vicarious liability
-
A tender Multiple Choice a. May not be revoked after the offer is provided b. Does not usually require a seal or payment of money for consideration c. May generally be revoked at any time prior to...
-
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?
-
With reference to Exercise 4.5, find an expression for the distribution function \(F(x)\) of the random variable. Data From Exercise 4.5 k 4.5 Given that f(x): = is a probability distribution for 2x...
-
Given that \(f(x)=\frac{k}{2^{x}}\) is a probability distribution for a random variable that can take on the values \(x=\) \(0,1,2,3\), and 4 , find \(k\).
-
Check whether the following can define probability distributions and explain your answers. (a) \(f(x)=\frac{1}{4}\) for \(x=10,11,12,13\) (b) \(f(x)=\frac{2 x}{5}\) for \(x=0,1,2,3,4,5\) (c)...
Study smarter with the SolutionInn App