Write an application to accomplish the tasks defined in the sections above.

Scenario:
You just landed a job as a junior Java developer and your project manager asks you to write an application to help customer service associates at a local marketplace accomplish their daily tasks. The local marketplace’s merchants sell their products to registered customers only. The project manager informs you that the application is broken into four major functional sections; Inventory, Customer, Purchases and Reports. All four sections are driven by a backbone database and perform similar tasks. He also explains that your application has to be a Java Swing Graphical User Interface application and to make things easier, he would like the application to be multiple-document interface oriented, if at all possible.
Descriptions:
Inventory: The inventory section will be used by the merchant to perform inventory tasks that will be reflected to the database. This section will have four submenus out of which, one will have two submenus.
Inventory
New
Change
Delete
Export
Tab Separated
XML Format
Customer: The customer section will be used by customer service associates to perform tasks on customers that are allowed to make purchases at the market place. This section will have four submenus out of which, one will have two submenus.
Customer
New
Change
Delete
Export
Tab Separated
XML Format

Purchases: The purchases section will be used by the merchant as a POS application at the marketplace. This section will have a single submenu which will allow the user start the POS application. The POS application will be the one portion of the program most frequently used. Once started, it should allow the merchant to Add/Delete a new purchase to the database. It should also allow the merchant to cancel a purchase before it is saved to the database; in other words, clear the information already entered.
Purchases
POS

Reports: The reports sections will be used to generate properly formatted reports regarding the purchases, inventory and customers’ information. The generated reports will be saved to a file to be printed or read by a text editor program like Notepad, Word, etc.
Reports
Customer
Summarized
Detailed
Inventory
Summarized
Detailed
Purchases
Detailed
Summarized

Assignment:
Write an application to accomplish the tasks defined in the sections above. Your instructor will give you further instructions regarding the database tables’ structure. If you are unsure on how to connect to a database using JDBC, read Chapter 24 (Accessing Databases with JDBC) in your textbook. Also, if you choose to create this application as a multiple-document interface application (MDI), refer to Chapter 22 section 7 (22.7) of the textbook.
In addition to your menus, you should have a Help -> About menu at the end of your menus which will display a dialog box with information regarding the program. I suggest you use the three lines at the heading of this document and add your Last Name, First Name and an Ok button to the dialog which will close it when clicked on.

Database tables:

CONNECT ‘jdbc:derby:SAMPLE;create=true’;
CREATE TABLE SAMPLE.MEMBERS (Id VARCHAR(10) NOT NULL, firstName VARCHAR(50), lastName VARCHAR(50), address VARCHAR(150), city VARCHAR(50), state CHAR(2), zipCode CHAR(5), dob DATE, annualFee DECIMAL(5,2), PRIMARY KEY(Id));
CREATE TABLE SAMPLE.STORE (Id INT NOT NULL, PRIMARY KEY(Id));
CREATE TABLE SAMPLE.PARTS (Number CHAR(10) NOT NULL, Name VARCHAR(500), Price DECIMAL(9,2) CONSTRAINT Price_ck CHECK(Price > 0), onHand INT CONSTRAINT onHand_ck CHECK(onHand > 0), Image blob(2M), PRIMARY KEY(Number));
CREATE TABLE SAMPLE.SALES (Id INT NOT NULL GENERATED ALWAYS AS IDENTITY, StoreId INT NOT NULL, MemberId VARCHAR(10), PartNumber CHAR(10), Purchase_Date DATE, Quantity int, Price_Paid DECIMAL(9,2), CONSTRAINT Quantity_ck CHECK(Quantity > 0), CONSTRAINT PricePaid_ck CHECK(Price_Paid > 0), FOREIGN KEY (MemberId) REFERENCES Sample.Members(Id), FOREIGN KEY (PartNumber) REFERENCES Sample.Parts(Number), FOREIGN KEY(StoreId) REFERENCES Sample.Store(Id), PRIMARY KEY(Id));

Database Data:

INSERT INTO Sample.Members (Id, firstName, lastName, address, city, state, zipCode, dob, annualFee) VALUES (‘426873′,’Joseph’,’Garrison’,’94 Barbara Dr’,’Syosset’,’NY’,’11791′,’12/12/1990′,35.00),(‘318765′,’Jessica’,’Bracco’,’125 Beverly Ave’,’Copiague’,’NY’,’11726′,’6/15/1986′,35.00),(‘143578′,’Rosario’,’Lugo’,’254 Brook Path’,’North Bellmore’,’NY’,’11710′,’8/21/1979′,35.00),(‘478035′,’Nicholas’,’Mc Kenna’,’87 Magenta Ln’,’Brewster’,’NY’,’10509′,’2/5/1981′,35.00),(‘963105′,’Daniel’,’Locasto’,’92 Lincoln Ave’,’Franklin Square’,’NY’,’11010′,’3/14/1950′,0.00),(‘852645′,’Austin’,’Lambert’,’1287 Oak St’,’Levittown’,’NY’,’11756′,’11/25/1988′,35.00),(‘437915′,’Jason’,’Stern’,’1478 E 87th St’,’Brooklyn’,’NY’,’11236′,’12/3/1980′,35.00),(‘701237′,’Megan’,’Pidgeon’,’96 Brookwood Dr’,’Kings Park’,’NY’,’11754′,’4/9/1949′,0.00);
INSERT INTO Sample.Store (Id) VALUES(11653471),(14367598),(22458790),(24563798),(33798105),(43520179),(74025469),(75946345),(78103204),(87932154);
INSERT INTO Sample.Parts (Number,Name,Price,onHand,Image) VALUES (‘169139′,’Generac XG8000E Portable Generator | 10,000 Surge Watts, 8000 Rated Watts, Electric Start, Model# 5747’,1369.99,11, DEFAULT),(‘47674′,’Honda EU7000 Portable Generator | 7000 Surge Watts, 5500 Rated Watts, Electric Start, CARB-Compliant, Model# EU7000’,3999.99,5, DEFAULT),(‘1572041’,’NorthStar Gas Cold Water Pressure Washer | 4000 PSI, 3.5 GPM, Honda Engine, Belt Drive, Model# 1572041′,1699.99,7, DEFAULT),(‘8655′,’Gravel Gear Utility Work Gloves’,16.99,51, DEFAULT),(‘590122′,’Radians Class 2 Surveyor Safety Vest’,19.99,120, DEFAULT),(‘2177′,’Ergodyne GloWear Fire-Resistant Modacrylic Safety Vest | Class 2, Lime’,82.99,27, DEFAULT),(‘399682′,’DEWALT Heavy-Duty Double-Bevel Sliding Compound Miter Saw | 10in., Model# DW717’,499,15, DEFAULT),(‘46463’,’Ironton 10in. Compound Sliding Miter Saw | 2.4 HP, 15 Amp, 4,600 RPM’,149.99,30, DEFAULT),(‘22453′,’Milwaukee Abrasive Chop Saw | 14in., Model# 6177-20’,159.99,14, DEFAULT),(‘44765′,’Kenwood ProTalk UHF Handheld Radio | Model# TK3402U16P’,289.99,6, DEFAULT),(‘42865′,’Pair of Black 50-Mile Submersible 2-Way Radios | Model# GMR5089-2CKS’,99.99,8, DEFAULT),(‘42436′,’Troy-Bilt Walk-Behind Jet Sweeper | 205cc Briggs & Stratton Engine, 1000 CFM, Model# 24A-672J766’,399.99,6, DEFAULT),(‘31801’,’Ohio Steel Lawn Sweeper | 42in.W, 22 Cu. Ft., Model# 42SWP22′,259.99,7, DEFAULT),(‘32001′,’Ironton Poly Sprayer | 2-Gallon, 45 PSI, Model# 32001’,16.99,25, DEFAULT),(‘46530′,’Strongway Dump Cart | 1,200-Lb. Capacity, 5 Cu. Ft.’,159.99,9, DEFAULT),(‘46438’,’Strongway Jumbo Wagon | 48in.L x 24in.W, 1,400-Lb. Capacity’,99.99,3, DEFAULT),(‘14264′,’Lawn-Revitalizing Aerator Shoes’,9.99,47, DEFAULT),(‘44039′,’LaCrosse Wireless Weather Station | Get a Full Color Forecast, Model# 308-146’,59.99,39, DEFAULT),(‘168101′,’Electrostatic Cling Outdoor Window Thermometer’,5.99,73, DEFAULT),(‘27442’,’Landmann Haywood Wildlife Fireplace | Black, 33in.H, Model# 25319′,89.99,17, DEFAULT),(‘121102’,’Sundanzer Solar-Powered Chest Freezer | 8 Cubic Ft., 30in.L x 50in.W x 37in.H‘,1299,2, DEFAULT),(‘40091′,’Sunforce Wind Turbine | 1500 Watts’,3799.99,2, DEFAULT),(‘47472′,’Coleman 400 Watt Wind Turbine with Tower Kit | 27 Amps, Model# 48640’,899.99,8, DEFAULT),(‘121072′,’Sunforce Tower Kit for Small WInd Turbines | Model# 45455’,449.99,8, DEFAULT),(‘48923′,’Troy-Bilt Vortex 3-Stage 28in. Electric Start Snow Blower | 357cc Engine, Model# 31AH55Q8766’,1299.99,20, DEFAULT);

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: