Your first project should demonstrate your knowledge of the following topics: Java SQL JDBC Basic Data Structures Basic File I/O You will be building a console application that persists data in a...

1 answer below »

Your first project should demonstrate your knowledge of the following topics:



  • Java

  • SQL

  • JDBC

  • Basic Data Structures

  • Basic File I/O


You will be building a console application that persists data in a database with at least 3 tables which adhere to 3rd normal form (3NF). The basic form of this project should be that of a console-based banking app.



Minimum Requirements



  1. Basic validation (no negative deposits/withdrawals, malformed emails, names with numbers, etc.)

  2. All exceptions are properly caught and handled

  3. Proper use of OOP principles

  4. Documentation (all classes and methods have basic inline documentation)

  5. Use of custom data structures (do not use java.util Collection types! Implement your own List)

  6. SQL Data Persistance (at least 3 tables; all 3NF (normal form))



Banking App User Stories


These are user stories to describe the banking app. If you are not building the banking app for your project, you will need to discuss with your trainer to establish proper user stories.



Minimum Viable Product



  • As a user, I can register for an account.

  • As a user, I can login to my account.

  • As a user, I can create one or more bank accounts.

  • As a user, I can deposit funds into my account(s).

  • As a user, I can withdraw funds from my account(s).

  • As a user, I can display all of my accounts in a list which includes current balance.

  • All monetary amounts should be displayed in a proper currency format ($1,234.56).



Tech Stack


You should be employing the following technologies in your project.



  • Java 8

  • Apache Maven

  • MariaDB deployed on AWS RDS


Answered 4 days AfterSep 23, 2021

Answer To: Your first project should demonstrate your knowledge of the following topics: Java SQL JDBC Basic...

Swapnil answered on Sep 26 2021
131 Votes
91851/bankdb.sql
CREATE TABLE "APP"."EMPLOYEE"
(
E_ID varchar(255)PRIMARY KEY NOT NULL,
FI
RST_NAME varchar(255),
LAST_NAME varchar(255),
PASSWORD varchar(60) NOT NULL
);
CREATE TABLE "APP"."CUSTOMER"
(
C_ID INTEGER default GENERATED_BY_DEFAULT not null primary key,
DOB varchar(255),
FIRST_NAME varchar(255),
LAST_NAME varchar(255)

);
CREATE TABLE "APP"."SAVINGACCOUNT"
(
CUSTOMERID INT not null,
ACCNUM varchar(255) not null,
BALANCE INT

);
CREATE INDEX ACCNUM on "APP"."SAVINGACCOUNT"(ACCNUM);
ALTER TABLE "SAVINGACCOUNT"ADD FOREIGN KEY (CUSTOMERID)REFERENCES CUSTOMER(C_ID);
91851/src/bankconsole/applicationContext.xml



























...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here