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

Figure 9.4 The entity relationship diagram of the data security classification levels tables.

• Create roles that define the security classification levels of the
users in the multilevel relational database.
• Make some modifications to the base table.
• Define the view for each model of the multilevel relational
database models.

9.3.1 Source Code of the Data Security Classification
Level Tables (Figure 9.4)

CREATE TABLE [dbo].[tblCategory](
[ID] [int] IDENTITY(1,1) NOT NULL,
[LableSchemeID] [int] NULL,
[Name] [nvarchar](50) NULL,
[Abbreviation] [nvarchar](50) NULL,
[Hierarichical] [nchar](10) NULL,
[CompareRule] [nvarchar](50) NULL,
[Cardinality] [nvarchar](50) NULL,
[Required] [nchar](1) NULL,
[CreateDbRoles] [nchar](1) NULL,
[NoMarkingBehavior] [nvarchar](50) NULL,
[DefaultRole] [nvarchar](50) NULL,
CONSTRAINT [PK_tblCategory] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]