Jadval nomi ma’nosi



Download 1,81 Mb.
Sana11.03.2021
Hajmi1,81 Mb.
#61452
Bog'liq
bank kreditnew


JADVAL NOMI

MA’NOSI

ACCOUNT

Bank hisobvarag'ini saqlaydigan jadval. Har bir mijoz bir nechta hisoblarni ro'yxatdan o'tkazishi mumkin, har bir hisob raqami bank xizmatiga mos keladi



ACC_TRANSACTION

Muayyan hisob raqamidagi bankda tranzaktsiyalar to'g'risidagi ma'lumotlarni saqlaydigan jadval.

BRANCH

Bank filiali

BUSSINESS

 

CUSTOMER

Klient jadvali

DEPARTMENT

Bank departamentlar jadvali

EMPLOYEE

Bank ishchilari

OFFICER

 

PRODUCT

Bank xizmatlari mahsulotlari:

  • Depozit quyish

  • Kredit berish

  • Kichik biznes uchun kredit

  • .....

PRODUCT_TYPE

Bank xizmatlari mahsulotlari :

  • Mijoz hisobi

  • Shaxsiy va biznes uchun kredit

  • Sugurta bilan taminlash






So’rov






So’rov





create table ACCOUNT (

ACCOUNT_ID int identity not null,

AVAIL_BALANCE float,

CLOSE_DATE datetime,

LAST_ACTIVITY_DATE datetime,

OPEN_DATE datetime not null,

PENDING_BALANCE float,

STATUS varchar(10),

CUST_ID int,

OPEN_BRANCH_ID int not null,

OPEN_EMP_ID int not null,

PRODUCT_CD varchar(10) not null,

primary key (ACCOUNT_ID)

);
create table ACC_TRANSACTION (

TXN_ID numeric(19,0) identity not null,

AMOUNT float not null,

FUNDS_AVAIL_DATE datetime not null,

TXN_DATE datetime not null,

TXN_TYPE_CD varchar(10),

ACCOUNT_ID int,

EXECUTION_BRANCH_ID int,

TELLER_EMP_ID int,

primary key (TXN_ID)

);
create table BRANCH (

BRANCH_ID int identity not null,

ADDRESS varchar(30),

CITY varchar(20),

NAME varchar(20) not null,

STATE varchar(10),

ZIP_CODE varchar(12),

primary key (BRANCH_ID)

);
create table BUSINESS (

INCORP_DATE datetime,

NAME varchar(255) not null,

STATE_ID varchar(10) not null,

CUST_ID int not null,

primary key (CUST_ID)

);
create table CUSTOMER (

CUST_ID int identity not null,

ADDRESS varchar(30),

CITY varchar(20),

CUST_TYPE_CD varchar(1) not null,

FED_ID varchar(12) not null,

POSTAL_CODE varchar(10),

STATE varchar(20),

primary key (CUST_ID)

);
create table DEPARTMENT (

DEPT_ID int identity not null,

NAME varchar(20) not null,

primary key (DEPT_ID)

);
create table EMPLOYEE (

EMP_ID int identity not null,

END_DATE datetime,

FIRST_NAME varchar(20) not null,

LAST_NAME varchar(20) not null,

START_DATE datetime not null,

TITLE varchar(20),

ASSIGNED_BRANCH_ID int,

DEPT_ID int,

SUPERIOR_EMP_ID int,

primary key (EMP_ID)

);
create table INDIVIDUAL (

BIRTH_DATE datetime,

FIRST_NAME varchar(30) not null,

LAST_NAME varchar(30) not null,

CUST_ID int not null,

primary key (CUST_ID)

);
create table OFFICER (

OFFICER_ID int identity not null,

END_DATE datetime,

FIRST_NAME varchar(30) not null,

LAST_NAME varchar(30) not null,

START_DATE datetime not null,

TITLE varchar(20),

CUST_ID int,

primary key (OFFICER_ID)

);
create table PRODUCT (

PRODUCT_CD varchar(10) not null,

DATE_OFFERED datetime,

DATE_RETIRED datetime,

NAME varchar(50) not null,

PRODUCT_TYPE_CD varchar(255),

primary key (PRODUCT_CD)

);
create table PRODUCT_TYPE (

PRODUCT_TYPE_CD varchar(255) not null,

NAME varchar(50),

primary key (PRODUCT_TYPE_CD)

);
alter table ACCOUNT

add constraint ACCOUNT_CUSTOMER_FK

foreign key (CUST_ID)

references CUSTOMER;


alter table ACCOUNT

add constraint ACCOUNT_BRANCH_FK

foreign key (OPEN_BRANCH_ID)

references BRANCH;


alter table ACCOUNT

add constraint ACCOUNT_EMPLOYEE_FK

foreign key (OPEN_EMP_ID)

references EMPLOYEE;


alter table ACCOUNT

add constraint ACCOUNT_PRODUCT_FK

foreign key (PRODUCT_CD)

references PRODUCT;


alter table ACC_TRANSACTION

add constraint ACC_TRANSACTION_ACCOUNT_FK

foreign key (ACCOUNT_ID)

references ACCOUNT;


alter table ACC_TRANSACTION

add constraint ACC_TRANSACTION_BRANCH_FK

foreign key (EXECUTION_BRANCH_ID)

references BRANCH;


alter table ACC_TRANSACTION

add constraint ACC_TRANSACTION_EMPLOYEE_FK

foreign key (TELLER_EMP_ID)

references EMPLOYEE;


alter table BUSINESS

add constraint BUSINESS_EMPLOYEE_FK

foreign key (CUST_ID)

references CUSTOMER;


alter table EMPLOYEE

add constraint EMPLOYEE_BRANCH_FK

foreign key (ASSIGNED_BRANCH_ID)

references BRANCH;


alter table EMPLOYEE

add constraint EMPLOYEE_DEPARTMENT_FK

foreign key (DEPT_ID)

references DEPARTMENT;


alter table EMPLOYEE

add constraint EMPLOYEE_EMPLOYEE_FK

foreign key (SUPERIOR_EMP_ID)

references EMPLOYEE;


alter table INDIVIDUAL

add constraint INDIVIDUAL_CUSTOMER_FK

foreign key (CUST_ID)

references CUSTOMER;


alter table OFFICER

add constraint OFFICER_CUSTOMER_FK

foreign key (CUST_ID)

references CUSTOMER;


alter table PRODUCT

add constraint PRODUCT_PRODUCT_TYPE_FK



foreign key (PRODUCT_TYPE_CD)

references PRODUCT_TYPE;
Download 1,81 Mb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish