Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a simple Java GUI application following this case: WATCHERS is a shop that sells various brands of watches. Store owners want to have a

Make a simple Java GUI application following this case:

WATCHERS is a shop that sells various brands of watches. Store owners want to have a simple GUI application to be able to perform watch inventory administration. Therefore, you are asked to create a simple GUI application with the implementation of the OOP concept. This watch has several categories, such as: Regular Watches, Sports Watches, and Smart Watches. The following list are the field criteria used for each watch. a. Regular Watches - Brand name - Watch material - The length of the watch b. Sports Watches - Has all the features of a Regular Watch - Hold water depth (size in m) - Have an LED light (Yes / No) c. Smart Watches - Has all the features of a Regular Watch - Has wifi (Yes / No) - Has internal storage (size in GB)

You are asked to follow these conditions for the GUI application as follows: a. The database schema can be seen in the watch.sql below.

b. There is a table display that shows: No, Brand Name, Type of Watch, Material of the Watch, Length of the Watch, Depth of Water Resistance, LED, Wifi, Internal Storage.

c. There is a form that can insert watch data where there are Save and Reset buttons.

d. There is a delete button that can be used to delete the data by selecting a row in the table

e. The form components are: 1. Type of Watch (ComboBox) 2. Brand Name (TextBox) 3. Watch Material (TextBox) 4. The length of the watch (TextBox) - units of mm 5. Have LED Lights (RadioButton) 6. Hold water depth (Spinner) - M units 7. Have Wifi (RadioButton) 8. Have Internal Storage (Spinner) - GB units

f. Make validation on form components with the following conditions: 1. For the selected watch type: - for regular watches, the components owned by sport and smart watch in numbers 5-8 are disabled - for sports watches, the components owned by the smart watch (components number 7 and 8) are disabled - for smart watches, the components owned by sport (components number 5 and 6) are disabled 2. The watch code will be generated automatically where (RXXX, SXXX, MXXX). - R for Regular - S for Sport - M for Smart Watch - XXX for running number codes, for example 001, 002, 003, etc. 3. Validate all active fields that must be filled in. 4. Display an error message if the validation is still missing. 5. Display a success message if the Save or Delete process is successful.

sample data and structure from the watch.sql :

image text in transcribed

Database (watch.sql) :

-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 17, 2021 at 05:18 PM -- Server version: 10.4.13-MariaDB -- PHP Version: 7.2.32 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `watch` -- CREATE TABLE `watch` ( `KodeJam` varchar(4) NOT NULL, `NamaMerk` varchar(200) NOT NULL, `BahanJam` varchar(200) NOT NULL, `PanjangJam` float NOT NULL, `LampuLED` tinyint(1) DEFAULT NULL, `KedalamanAir` int(11) DEFAULT NULL, `Wifi` tinyint(1) DEFAULT NULL, `InternalStorage` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `watch` -- INSERT INTO `watch` (`KodeJam`, `NamaMerk`, `BahanJam`, `PanjangJam`, `LampuLED`, `KedalamanAir`, `Wifi`, `InternalStorage`) VALUES ('R001', 'CASIO XYZ', '80% Karet dan 20% Stainless Steel', 150, NULL, NULL, NULL, NULL), ('S002', 'G-Shock Sport XYZ', '100% Stainless Steel', 180, 1, 10, NULL, NULL), ('W001', 'Samsung Smartwatch XYZ', '70% Ceramic & 30% Stainless Steel', 178, NULL, NULL, 1, 4); -- -- Indexes for dumped tables -- -- -- Indexes for table `watch` -- ALTER TABLE `watch` ADD PRIMARY KEY (`KodeJam`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */

Please help me making a simple java GUI application following all the condition above from point a to f.

Thank you

Wifi InternalStorage NULL NULL KodeJam NamaMerk Bahan Jam PanjangJam LampuLED KedalamanAir 80% karet dan 20% R001 CASIO XYZ 150 NULL NULL Stainless Steel G-Shock Sport 100% Stainless S002 180 1 10 XYZ Steel Samsung 70% Ceramic & W001 Smartwatch 178 NULL NULL 30% Stainless Steel XYZ NULL NULL 1 4 Wifi InternalStorage NULL NULL KodeJam NamaMerk Bahan Jam PanjangJam LampuLED KedalamanAir 80% karet dan 20% R001 CASIO XYZ 150 NULL NULL Stainless Steel G-Shock Sport 100% Stainless S002 180 1 10 XYZ Steel Samsung 70% Ceramic & W001 Smartwatch 178 NULL NULL 30% Stainless Steel XYZ NULL NULL 1 4

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

Step: 3

blur-text-image

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

Probabilistic Databases

Authors: Dan Suciu, Dan Olteanu, Christopher Re, Christoph Koch

1st Edition

3031007514, 978-3031007514

More Books

Students also viewed these Databases questions

Question

List five risks associated with IT outsourcing.

Answered: 1 week ago

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago