Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve this following Case: WATCHERS is a shop that sells various brands of watches. Store owners want to have a simple GUI application to be

Solve this following 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 picture below

image text in transcribed

image text in transcribed 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.

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=26CHARACTER_SET_RESULTS */; /*!40101 SET GOLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; Database: "test Table structure for table "watch CREATE TABLE 'watch ( WatchCode varchar(4) NOT NULL, BrandName varchar(200) NOT NULL, WatchMaterial' varchar(200) NOT NULL, WatchLength float NOT NULL, LEDLight tinyint(1) DEFAULT NULL, WaterDepth int(11) DEFAULT NULL, "Wifi tinyint(1) DEFAULT NULL, InternalStorage int(11) DEFAULT NULL ENGINE=InnoDB DEFAULT CHARSET=latini; Dumping data for table 'watch INSERT INTO 'watch (WatchCode, "BrandName, WatchMaterial, Watchlength, LEDLight, 'WaterDepth, Wifi, InternalStorage) VALUES "R001', 'CASIO XYZ', '80% karet dan 20% Stainless Steel', 150, NULL, NULL, NULL, NULL), ('5002', '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 */; 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=26CHARACTER_SET_RESULTS */; /*!40101 SET GOLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; Database: "test Table structure for table "watch CREATE TABLE 'watch ( WatchCode varchar(4) NOT NULL, BrandName varchar(200) NOT NULL, WatchMaterial' varchar(200) NOT NULL, WatchLength float NOT NULL, LEDLight tinyint(1) DEFAULT NULL, WaterDepth int(11) DEFAULT NULL, "Wifi tinyint(1) DEFAULT NULL, InternalStorage int(11) DEFAULT NULL ENGINE=InnoDB DEFAULT CHARSET=latini; Dumping data for table 'watch INSERT INTO 'watch (WatchCode, "BrandName, WatchMaterial, Watchlength, LEDLight, 'WaterDepth, Wifi, InternalStorage) VALUES "R001', 'CASIO XYZ', '80% karet dan 20% Stainless Steel', 150, NULL, NULL, NULL, NULL), ('5002', '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 */

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

Oracle Solaris 11.2 System Administration (oracle Press)

Authors: Harry Foxwell

1st Edition

007184421X, 9780071844215

More Books

Students also viewed these Databases questions

Question

1. Adapt the three-step writing process to reports and proposals.

Answered: 1 week ago