explained in file
Microsoft Word - ITAP3006_Programming_Assignment.docx Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 1 Banking System In this assignment you are going to develop a stand alone Java application with a GUI using NetBeans RCP components to manage a Banking System. Using this System you will be able to perform basic CURD (Create, update, read and delete) functions related to banks, branches, customers and accounts information. Using this system you must be able to 1. Insert information about a bank, branch, customer and account. 2. Delete information about a bank, branch, customer and account. 3. Update information about a bank, branch, customer and account. 4. View information about a bank, branch, customer and account. 5. Transfer money between two accounts. Database Model You will be using the following database model to store the information needed. Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 2 Software You must user software mentioned below. GUI • You must use JDK 1.8 and Netbeans 8.2 editor to develop the GUI. You must use NetBeans RCP to come up with the expected output. Database • You must use MySQL 5.7 to implement the database and MySQL Connector Java 5.1 or above as the database driver. Note: • You can find all the required software installations freely at following locations. o Netbeans : https://netbeans.org/downloads/ o MySQL : https://dev.mysql.com/downloads/mysql/ • Further the Lecturer can share the installations in a Google dive or in One drive upon your request. Or you can get a copy during onsultation hours. Deliverables Source Code • Your must submit the NetBeans project folder with all the source codes (.java) and any other necessary file. • Compress the whole application into a single ZIP file when you submit. • Your ZIP file should include a readme.txt file, which include your information. • Follow the links in Moodle to upload your answer on or before the deadline. Deadline You must submit your answer on or before 12.00 P.M. on 21st October 2018. Demonstration You must demonstrate your answer at 9.30 A.M. 25th Thursday October 2018. Location : Lecture Hall 9-5, 235, Queen Street, VIT Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 3 Evaluation • THIS ASIGNMENT IS COMPULSORY. • THE ASIGNMENT WILL BE ALLOCATED 25% OF THE MARKS FROM YOUR OVERALL RESULTS • STUDENTS ARE REQUIRED TO ACHIEVE AT LEAST 40% FRO THIS ASSIGNMENT TO PASS THE UNIT. • STUDENTS ARE REQUIRED TO ACHIEVE AT LEAST 40% IN EACH SUMMATIVE AND FORMATIVE ASSESSMENTS AND AN OVERALL MARK OF 50% TO ACHIEVE A PASS GRADE IN THE UNIT. Key Points to Note • The assignment is an individual assignment. • But you are free to discuss with other students. • Your program must adhere to all the standard object oriented program design and implementation guidelines including modularity, reusability, extensibility, maintainability and adaptability. • Your program must adhere to all the standard Java programming style guidelines including code readability, logical clarity, scoping rules, proper use of class and instance variables, encapsulation, naming conventions for classes, methods and variables and concept of variable-free programming. References Installing and Creating Database • Refer MySQL documentation. https://dev.mysql.com/doc/ GUI • Refer Lab 06. Microsoft Word - ITAP3006_Database_Design.docx Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment -Database Design Process ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 1 This document is an additional resource, which will help the students to understand the process of developing the database to be developed. Database ER-Model You will be using the following database model to store the information needed. Map ER-Model to Relational Model Step 1 : Map Regular Entities bank code name address account acc_no balance int_rate type customer ssn name address phone Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment -Database Design Process ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 2 Step 2 : Map Weak Entities bank code name address bank_branch code branch_no address grade account acc_no balance int_rate type customer ssn name address phone Step 3 : Map Binary Relationships (1:1 & 1:M) bank code name address bank_branch code branch_no address grade account acc_no balance int_rate type b_code branch_no cus_ssn customer ssn name address phone Victorian Institute of Technology ITAP3006 – Advanced Java Programming Year 3 – Semester 2, 2018 Programming Assignment -Database Design Process ITAP3006 Copyrights © 2018 VIT, All Rights Reserved 3 Step 4 : Map Other Binary Relationships (M:N) No M:N relationships Step 5 : Map Multivalued attributes No multivalued attributes Step 6 : Map N’ry Relationships No N’ry relationships Step 7 : Final Set of Relations bank code name address bank_branch code branch_no address grade account acc_no balance int_rate type b_code branch_no cus_ssn customer ssn name address phone INSERT INTO `itap3006_bank`.`bank` (`code`, `name`, `address`) VALUES ('001', 'Commonwealth', 'Melbourne'); INSERT INTO `itap3006_bank`.`bank` (`code`, `name`, `address`) VALUES ('002', 'NAB', 'Melbourne'); INSERT INTO `itap3006_bank`.`bank` (`code`, `name`, `address`) VALUES ('003', 'Westpack', 'Melbourne'); INSERT INTO `itap3006_bank`.`bank_branch` (`code`, `branch_no`, `address`, `grade`) VALUES ('001', '101', 'Dandenong', '2'); INSERT INTO `itap3006_bank`.`bank_branch` (`code`, `branch_no`, `address`, `grade`) VALUES ('001', '102', 'Frankston', '2'); INSERT INTO `itap3006_bank`.`bank_branch` (`code`, `branch_no`, `address`, `grade`) VALUES ('002', '201', 'Geelong', '1'); INSERT INTO `itap3006_bank`.`bank_branch` (`code`, `branch_no`, `address`, `grade`) VALUES ('003', '301', 'Chadston', '1'); INSERT INTO `itap3006_bank`.`customer` (`ssn`, `name`, `address`, `phone`) VALUES ('12345', 'Adam', 'Narre Warren', '0458746987'); INSERT INTO `itap3006_bank`.`customer` (`ssn`, `name`, `address`, `phone`) VALUES ('14587', 'Neil', 'Berwick', '0498756324'); INSERT INTO `itap3006_bank`.`customer` (`ssn`, `name`, `address`, `phone`) VALUES ('25487', 'Mark', 'Bayswater', '0465824651'); INSERT INTO `itap3006_bank`.`customer` (`ssn`, `name`, `address`, `phone`) VALUES ('52648', 'Anne', 'Melvern', '0423541265'); INSERT INTO `itap3006_bank`.`account` (`acc_no`, `balance`, `int_rate`, `type`, `b_code`, `branch_no`, `cus_ssn`) VALUES ('123456', '1500.58', '2.32', 'SAV', '001', '101', '12345'); INSERT INTO `itap3006_bank`.`account` (`acc_no`, `balance`, `int_rate`, `type`, `b_code`, `branch_no`, `cus_ssn`) VALUES ('123457', '106874.33', '2.1', 'CUR', '003', '301', '52648'); -- Creating a new database schma called itap3006_bank CREATE SCHEMA `itap3006_bank` ; --Change database use itap3006_bank; -- creating bank table CREATE TABLE `itap3006_bank`.`bank` ( `code` CHAR(10) NOT NULL, `name` VARCHAR(50) NOT NULL, `address` VARCHAR(100) NOT NULL, PRIMARY KEY (`code`) ); -- craeting customer table CREATE TABLE `itap3006_bank`.`customer` ( `ssn` CHAR(10) NOT NULL, `name` VARCHAR(50) NOT NULL, `address` VARCHAR(100) NOT NULL, `phone` CHAR(12) NULL, PRIMARY KEY (`ssn`) ); --Create bank_branch table CREATE TABLE `itap3006_bank`.`bank_branch` ( `code` CHAR(10) NOT NULL, `branch_no` CHAR(10) NOT NULL, `address` VARCHAR(100) NULL, `grade` CHAR(3) NULL, PRIMARY KEY (`code`, `branch_no`), CONSTRAINT `bank` FOREIGN KEY (`code`) REFERENCES `itap3006_bank`.`bank` (`code`) ON DELETE NO ACTION ON UPDATE NO ACTION ); --Create account table Executing: CREATE TABLE `itap3006_bank`.`account` ( `acc_no` CHAR(10) NOT NULL, `balance` FLOAT NOT NULL, `int_rate` DECIMAL(4,2) NULL, `type` CHAR(10) NULL, `b_code` CHAR(10) NULL, `branch_no` CHAR(10) NULL, `cus_ssn` CHAR(10) NULL, PRIMARY KEY (`acc_no`), CONSTRAINT `customer` FOREIGN KEY (`cus_ssn`) REFERENCES `itap3006_bank`.`customer` (`ssn`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `bank_branch` FOREIGN KEY (`b_code`,`branch_no`) REFERENCES `itap3006_bank`.`bank_branch` (`code`, `branch_no`) ON DELETE NO ACTION ON UPDATE NO ACTION );