SQL Server2008examexamData.mdf5MB109MBD:3MBexamLog.log10MB20D:
exam
Student
Studentid
char6
primary key
Stuname
varchar20
not null
Sex
char2
not null
Birthday
smalldatetine
Entrancescore
int
not null
Departmentid
char4
not null
note
text
031001
85121
600
1111
031002
86224
590
1111
032001
8682
580
2111
032002
86512
570
2111
Department
Departmentid char4
primary key
Departmentname varchar20
not null
1111
2111
Subject
Subjectid char4
primary key
Subjectname varchar20
not null
Credit tinyint
1001
1
4
1002
2
2
2001
1
3
Score
Studentid char6
primary key
Subjectid char4
primary key
Score smallint
Examinationdate
smalldatetime
031001
1001
95
031001
1002
88
031002
1001
86
031002
1002
77
1studentsel1.sql
2031002StunameSubjectnameScoresel2.sql
3score100198sel3.sql
4Subjectsel4.sqlLike
5DepartmentDepartmentname
6Scorestubjectidsubject
7ScoreCHECKScore 0100
8StudentSex
examview,
examprocStudentidStudentidStunameDepartmentid
triexamstudent
exam
SQL Server2008examexamData.mdf5MB1M10MBD:1MBexamLog.log5MB10D:
exam
Student
Studentid
char6
primary key
Stuname
varchar20
not null
Sex
char2
not null
Birthday
smalldatetine
Entrancescore
int
not null
Departmentid
char4
not null
note
text
031001
85121
600
1111
031002
86224
590
1111
032001
8682
580
2111
032002
86512
570
2111
Department
Departmentid char4
primary key
Departmentname varchar20
not null
1111
2111
Subject
Subjectid char4
primary key
Subjectname varchar20
not null
Credit tinyint
1001
1
4
1002
2
2
2001
1
3
Score
Studentid char6
primary key
Subjectid char4
primary key
Score smallint
Examinationdate
smalldatetime
031001
1001
95
031001
1002
88
031002
1001
86
031002
1002
77
1Subjectsel1.sql
21002StunameSubjectnameScoresel2.sql
3Studentsel3.sql
4Studentsel4.sqlLike
5DepartmentDepartmentname
6ScorestudentidStudent
7SubjectCHECKScore0100
8StudentSex
examview,DepartmentidDepartmentname
examprocstudentidstudentidstunamesubjectnamescore
triexamdepartment
exam