I have to create a simple bank database using MySQL, so i have to create tables and relationships between them (normalization).
I have created those tables :
Branch (BranchID, BranchPlace)
Account (AccountID, AccountNumber, AccountType, Balance)
Client (ClientID, ClientName, ClientSurname, ClientCity)
Transaction (TransactionID, TransactionType, Amount)
So i need defining primary keys and foreign keys, can anyone help me with this ?