The Source Code - Multilevel Security for Relational Databases - page 173

[CName] ASC,
[CDept] ASC,
[CSalary] ASC,
[TC] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
The modifications to the base table to form the belief-consistent
model are described as follows:
CREATE TABLE [dbo].[BCEmployee](
[Name] [nvarchar](50) NOT NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[CDept] [int] NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NULL,
[TC] [int] NULL,
[flag] [int] NULL,
CONSTRAINT [PK_BCEmployee] PRIMARY KEY CLUSTERED
(
[Name] ASC,
[CName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
The modifications to the base table to form the encryption-based
multilevel database security model are described as follows:
CREATE TABLE [dbo].[Employee-Encryption](
[Name] [nvarchar](max) NOT NULL,
[Department] [nvarchar](max) NULL,
[Salary] [nvarchar](max) NULL,
[TC] [int] NOT NULL
) ON [PRIMARY]
GO