然后创建选课表SC,学号和课号联合作主键,分别作外键。
create table sc(学号 char(6),课号 char(6),成绩 int,primary key (学号,课号),foreign key (学号)references 学生(学号),foreign key (课号)references 课程(课号))
CREATE TABLE [dbo].[student](
[学号] [CHAR](8) NOT NULL,
[姓名] [CHAR](8) NULL,
[性别] [CHAR](2) NULL,
[年龄] [INT] NULL,
[联系方式] [CHAR](11) NULL,
[所在院系] [CHAR](20) NULL,
CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED
(
[学号] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[student] WITH CHECK ADD CONSTRAINT [CK_student] CHECK (([性别]='女' OR [性别]='男'))
GO
ALTER TABLE [dbo].[student] CHECK CONSTRAINT [CK_student]
GO
ALTER TABLE [dbo].[student] WITH CHECK ADD CONSTRAINT [CK_student_1] CHECK (([联系方式] LIKE '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'))
GO
ALTER TABLE [dbo].[student] CHECK CONSTRAINT [CK_student_1]
GO
ALTER TABLE [dbo].[student] ADD CONSTRAINT [DF_student_所在院系] DEFAULT ('电信系') FOR [所在院系]
GO
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)