Информатика и выч. техника \ Организация баз данных и знаний

Разработка базы данных из предметной области "Предприятие", страница 11

insert into params(object_id, attr_id, number_value) values (10,10,222222);

insert into params(object_id, attr_id, number_value) values (20,10,222223);

insert into params(object_id, attr_id, number_value) values (30,10,222224);

insert into params(object_id, attr_id, number_value) values (40,10,222225);

/* Emp-> job_id */

insert into params(object_id, attr_id, number_value) values(1001,11,20001);

insert into params(object_id, attr_id, number_value) values(1002,11,20001);

insert into params(object_id, attr_id, number_value) values(1003,11,20001);

insert into params(object_id, attr_id, number_value) values(1004,11,20002);

insert into params(object_id, attr_id, number_value) values(1005,11,20002);

insert into params(object_id, attr_id, number_value) values(1006,11,20003);

insert into params(object_id, attr_id, number_value) values(1007,11,20003);

insert into params(object_id, attr_id, number_value) values(1008,11,20003);

insert into params(object_id, attr_id, number_value) values(1009,11,20004);

insert into params(object_id, attr_id, number_value) values(1010,11,20005);

insert into params(object_id, attr_id, number_value) values(1011,11,20005);

insert into params(object_id, attr_id, number_value) values(1012,11,20006);

insert into params(object_id, attr_id, number_value) values(1013,11,20007);

insert into params(object_id, attr_id, number_value) values(1014,11,20008);

insert into params(object_id, attr_id, number_value) values(1015,11,20008);

/* Emp-> dep */

insert into params(object_id, attr_id, number_value) values(1001,12,10);

insert into params(object_id, attr_id, number_value) values(1002,12,10);

insert into params(object_id, attr_id, number_value) values(1003,12,10);

insert into params(object_id, attr_id, number_value) values(1004,12,10);

insert into params(object_id, attr_id, number_value) values(1005,12,20);

insert into params(object_id, attr_id, number_value) values(1006,12,30);

insert into params(object_id, attr_id, number_value) values(1007,12,20);

insert into params(object_id, attr_id, number_value) values(1008,12,30);

insert into params(object_id, attr_id, number_value) values(1009,12,30);

insert into params(object_id, attr_id, number_value) values(1010,12,10);

insert into params(object_id, attr_id, number_value) values(1011,12,20);

insert into params(object_id, attr_id, number_value) values(1012,12,20);

insert into params(object_id, attr_id, number_value) values(1013,12,20);

insert into params(object_id, attr_id, number_value) values(1014,12,40);

insert into params(object_id, attr_id, number_value) values(1015,12,40);

commit;

7.5 Результаты заполнения таблиц

Таблица OBJECT_TYPE

OBJECT_TYPE_ID

NAME

DESCRIPTION

1

emp

Employee

2

job

Job

3

dept

Department

Таблица OBJECTS

OBJECT_ID

OBJECT_TYPE_ID

NAME

1012

1

Irene Mikkil

1001

1

Genry Kurtis

1002

1

Alan Smith

1003

1

Bob Marly

1004

1

Jack Carter

1005

1

Tony Stark

1006

1

Jeff Blue

1007

1

Piter Griffin

1008

1

Gregory Simpson

1009

1

Shanta Vollman

1010

1

Kevin Mourgos

1011

1

Julia Nayer

1013

1

James Landry

1014

1

Steven Markle

1015

1

Laura Bissot

20001

2

Administration Assistant

20002

2

Finance Manager

20003

2

Accountant

20004

2

Accounting Manager

20005

2

Public Accountant

20006

2

Sales Manager

20007

2

Sales Representative

20008

2

Purchasing Manager

20009

2

Purchasing Clerk

20010

2

Stock Manager

20011

2

Stock Clerk

20012

2

Shipping Clerk

20013

2

Programmer

20014

2

Marketing Manager

20015

2

Marketing Representative

20016

2

Human Resources Representative

20017

2

Public Relations Representative

10

3

Marketing

20

3

Purchasing

30

3

Human Resources

40

3

Shipping
Скачать файл