An urgent question, an entry question, thank you

lehmann

Table 1: Student Situation Information Form XS
Student ID Name Professional Name Gender Birth Time Total Credits Remarks
Primary key

Table 2: Course schedule KC
Course number Course name Start semester Hours Credits
Primary key

Table III: Students and curriculum XS_KC
Student No. Course No. Grade Credits
Primary key primary key


The first two tables, I will, how to build the third table, thank you
create table kc (
 Course number char (3) not null primary key,
 Course name char (16) not null,
 Start semester tinyint not null check ((start semester> = 1) and (start semester <= 8)),
 Hours tinyint not null,
 Credits tinyint null
)
go
create table xs (
Student number char (6) not null primary key,
Name char (8) not null,
Professional name char (10) null,
Gender bit not null default '1',
Time of birth smalldatetime not null,
Total credits tinyint null,
Note text null,
constraint chk_sex check (sex in ('1', '0'))
)
go

I ca n’t think of the third table, please help, thank you
I also found the book

lehmann

I ca n’t think of the third table, please help, thank you
I also found the book

玛洛恩

It's easier to build directly in the Enterprise Manager, and you can set up the relationship after it is built.

lehmann

But the teacher wants t-SQL

lehmann

To write in SQL

lehmann

Not set in the interface

玛洛恩

CREATE TABLE [dbo]. [Xs_kc] (
[Student ID] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Course number] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Results] [decimal] (18, 0) NULL,
[Credit] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo]. [Xs_kc] WITH NOCHECK ADD
CONSTRAINT [PK_xs_kc] PRIMARY KEY CLUSTERED
(
                [student ID],
[Course number]
) ON [PRIMARY]
GO

ALTER TABLE [dbo]. [Xs_kc] ADD
CONSTRAINT [FK_xs_kc_kc] FOREIGN KEY
(
[Course number]
) REFERENCES [dbo]. [Kc] (
[Course number]
),
CONSTRAINT [FK_xs_kc_xs] FOREIGN KEY
(
                [student ID]
) REFERENCES [dbo]. [Xs] (
                [student ID]
)
GO

yfacmilan

It seems that the landlord is passionate about writing code
Top you a lung!

lehmann

[Student ID] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL

lehmann

[Student ID] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL
Explain it, thank you