Организация информационной работы автовокзала
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
ot;Компоненты в Delphi 6: профессиональная работа", издательство "Диалектика", 2004
.В.И. Ключко "Методическое указание к выполнению курсовой работы", Краснодар, Издательство КубГТУ, 1997
.М.П. Малыхина "Базы данных: основы, проектирование, использование"
.Т.М. Карпова "Базы данных: модели, разработка, реализация", издательство "Питер", 2001
.Кандзюба С. П. "Delphi 6/7. Базы данных и приложения. Лекции и упражнения". - СПб.: ООО "ДиаСофтЮП", 2002. - 576.
Приложение 1 - Листинг БД скрипта
программный информационный сервер автовокзал
/****** Object: Database Autovokzaly Script Date: 22.01.2008 2:22:39 ******/DATABASE [Autovokzaly] ON (NAME = N'Autovokzaly_Data', FILENAME = N'E:\Autovokzaly\DataBase\Autovokzaly_Data.MDF' , SIZE = 9, FILEGROWTH = 10%) LOG ON (NAME = N'Autovokzaly_Log', FILENAME = N'E:\Autovokzaly\DataBase\Autovokzaly_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)Cyrillic_General_CI_ASsp_dboption N'Autovokzaly', N'autoclose', N'false'sp_dboption N'Autovokzaly', N'bulkcopy', N'false'sp_dboption N'Autovokzaly', N'trunc. log', N'false'sp_dboption N'Autovokzaly', N'torn page detection', N'true'sp_dboption N'Autovokzaly', N'read only', N'false'sp_dboption N'Autovokzaly', N'dbo use', N'false'sp_dboption N'Autovokzaly', N'single', N'false'sp_dboption N'Autovokzaly', N'autoshrink', N'false'sp_dboption N'Autovokzaly', N'ANSI null default', N'false'sp_dboption N'Autovokzaly', N'recursive triggers', N'false'spdboption N'Autovokzaly', N'ANSI nulls', N'false'sp_dboption N'Autovokzaly', N'concat null yields null', N'false'sp_dboption N'Autovokzaly', N'cursor close on commit', N'false'sp_dboption N'Autovokzaly', N'default to local cursor', N'false'sp_dboption N'Autovokzaly', N'quoted identifier', N'false'sp_dboption N'Autovokzaly', N'ANSI warnings', N'false'sp_dboption N'Autovokzaly', N'auto create statistics', N'true'sp_dboption N'Autovokzaly', N'auto update statistics', N'true'( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) )sp_dboption N'Autovokzaly', N'db chaining', N'false'[Autovokzaly]
/****** Object: Login Administrator Script Date: 22.01.2008 2:22:39 ******/not exists (select * from master.dbo.syslogins where loginname = N'Administrator')@logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Autovokzaly', @loginlang = N'us_english'@logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)@logindb = N'master'@loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')@loginlang = @@languagesp_addlogin N'Administrator', null, @logindb, @loginlang
/****** Object: Login Kadry01 Script Date: 22.01.2008 2:22:39 ******/not exists (select * from master.dbo.syslogins where loginname = N'Kadry01')@logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Autovokzaly', @loginlang = N'us_english'@logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)@logindb = N'master'@loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')@loginlang = @@languagesp_addlogin N'Kadry01', null, @logindb, @loginlang
/****** Object: Login Kassir01 Script Date: 22.01.2008 2:22:39 ******/not exists (select * from master.dbo.syslogins where loginname = N'Kassir01')@logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Autovokzaly', @loginlang = N'us_english'@logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)@logindb = N'master'@loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')@loginlang = @@languagesp_addlogin N'Kassir01', null, @logindb, @loginlang
/****** Object: Login Manager Script Date: 22.01.2008 2:22:39 ******/not exists (select * from master.dbo.syslogins where loginname = N'Manager')@logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Autovokzaly', @loginlang = N'us_english'@logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)@logindb = N'master'@loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')@loginlang = @@languagesp_addlogin N'Manager', null, @logindb, @loginlang
/****** Object: Login Mechanic Script Date: 22.01.2008 2:22:39 ******/not exists (select * from master.dbo.syslogins where loginname = N'Mechanic')@logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Autovokzaly', @loginlang = N'us_english'@logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)@logindb = N'master'@loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')@loginlang = @@languagesp_addlogin N'Mechanic', null, @logindb, @loginlang
/****** Object: Login BUILTIN\Администраторы Script Date: 22.01.2008 2:22:39 ******/sp_addsrvrolemember N'BUILTIN\Администраторы', sysadmin
/****** Object: User Administrator Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'Administrator')sp_grantdbaccess N'Administrator', N'Administrator'
/****** Object: User guest Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'guest' and hasdbaccess = 1)sp_grantdbaccess N'guest'
/****** Object: User Kadry01 Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'Kadry01')sp_grantdbaccess N'Kadry01', N'Kadry01'
/****** Object: User Kassir01 Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'Kassir01')sp_grantdbaccess N'Kassir01', N'Kassir01'
/****** Object: User Manager Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'Manager')sp_grantdbaccess N'Manager', N'Manager'
/****** Object: User Mechanic Script Date: 22.01.2008 2:22:39 ******/not exists (select * from dbo.sysusers where name = N'Mechanic')sp_grantdbaccess N'Mechanic', N'Mechanic'
/****** Object: User Administrator Script Date: 22.01.2008 2:22:39 ******/sp_addrolemember N'db_owner', N'Administrator'
/****** Object: Table [dbo].[AutoPark] Script Date: 22.01.2008 2:22:40 ******/TABLE [dbo].[AutoPark] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[AutoVokzal] [int] NULL ,
[AutoNumber] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Kol_voMest] [int] NULL ,
[Model] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[AutoVokzal] Script Date: 22.01.2008 2:22:40 ******/TABLE [dbo].[AutoVokzal] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[Region] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Sity] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Street] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Flat] [int] NULL ,
[Phone] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Director] [nchar] (20) COLLATE Cyrillic_General_CI_AS NULL ,
[NAME] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[Personal] Script Date: 22.01.2008 2:22:40 ******/TABLE [dbo].[Personal] (
[Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FirstName] [nchar] (20) COLLATE Cyrillic_General_CI_AS NULL ,
[SurName] [nchar] (20) COLLATE Cyrillic_General_CI_AS NULL ,
[Dolgnost] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Pol] [bit] NULL ,
[BirhtDay] [datetime] NULL ,
[INN] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[NumberPension] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Region] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Sity] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Street] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Flat] [int] NULL ,
[Phone] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[AvtoVokzal] [int] NULL ,
[LogonName] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Password] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[Reysi] Script Date: 22.01.2008 2:22:40 ******/TABLE [dbo].[Reysi] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[Code] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
[Data] [datetime] NULL ,
[Driver] [int] NULL ,
[SecondDriver] [int] NULL ,
[PunktOtpravlenia] [int] NULL ,
[PunktNaznachenia] [int] NULL ,
[Kontroler] [int] NULL ,
[NamberPlatformi] [nchar] (10) COLLATE Cyrillic_General_CI_AS NULL
[AutoVokzal] [int] NULL ,
[Avto] [int] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[Sity] Script Date: 22.01.2008 2:22:40 ******/TABLE [dbo].[Sity] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[Name] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Region] [nchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
[Map] [image] NUL