Logical Database
Need help making a
Logical Database Design
-Bank(Bank_Code, Name, Address)
Primary Keys(Bank_Code)
Foreign Keys(Name, Address)
-Bank Rewards(Time_With_Bank, Points Earned)
Foreign Keys(Time_With_Bank, Points Earned)
-Bank_Branch(Address, Branch_No)
Foreign Keys(Address, Branch_No)
-Loan(Loan_No, Type, Amount)
Primary Keys(Loan_No)
Foreign Keys(Type, Amount)
-Account(Account_No, Type)
Primary Keys(Account_No)
Foreign Keys(Type)
-Checkings(Account_No, Last_4_Of_SSN, Name)
Primary Keys(Account_No)
Foreign Keys(Last_4_Of_SSN, Name)
-Savings(Account_No, Last_4_Of_SSN, Name)
Primary Keys(Account_No)
Foreign Keys(Last_4_Of_SSN, Name)
-Costumer(SSN, Name, Phone_Number, Address)
Primary Keys(SSN)
Foreign Keys(Name, Phone_Number, Address)
Relationships
-Branch- bank:bank_branch, 1:N
-Accounts- bank_branch:account, 1:N
-Loans- bank_branch:loan, 1:N
-Own- account: customer, N: M
-Barrow- loan:customer, N:M
Step by step
Solved in 2 steps with 3 images
