Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29 | Следующая страница реферата

Также рассмотрены вопросы охраны труда и экологической безопасности.

СПИСОК ИСПОЛЬЗОВАННЫХ ИСТОЧНИКОВ

1. Атре Ш., Структурный подход к организации баз данных. – М.: Финансы и статистика, 1983. – 317 с.
2. Бобровски Ст., Oracle7 и вычисления клиент/сервер. – Alameda, CA, USA:

SYBEX Inc., 1996. – 420с.
3. Ричардс Майкл и др. Oracle 7.3. Энциклопедия пользователя: Пер. с англ./Ричардс Майкл и др. – К.: Издательство «ДиаСофт», 1997. – 832с.
4. Сервер Oracle7(. Основные концепции. – Belmont, CA, USA: Oracle

Corporation, 1994. – 640с.
5. Сервер Oracle7(. Сервер. Справочное руководство по языку SQL. – Belmont,

CA, USA: Oracle Corporation, 1994. – 528с.
6. Сервер Oracle7(. Сообщения и коды ошибок. – Belmont, CA, USA: Oracle

Corporation, 1994. – 528с.
7. Методические указания по технико-экономическому обоснованию дипломных проектов. / Сост. Елецких Т.В., Афитов Э.А., Палицын В.А., Феденя А.К.

-Мн.: БГУИР, 1996. ( 123с.
8. Методические указания по дипломному проектированию для студентов специальности “Автоматизированные системы обработки информации”. / Сост.

Птичкин В.А., Никульшин Б.В. -Мн.: БГУИР, 1997. ( 33с.
9. ”Инженерные расчёты по защите от шума.” Методическое пособие по курсу

Охрана труда» для студентов всех специальностей. ( МРТИ, 1988.1

ПРИЛОЖЕНИЕ

ЛИСТИНГ ПРОГРАММЫ
Create Table Addressee (
AdditionalTelNumbers Varchar2(16) NULL ,
AddrName Varchar2(256) NOT NULL ,
Address Varchar2(256) NULL ,
CityID Number(10, 0) NOT NULL ,
Code Varchar2(16) NULL ,
Comments Varchar2(256) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
EMail Varchar2(64) NULL ,
Fax Varchar2(16) NULL ,
NameAbbrev Varchar2(16) NULL ,
POBox Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
Telephone Varchar2(16) NULL ,
Teletype Varchar2(64) NULL ,
TimeStamp Number(10, 0) NULL ,
WWW Varchar2(64) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
ZIPCode Varchar2(16) NULL ,
ZIPPOBox Varchar2(64) NULL ,
Constraint PK_Addressee PRIMARY KEY ( RecID ));

Create Table Asessment (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DateAmnt date NULL ,
DateNextAmnt date NULL ,
Grade Varchar2(64) NULL ,
PerfomanceGrade Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Asessment PRIMARY KEY ( RecID ));

Create Table Assignment (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
PartID Number(10, 0) NOT NULL ,
PlanAssignItemID Number(10, 0) NULL ,
Quantity Number(18, 1) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
TimeTableID Number(10, 0) NOT NULL ,
TimeTable_recipID Number(10, 0) NOT NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Assignment PRIMARY KEY ( RecID ));

Create Table CategTarife (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TarifeID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_CategTarife PRIMARY KEY ( RecID ));

Create Table CategTarifeLinks (
CategTarifeID Number(10, 0) NOT NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
GroupProffesionID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_CategTarifeLinks PRIMARY KEY ( RecID ));

Create Table CategTarifItem (
AddValue Number(18, 2) NULL ,
CategTarifeID Number(10, 0) NOT NULL ,
Category Varchar2(16) NOT NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TarifeItemID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_CategTarifItem PRIMARY KEY ( RecID ));

Create Table CContractItem (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
CustomerContractID Number(10, 0) NOT NULL ,
DeliveryDate date NULL ,
DeliveryTypeID Number(10, 0) NOT NULL ,
ItemNo Varchar2(16) NULL ,
Price Number(18, 2) NULL ,
PriceTypeID Number(10, 0) NOT NULL ,
ProductID Number(10, 0) NOT NULL ,
Quantity Number(18, 1) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_CContractItem PRIMARY KEY ( RecID ));

Create Table City (
CName Varchar2(64) NOT NULL ,
CityType Varchar2(64) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DefaultZIPCode Varchar2(16) NULL ,
DistrictID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
Telephone Varchar2(16) NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_City PRIMARY KEY ( RecID ));

Create Table Coefficient (
ComputationID Number(10, 0) NOT NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
Discriminator Varchar2(32) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Coefficient PRIMARY KEY ( RecID ));

CREATE TABLE O_Coefficient (
CoefficientID Number(10, 0) NOT NULL UNIQUE);

Create Table Country (
Abbrev Varchar2(64) NOT NULL ,
CntrName Varchar2(64) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
CurrencyID Number(10, 0) NOT NULL ,
National Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
Telephone Varchar2(16) NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Country PRIMARY KEY ( RecID ));

Create Table Covering (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
NeedPlanItemID Number(10, 0) NOT NULL ,
Quantity Number(18, 1) NULL ,
RecID Number(10, 0) NOT NULL ,
StockID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Covering PRIMARY KEY ( RecID ));

Create Table DAdepartment (
AddresseeID Number(10, 0) NOT NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_DAdepartment PRIMARY KEY ( RecID ));

Create Table DateWork (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
Staff_1ID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WorkDate date NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_DateWork PRIMARY KEY ( RecID ));

Create Table Department (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DateEnd date NULL ,
DateStart date NULL ,
DepCode Varchar2(16) NULL ,
DepName Varchar2(256) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL , isnp Number(1) NOT NULL ,
Constraint PK_Department PRIMARY KEY ( RecID ));

Create Table Diploma (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DateDistribution date NULL ,
DateEnd date NULL ,
DipNumber Varchar2(16) NULL ,
HSGradeShoolID Number(10, 0) NOT NULL ,
ProffessionName Varchar2(256) NULL ,
QualificationName Varchar2(256) NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
StatusGradeID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Diploma PRIMARY KEY ( RecID ));

Create Table DirtyType (
CodeDirty Varchar2(16) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
Description Varchar2(256) NULL ,
NameDirty Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_DirtyType PRIMARY KEY ( RecID ));

Create Table DirtyWorks (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DirtyTypeID Number(10, 0) NOT NULL ,
OrdersID Number(10, 0) NOT NULL ,
PlaceEmpAssocID Number(10, 0) NOT NULL ,
QuantityDay Number(18, 1) NULL ,
RecID Number(10, 0) NOT NULL ,
TimePeriod Varchar2(64) NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_DirtyWorks PRIMARY KEY ( RecID ));

Create Table Dissmissed (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DismissDate date NULL ,
DissmissReasonID Number(10, 0) NOT NULL ,
OrdersID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Dissmissed PRIMARY KEY ( RecID ));

Create Table DissmissReason (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
LawArticle Varchar2(64) NULL ,
ReasonCode Varchar2(16) NULL ,
ReasonName Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_DissmissReason PRIMARY KEY ( RecID ));

Create Table Employee (
AdditionalTelNumbers Varchar2(16) NULL ,
AddresseeID Number(10, 0) NOT NULL ,
Comments Varchar2(256) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
EMail Varchar2(64) NULL ,
EmpPosition Varchar2(64) NULL ,
FamilyName Varchar2(64) NOT NULL ,
Fax Varchar2(16) NULL ,
FirstName Varchar2(64) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
SecondName Varchar2(64) NOT NULL ,
Telephone Varchar2(16) NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Employee PRIMARY KEY ( RecID ));

Create Table GroupProfession (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
GroupCode Varchar2(16) NULL ,
GroupName Varchar2(64) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_GroupProfession PRIMARY KEY ( RecID ));

Create Table InPersonnel (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
PersonStatusID Number(10, 0) NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_InPersonnel PRIMARY KEY ( RecID ));

Create Table InquiryOfferAssoc (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
SuppInquiryItemID Number(10, 0) NOT NULL ,
SupplierOfferItemID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_InquiryOfferAssoc PRIMARY KEY ( RecID ));

Create Table LostTime (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DirtyWorksID Number(10, 0) NOT NULL ,
LostTimeTypeID Number(10, 0) NOT NULL ,
ReasonLostTime Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_LostTime PRIMARY KEY ( RecID ));

Create Table LostTimeType (
Abbrev Varchar2(16) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
TypeName Varchar2(64) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_LostTimeType PRIMARY KEY ( RecID ));

Create Table Nationality (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
NationalCode Varchar2(16) NOT NULL ,
NationalFemale Varchar2(64) NULL ,
NationalMale Varchar2(64) NULL ,
NationalityName Varchar2(64) NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Nationality PRIMARY KEY ( RecID ));

Create Table NonCategTarife (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TarifeID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_NonCategTarife PRIMARY KEY ( RecID ));

Create Table NonCategTarifItem (
AddValue Number(18, 2) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
NonCategTarifeID Number(10, 0) NOT NULL ,
ProfessionID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TarifeItemID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_NonCategTarifItem PRIMARY KEY ( RecID ));

Create Table Orders (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
Descriptions Varchar2(256) NOT NULL ,
OrderDate date NOT NULL ,
OrderNumber Varchar2(16) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Orders PRIMARY KEY ( RecID ));

Create Table OrderState (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
OStateName Varchar2(64) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_OrderState PRIMARY KEY ( RecID ));

Create Table OrderType (
Abbrev Varchar2(16) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
Description Varchar2(64) NULL ,
OTypeName Varchar2(64) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL , freetransport Number(1) NULL ,
Constraint PK_OrderType PRIMARY KEY ( RecID ));

Create Table OtherTarife (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
TarifeID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_OtherTarife PRIMARY KEY ( RecID ));

Create Table OtherTarItem (
AddValue Number(18, 2) NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
OtherTarifeID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_OtherTarItem PRIMARY KEY ( RecID ));

Create Table OutPersonnel (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_OutPersonnel PRIMARY KEY ( RecID ));

Create Table Passes (
CountryID Number(10, 0) NOT NULL ,
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DateTrip date NOT NULL ,
RecID Number(10, 0) NOT NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Passes PRIMARY KEY ( RecID ));

Create Table Passport (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
DAdepartmentID Number(10, 0) NOT NULL ,
DateDistribution date NULL ,
DateValid date NULL ,
PassNumber Varchar2(64) NULL ,
PassTypeID Number(10, 0) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
Serial Varchar2(16) NULL ,
StaffID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_Passport PRIMARY KEY ( RecID ));

Create Table PassType (
CreatedBy Varchar2(31) NULL ,
CreatedWhen date NULL ,
PassTypeName Varchar2(64) NOT NULL ,
RecID Number(10, 0) NOT NULL ,
TimeStamp Number(10, 0) NULL ,
WrittenBy Varchar2(31) NULL ,
WrittenWhen date NULL ,
Constraint PK_PassType PRIMARY KEY ( RecID ));

Рекомендуем скачать другие рефераты по теме: 11 контрольная работа, решебник класс по математике.





Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29 | Следующая страница реферата