Answered: Create a program that allows you to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Console

Monthly Sales program

COMMAND MENU

add - Add sales for a specified month

view - View sales for specified month

edit - Edit sales for specified month

totals - View sales summary for the year

exit - Exit program

Command: add

Three-letter Month: jan

Sales Amount: 10317

Sales amount for Jan is 10,317.00.

Command: add

Three-letter Month: feb

Sales Amount: 15293

Sales amount for Jan is 15,293.00.

Command: view

Three-letter Month: jan

Sales Amount: 14317

Sales amount for Jan is 14,317.00.

Command: edit

Three-letter Month: jan

Sales amount for Jan is 14,317.00.

Command: totals

Yearly total: 29,610.00

Monthly average: 14,805.00

Command: view

Three-letter Month: july

Invalid three-letter month.

Command: exit

Bye!

Requirements for the program:

The program should use a list to store the sales data for each month with the three-letter abbreviation for the month (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec) as the key for each item.
When the program starts, it should read the sales data inserted from the user.
If the user edits the sales data, the program should edit the data
Must be able to use the add command to add the data for the given month
If the user selects total, the program should calculate the total sales and average monthly sales.
Use functions to view sales, edit sales, calculate the total, and calculate average.

Expert Solution

Step 1

The program should peruse the text record named monthly_sales.txt. The
text document comprises of columns that contain three-letter shortened forms
for the month and the month to month deals.
'''
monthly_sales = {}
with open('monthly_sales.txt', 'r') as record:
substance = file.read()
for line in contents.split('\n'):
string = line.split()
monthly_sales[string[0]] = string[1]

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions