程序代写代做 SQL Server2008examexamData.mdf5MB109MBD:3MBexamLog.log10MB20D:

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