Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Relational Schema (in a diagrammatic form) CustomerID VARCHAR(10) Custom Name VARCHAR(45) CustomerAddress VARCHAR(45) Custom erContac No INT (11) Custom eEm ail VARCHAR(45) Custom eJoinDate DATETIME
Relational Schema (in a diagrammatic form) CustomerID VARCHAR(10) Custom Name VARCHAR(45) CustomerAddress VARCHAR(45) Custom erContac No INT (11) Custom eEm ail VARCHAR(45) Custom eJoinDate DATETIME T_ACc_Type AccountTypeID VARCHAR(10) TypeName VARCHAR(45) TypeDesc VARCHAR (45) TypeRate DECIMAL(4,2) TypeFee DECIMAL (2,0) T_Own Customer_ID VARCHAR (10) Account BSB VARCHAR(10) Account No VARCHAR(10) T_Loan_Type LoanTypeID VARCHAR(10) Loan-TypeName VARGAR(45) Repa yment Repaymento INT(11) Repayment LoanID VARCHAR (10) RepaymentAm ount DECIMAL (2,0) Loan_TypeDesc VARCHAR(45) RepaymentDate DATETIME Loan TypeMInRate DECIMAL (4,2) oan LoanID VARCHAR(10) LoanRate DECIMAL (4,2) coun BSB VARCHAR (10) AccountNo VARCHAR(10) AccountBal DECIMAL (2,0) Loan Type VARCHAR(10) Loan AccountBSB VARCHAR(10) Loan_AcctNo VARCHAR(10) AccountType VARAR( 10) O IH Relational Schema (in a diagrammatic form) CustomerID VARCHAR(10) Custom Name VARCHAR(45) CustomerAddress VARCHAR(45) Custom erContac No INT (11) Custom eEm ail VARCHAR(45) Custom eJoinDate DATETIME T_ACc_Type AccountTypeID VARCHAR(10) TypeName VARCHAR(45) TypeDesc VARCHAR (45) TypeRate DECIMAL(4,2) TypeFee DECIMAL (2,0) T_Own Customer_ID VARCHAR (10) Account BSB VARCHAR(10) Account No VARCHAR(10) T_Loan_Type LoanTypeID VARCHAR(10) Loan-TypeName VARGAR(45) Repa yment Repaymento INT(11) Repayment LoanID VARCHAR (10) RepaymentAm ount DECIMAL (2,0) Loan_TypeDesc VARCHAR(45) RepaymentDate DATETIME Loan TypeMInRate DECIMAL (4,2) oan LoanID VARCHAR(10) LoanRate DECIMAL (4,2) coun BSB VARCHAR (10) AccountNo VARCHAR(10) AccountBal DECIMAL (2,0) Loan Type VARCHAR(10) Loan AccountBSB VARCHAR(10) Loan_AcctNo VARCHAR(10) AccountType VARAR( 10) O IH
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started