Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

java Your application must include at least three tabs . The user will choose wood flooring or carpet, enter the length and width of the

java

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 buttonsflooring type (wood or carpet);

text fieldscustomer name, customer address, floor length, and floor width; and

buttonscalculate 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.

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

25

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

90

Meets or exceeds expectations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Make A Database In Historical Studies

Authors: Tiago Luis Gil

1st Edition

3030782409, 978-3030782405

More Books

Students also viewed these Databases questions

Question

What must a creditor do to become a secured party?

Answered: 1 week ago

Question

When should the last word in a title be capitalized?

Answered: 1 week ago

Question

Question Can a Roth IRA invest in stock of the IRA owners business?

Answered: 1 week ago