Database Reference
In-Depth Information
CREATE TABLE [dbo].[D3-ts](
[Name] [nvarchar](50) NULL,
[CName] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[D3-u](
[Name] [nvarchar](50) NULL,
[CName] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL
) ON [PRIMARY]
GO
The modifications to the base table to form the Jajodia-Sandhu
model are described as follows:
CREATE TABLE [dbo].[Du](
[Name] [nvarchar](50) NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[CDept] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Dc](
[Name] [nvarchar](50) NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[CDept] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Ds](
[Name] [nvarchar](50) NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[CDept] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL
) ON [PRIMARY]
GO
Search WWH ::




Custom Search