Using Figma create outline for this flutter project - Display list of food items (have checkboxes next to them so you can select them, pictures of the food items, price of the food item, quantity(have a + item next to the food item so every time you hit the + it will increment by 1 and a - to decrement by 1 in case customer wants to decrease the item, total price of the order and finally a submit button after ordering all the food items.

Use Case Name

Update Sale Invoice by adding more products

Triggering Event

Customer would like to change what they would like to buy.

Brief Description

Allows the Owner to change a sale invoice.

Actors

School Owner

Related Use Cases

Preconditions

Owner is logged into the system and the sale menu is displayed.

Post Conditions

Update sale is saved to the database and now can be printed or emailed as a receipt for the customer.

Flow of activities

Actor

System

1.             

Requests to search a sale invoice.

Prompts for search by customer’s phone number.

2.             

Enters customer’s phone number.

Displays the sale invoices associated with the entered phone number, as well as the customer’s name.

3.             

Selects one sale invoice.

Displays all the details in the invoice, including customer’s name and address, the invoice number, the invoice date, and all the products added into the sales invoice and the quantity and price for each product.

4.             

Request to add more products.

Displays a list of products.

5.             

Select one product and enter the quantity to buy.

Adds the product and its quantity to the sale invoice. 

6.             

Repeats step5 until all products have been added.

Prompts to save.

7.             

Confirms to save.

Saves the sale invoice and details

please create class diagram ad sequence diagram

SQL Server

TASK

Is you will need to formalize the database design and use a DBMS (SQL Server, MySQL, etc) to build the database. You will NOT be required to build all the functionality as described above as part of this initial project. You will be responsible only for specific parts of the system and implementing specific features as described below. You should complete the following steps:
1. Analyze the data requirements described in the previous section. Decide which tables are required and which fields should go in which table. Normalize your design. If you wish, you may use an entity-relationship diagram. Create a table design showing the relationships between each table.
It is now time for your instructor to check your progress. After you have finished the preliminary design for the High Spirits Imports Management System, contact your instructor for a brief review.
2. Using your DBMS, create an SQL script to create the High Spirits database. Name the database HSxxxxx, where xxxxx is your student number. Save your script as step2.sql.
3. Create the tables in the HighSpirits database. You do not need to specify relationships in this script. Save your script as step3.sql.
4. Create a default database diagram. Add primary keys and relationships where they make sense. Print your diagram. Create a script that will add the necessary primary keys and foreign keys to the appropriate tables. Save your script as step4.sql.
5. Create a script that will create the needed constraints to enforce the data rules Mr. Tipple has specified. Save your script as step5.sql.
6. Using the provided source documents (see pictures 1 - 5 or download pdf file) populate your database with test data. Minimally, you need:

---->>> url for the pdf file

 4 customers (include High Spirits as a customer so you can track purchase transactions).
 5 transactions - at least 3 are sales type, 2 of which must be paid.
 4 countries, types and sizes
 6 products, each with a quantity specified
Save your script as step6.sql
7. Create a script that will show a list of customers (first name, last name, and phone number) and the total number of sales transactions they have made. Save your script as step7.sql. After running the script, save a screen capture of the output and save it as step7-output.jpg

8. Create a script that will show a list of products (product name, type, size) that have been purchased. Note: You must use an outer join for this query; a subquery is not acceptable. Save your script as step8.sql. After running the script, save a screen capture of the output and save it as step8-output.jpg
9. Create a script that will show a list of products (product name, type, size, supplier) that are from Australia. Save your script as step9.sql. After running the script, save a screen capture of the output and save it as step9-output.jpg
10. Create a script that will show a list of products (product name, type, size, customer, retail price, quantity sold). The script should also calculate the sum of the price field and the sum of the quantity sold from all times the products were sold and display it as a calculated field. Do not include purchases (Remember the status field is set to 0 for sales and 1 for purchases). Save your script as step10.sql. After running the script, save a screen capture of the output and save it as step10-output.jpg
11. Using your DBMS Help feature, explore the use of the SHOW command to display the contents of your database. Create a script that will display a list of tables in the database. Save this script as step11a.sql. Then create a script for each of the four main tables (Customers, Transactions, Products, Transaction details that will display all of the columns in the table. Save your scripts as step11b.sql to step11e.sql.
12. Finally, you will need to create the HS_Employees database. Using the data in the HS-Employees.xls spreadsheet, create a script to populate the Employees database with the data found there. Employee ID's should be unique and start with the two employee initials and then increment by a value of 1. It should be the primary key. Social Insurance numbers are unique for each individual. However, this does not make for a good Primary Key. You must ensure that there is not the ability to incorrectly enter someone else's SI number by mistake by making this field unique. Create the employee database and populate the employees table with the data as indicated above. Save your scripts as step12.sql and step12a.sql

Documentation & Requirements: 1. 5 pts. Write the file name, your name, email address and purpose of the program at the top of your source code in a
comment.
Example:
///////////////////////////////////////////////////////////////////////////////////////////////////
// Programmer: Thomas Gutierrez
// Email: [email protected]
// Purpose:
// Provides:
//////////////////////////////////////////////////////////////////////////////////////////////////
2. 5 pts. Add comments as appropriate throughout the program.
Program: 85pts.
This program will continue to build upon the Stocks Business Application program and transform it into a “Stocks” class. The
Assignment 5 solutions are recommended to be used as a starting point for this program. If the Assignment 5 solutions are not
used, refer to the Assignment 4 and 5 prompts for details.
The program must have the following requirements:
1. Create a Java Class named “Stock”.

2. The class should have at a minimum three private class variables:
o A variable for the stock name
o An array for the stock’s opening prices
o An array for the stock’s closing prices

3. This class should have two constructors:
o A “no argument” constructor.
o The parameterized constructor should take a parameter for the stock’s “name”.

4. Create the following set methods:
o setStockName: This method will initialize the stock’s name using the provided parameter               MGMT330 – Assigment 6, 2

o setOpenPrices: This method will initialize the stock’s opening prices along with its size based on the provided
parameters – open prices and number of prices.
o setClosePrices: This method will initialize the stock’s closing prices along with its size based on the provided
parameters – close prices and number of prices.

5. Create the following get methods:
o getStockName: This method returns the stock’s name
o getOpenPrices: This method returns the stock’s opening prices
o getClosePrices: This method returns the stock’s closing prices
o getDayPrice: This method returns the price for a specific day for either the opening or closing price of the
stock. Parameters include the day and which price to return, e.g. “O” or “C”

6. Create a method named “percentChange” that computes the percentage change between an opening day price and a
closing day price. This method should have two parameters: 1) the opening day to use; 2) the closing day to use.

7. Create a method named “averageStockPrice” that computes the average of a stocks open or close prices. This method
should take a parameter that determines whether to compute the average for a stock opening or closing prices: “O”
or “C”.

8. Create a method named “displayPrices” that will neatly display a stock’s opening and closing prices for a certain
number of given days. The method should have a parameter for the number of days to display.

9. In the program’s “main” method:
o Create two “Stock” objects named: GME and GOOG
o Initialize each of the stocks opening and closing prices as follows:
 GME:
Opening 96.57 94.05 90.14 116 141
Closing 96.13 89.15 115.17 128.46 137.21

 GOOG:
Opening 2388.59 2455 2287.46 2342.3 2351.56
Closing 2465 2390.12 2300.41 2388.23 2299.33

o Compute the change in price for GME for opening price day 2 and closing price day 4 and print it out neatly
to the user.

o Display all opening and closing prices for GOOG, and display the average of both types of prices.
Extra Credit:
5pts. Build another stock object with 10 open and close prices. Display all information about the stock: percent change
between the first price and final closing price, display all prices, average stock price for both types of prices. The object and its
information should be created and displayed at the end of the main program.               MGMT330 – Assigment 6, 3

Hints:
 All of Chapter 9 is useful for this program but the following sections cover the assignment: 9.2, 9.3, 9.4, 9.7, 9.9, 9.13
 Remember to indent your code properly.
 Scope will remain to be very important for variables when creating classes.

 Use previous assignment solutions for reference.