Question 1:

1. Write a Java code to do the following -

=> Ask user if they want to setup a 4 digit PIN for their bank account

=> IF yes then Set a random 4 digit PIN using a method and test if the new pin works

=> Otherwise ask user to enter their old PIN

Use a separate class PIN and declare methods getPin and checkPin in that class for this assignment.

2.Create a default pin = 2021

Check if the user enters either the newly generated pin or the default pin

Show their account balance if either is correct

Implement a counter to count the number of times a user may enter the wrong pin

A user can enter the wrong pin maximum 3 times

Question 2:

Define the following and indicate benefits of each

Normalization

Denormization

Define the conditions for a table to be in

first normal form

second normal form

third normal form

Use figure to answer the following questions

a. Identify the indicated dependencies

Partial

Transitive

b. create a database whose tables are at least 2NF

You can either write the table in text format - TABLENAME (KEY(s) (Attribute, Attribute) or visually

c. Create a database whose tables are least 3NF

FIGURE Q6.6 DEPENDENCY DIAGRAM FOR QUESTION 6