Информационная система "Data-центр" |
table> | |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_MASHIN | Код конфигурации | Int | Первичный | | ID_PROC | Код процессора | Int | Внешний | | ID_HDD | Код конфигурации | Int | Внешний | | ID_MEM | Код оперативной памяти | Int | Внешний | | ID_SPEED | Код скорости подключения | Int | Внешний | | NAIM | Название конфигурации | nchar | | | CENA | Цена аренды в месяц | Real | | | | Таблица 2.3 TB_HDD |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_HDD | Код жесткого диска | Int | Первичный | | NAIM | Наименование | nchar | | | HARACT | Характеристики | nchar | | | |
Таблица 2.4 TB_KLIENTS |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_KLIENT | Код клиента | Int | Первичный | | NAIM | ФИО | nchar | | | HARACT | Контактные данные | nchar | | | |
Таблица 2.5 TB_MEM |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_MEM | Код памяти | Int | Первичный | | NAIM | Наименование | nchar | | | HARACT | Характеристики | nchar | | | |
Таблица 2.6 TB_PROC |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_PROC | Код процессора | Int | Первичный | | NAIM | Наименование | nchar | | | HARACT | Характеристики | nchar | | | |
Таблица 2.4 TB_SPEED |
Имя поля | Пояснение | Тип данных | Ключ поля | | ID_SPEED | Код скорости | Int | Первичный | | NAIM | Наименование | nchar | | | HARACT | Характеристики | nchar | | | | 2.2.2 Схема данныхСхема 2.2 Структура таблиц2.3 Определение формы представления входных и выходных данных2.3.1 ФормыРисунок 2.2 Главная формаРисунок 2.3 Форма запросов, таблиц и представлений.Рисунок 2.4 Форма справочниковРисунок 2.5 Форма добавления элементов в таблицы.Рисунок 2.5 Data Module3. РАБОЧИЙ ПРОЕКТ3.1 Текст программы3.1.1 Сценарий в Microsoft SQL ServerSET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_SPEED]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_SPEED]( [ID_SPEED] [int] IDENTITY(1,1) NOT NULL, [NAIM] [nchar](10) NULL, [HARACT] [nchar](10) NULL, CONSTRAINT [PK_TB_SPEED] PRIMARY KEY CLUSTERED ( [ID_SPEED] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_KLIENTS]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_KLIENTS]( [ID_KLIENT] [int] IDENTITY(1,1) NOT NULL, [NAIM] [nchar](25) NULL, [HARACT] [nchar](50) NULL, CONSTRAINT [PK_TB_KLIENTS] PRIMARY KEY CLUSTERED ( [ID_KLIENT] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_PROC]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_PROC]( [ID_PROC] [int] IDENTITY(1,1) NOT NULL, [NAIM] [nchar](10) NULL, [HARACT] [nchar](10) NULL, CONSTRAINT [PK_TB_PROC] PRIMARY KEY CLUSTERED ( [ID_PROC] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_MEM]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_MEM]( [ID_MEM] [int] IDENTITY(1,1) NOT NULL, [NAIM] [nchar](10) NULL, [HARACT] [nchar](10) NULL, CONSTRAINT [PK_TB_MEM] PRIMARY KEY CLUSTERED ( [ID_MEM] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_HDD]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_HDD]( [ID_HDD] [int] IDENTITY(1,1) NOT NULL, [NAIM] [nchar](10) NULL, [HARACT] [nchar](10) NULL, CONSTRAINT [PK_TB_HDD] PRIMARY KEY CLUSTERED ( [ID_HDD] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_MASHIN]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_MASHIN]( [ID_MASHIN] [int] IDENTITY(1,1) NOT NULL, [ID_PROC] [int] NULL, [ID_HDD] [int] NULL, [ID_MEM] [int] NULL, [ID_SPEED] [int] NULL, [NAIM] [nchar](10) NULL, [CENA] [real] NULL, CONSTRAINT [PK_TB_MASHIN] PRIMARY KEY CLUSTERED ( [ID_MASHIN] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TB_DOGOVOR]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TB_DOGOVOR]( [ID_DOGOVOR] [int] IDENTITY(1,1) NOT NULL, [ID_KLIENT] [int] NULL, [ID_MASHIN] [int] NULL, [Date_zakl] [datetime] NULL, [Date_okonch] [datetime] NULL, [Stoimost] [real] NULL, CONSTRAINT [PK_TB_DOGOVOR] PRIMARY KEY CLUSTERED ( [ID_DOGOVOR] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[PR_MASHIN]')) EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[PR_MASHIN] AS SELECT dbo.TB_MASHIN.NAIM AS NAIM_MASH, dbo.TB_MEM.NAIM AS NAIM_MEM, dbo.TB_SPEED.NAIM AS NAIM_SPEED, dbo.TB_PROC.NAIM AS NAIM_PROC, dbo.TB_HDD.NAIM AS NAIM_HDD, dbo.TB_MASHIN.CENA FROM dbo.TB_MASHIN INNER JOIN dbo.TB_MEM ON dbo.TB_MASHIN.ID_MEM = dbo.TB_MEM.ID_MEM INNER JOIN dbo.TB_PROC ON dbo.TB_MASHIN.ID_PROC = dbo.TB_PROC.ID_PROC INNER JOIN dbo.TB_SPEED ON dbo.TB_MASHIN.ID_SPEED = dbo.TB_SPEED.ID_SPEED INNER JOIN dbo.TB_HDD ON dbo.TB_MASHIN.ID_HDD = dbo.TB_HDD.ID_HDD ' GO EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3))" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2))" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10
Страницы: 1, 2, 3, 4
|