2023 Here is your assignment You work for a flooring company They have asked you | Assignment Collections

 Here is your assignment: You work for a flooring company. They have  asked you to be a part of their team because they need a computer  programmer, analyst, and designer to aid them in tracking customer  orders. Your skills will be needed in creating a GUI program that  calculates the flooring cost and stores the order in the database. 

Your application must include at least three tabs. The user will  choose wood flooring or carpet, enter the length and width of the floor,  as well as the customer name and address. The application will compute  the area of the floor and the cost of the flooring considering that wood  floor is $20 per square foot and carpet is $10 per square foot. A  summary should be displayed, either in a tab or another window, listing  the customer name and address, floor selection, area, and cost. This  information should also be stored in the MySQL  database table. The program should validate that all information is  entered and that the length and width are numeric values. Any numeric or  currency values must be formatted appropriately when output.  Recommendations for the components used for input are

• radio buttons—flooring type (wood or carpet);
   
• text fields—customer name, customer address, floor length, and floor width; and
   
• buttons—calculate area, calculate cost, submit order, display order summary, display order list.

The MySQL database table is called flooring and has the following description.

  Field Type    CustomerName
  varchar(30)   CustomerAddress  varchar(50)    FlooringType
  varchar(10)
    FloorArea
 double
    FloorCost
 double
   

In addition to entering new customer orders, your application should  list all customer orders stored in the database. These will be viewed as  a list, in a text area, and will not be updated by the user.  

In Week 7, you will be required to submit a user manual, as well as  your Java code. The user manual can be a simple Word document with  screen shots that explains how to run your application. Your mark will  depend both on the program quality and the quality of the user manual.

Here are some more detailed guidelines about the user manual.

• It does not need to be long, probably not more than five pages, including screen shots.
• Write at the expected user’s level, not too technical.
• Detail all the functionality that the application provides.
• For each function, show what its purpose is and sample execution, with a screen shot.

The following grading rubric will be used for the code portion of the project. 

 Flooring Application Points Description    Standard Header 

2

Must contain program name, student name, and description of the program   Program Compiler 

2

Program does not have any error   Program Execution 

2

Program runs without any error   Number of Tabs
 

10

Three or more tabs are used.   Components for All Required Inputs 

35

Components for customer name, address, floor type, length, width,  area, and cost with buttons to calculate area, calculate cost, display  order summary, and display order list are included.   Area Calculation 

4

Area is calculated correctly.   Cost Calculation 

5

Cost is calculated correctly.   Data Validation 

10

If no values or non-numeric values are entered, the proper error message should display.   Data within Database Table 

10

When values are entered, the data is stored correctly in the database table.   Customer Orders 

10

All records saved to the database are displayed in a list with appropriate formatting.   Correct Output 

10

When values are entered, the order summary is shown with appropriate formatting.   Total 

100

 Meets or exceeds expectations