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

Figure 9.8 The properties of the TS role in the database.

9.3.3 Source Code of the Modifications to the Base Table

The base table is called Employee and its source code for the creation
is described as follows:

CREATE TABLE [dbo].[Emp](
[Name] [nvarchar](50) NOT NULL,
[Department] [nvarchar](50) NULL,
[Salary] [smallmoney] NULL,
CONSTRAINT [PK_Employee_1] PRIMARY KEY CLUSTERED
(
[Name] 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 SeaView model are
described as follows:

CREATE TABLE [dbo].[D1-u](

[Name] [nvarchar](50) NULL,

[CName] [int] NOT NULL