Meat
Comments
Content
create table Customer(
Name varchar(35),
Fname varchar(35),
Cnic varchar(15),
Phone varchar(15),
Address varchar(40),
Dob date,
Customer_id number(5) constraints PK_Customer primary key,
ACCOUNT_Id varchar(8) constraint FK_ACCOUNT references ACCOUNT(account_Id)
);
create table Branch (
Branch_Id varchar(4) constraint PK_Branch primary key,
Name varchar(40),
city varchar(20)
);
create table Account(
Account_Id varchar(8) constraint PK_Account primary key,
Amount number(12),
Account_Type varchar(8),
Branch_Id varchar(4) constraint FK_Branch references Branch(Branch_Id)
);
create table Borrwer(
Customer_id varchar(8) constraint FK_Customer references Customer(Customer_id),
Loan_Number varchar(8) constraint FK_Loan references Loan(Loan_Number))
create table Transaction(
transaction_id varchar(6) primary key not null,
transaction_type varchar(6),
transaction_amount number(15) not null,
Customer_id varchar(8) references customer(customer_id),
fromaccountno varchar(8) references account(account_id),
toaccountno varchar(8) references account(account_id))
create table Loan(
Loan_Number varchar(8) constraint PK_Loan primary key,
Amount number(7),
Branch_Id varchar(4) constraint FK_Branch_Loan references Branch(Branch_Id)
);
create table Employee(
Name varchar(35),
Emp_Id varchar(5) constraint PK_Employee primary key,
Contact varchar(15),
Branch_Id varchar(4) constraint FK_Branch_Employee references Branch(Branch_Id
)
);
create table LOGIN (emp_id varchar(5) constraint FK_employee references employee
(emp_id),password varchar(20))
/
Sponsor Documents