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

CREATE TABLE [dbo].[Dts](
[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
The modifications to the base table to form the Smith-Winslett
model are described as follows:
CREATE TABLE [dbo].[Smith-Employee](
[Name] [nvarchar](50) NOT NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[Salary] [smallmoney] NULL,
[TC] [int] NOT NULL,
CONSTRAINT [PK_Smith-Employee] 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 MLR model are
described as follows:
CREATE TABLE [dbo].[Employee](
[Name] [nvarchar](50) NOT NULL,
[CName] [int] NOT NULL,
[Department] [nvarchar](50) NULL,
[CDept] [int] NOT NULL,
[Salary] [smallmoney] NULL,
[CSalary] [int] NOT NULL,
[TC] [int] NOT NULL,
CONSTRAINT [PK_Employee_1] PRIMARY KEY CLUSTERED
(
[Name] ASC,