(Solved) : Big Bank Banking Organisation Database Described Customer Id Firstname Lastname Address Em Q26174860 . . . .

The “Big Bank” banking organisation has a database as describedbelow:

Customer(ID, firstName, lastName, address, email, phone,dateOfBirth) Account(accNumber, balance, type)

Branch(BSB, phone, streetAddress, town)

Employee(employeeID, firstName, lastName, address, phone, TFN,dateOfBirth) has(ID*, accNumber*)

registered(accNumber*, BSB*) worksAt(employeeID*, BSB*,occupation)

•   Primary keys are underlined and foreign keys aredenoted with asterisks (*).

•   A customer can have more than one account and anaccount can be jointly owned by more than one customer.

•   An employee can only work