帮忙分析一下,这样的语句建立的数据表属于什么范式?

[liudianhalf]

CREATE TABLE [eis_survey_base] (
[surveyID] [int] IDENTITY (1, 1) NOT NULL ,
[surveyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[surveyBack] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[flagTeacherOrMaster] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_eis_survey_base_flagTeacherOrMaster] DEFAULT ('0'),
[flagNeglectAllMax] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_eis_survey_base_flagNeglectAllMax] DEFAULT ('0'),
[flagNeglecteAllMin] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_eis_survey_base_flagNeglecteAllMin] DEFAULT ('0'),
[techno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[adddate] [datetime] NOT NULL CONSTRAINT [DF_eis_survey_base_adddate] DEFAULT (getdate()),
CONSTRAINT [PK_eis_survey_base] PRIMARY KEY CLUSTERED
(
[surveyID]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



CREATE TABLE [eis_survey_item] (
[itemID] [int] IDENTITY (1, 1) NOT NULL ,
[surveyID] [int] NOT NULL ,
[itemInputIndex] [int] NULL ,
[itemShowIndex] [int] NULL ,
[itemName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[itemScore] [int] NOT NULL CONSTRAINT [DF_eis_survey_item_itemScore] DEFAULT (10),
CONSTRAINT [PK_eis_survey_item] PRIMARY KEY NONCLUSTERED
(
[itemID]
) ON [PRIMARY] ,
CONSTRAINT [FK_eis_survey_item_eis_survey_base] FOREIGN KEY
(
[surveyID]
) REFERENCES [eis_survey_base] (
[surveyID]
) ON DELETE CASCADE
) ON [PRIMARY]
GO


CREATE TABLE [eis_survey_choice] (
[choiceID] [int] IDENTITY (1, 1) NOT NULL ,
[itemID] [int] NOT NULL ,
[choiceContent] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[choiceScore] [decimal](6, 2) NOT NULL CONSTRAINT [DF_eis_survey_choice_choiceScore] DEFAULT (1),
CONSTRAINT [PK_eis_survey_choice] PRIMARY KEY NONCLUSTERED
(
[choiceID]
) ON [PRIMARY] ,
CONSTRAINT [FK_eis_survey_choice_eis_survey_item] FOREIGN KEY
(
[itemID]
) REFERENCES [eis_survey_item] (
[itemID]
) ON DELETE CASCADE
) ON [PRIMARY]
GO


CREATE TABLE [eis_survey_info] (
[infoID] [int] IDENTITY (1, 1) NOT NULL ,
[xqid] [int] NOT NULL CONSTRAINT [DF_eis_survey_info_xqid] DEFAULT (0),
[surveyID] [int] NOT NULL ,
[grade] [int] NOT NULL ,
[class] [int] NOT NULL ,
[classno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[subjectID] [int] NOT NULL ,
[adddate] [datetime] NOT NULL CONSTRAINT [DF_eis_survey_info_adddate] DEFAULT (getdate()),
[adder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_eis_survey_info] PRIMARY KEY CLUSTERED
(
[infoID]
) ON [PRIMARY] ,
CONSTRAINT [FK_eis_survey_info_eis_survey_base] FOREIGN KEY
(
[surveyID]
) REFERENCES [eis_survey_base] (
[surveyID]
) ON DELETE CASCADE
) ON [PRIMARY]
GO


CREATE TABLE [eis_survey_value] (
[valueID] [int] IDENTITY (1, 1) NOT NULL ,
[infoID] [int] NOT NULL ,
[choiceID] [int] NOT NULL ,
[submitter] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
CONSTRAINT [PK_eis_survey_value] PRIMARY KEY NONCLUSTERED
(
[valueID]
) ON [PRIMARY] ,
CONSTRAINT [FK_eis_survey_value_eis_survey_info] FOREIGN KEY
(
[infoID]
) REFERENCES [eis_survey_info] (
[infoID]
) ON DELETE CASCADE
) ON [PRIMARY]
GO

[abc_sk]

第三

[liudianhalf]

好象不是第三,重新设计了一下,不要在乎范式,数据操作方便才是最重要的