createtableStudentInfo
(
StudentIDvarchar(20)primarykey ,
StudentNamevarchar(60)notnull,
Majorvarchar(50)notnull,
CampusAddressvarchar(100)
);
createtableCourseInfo
(
CourseIDvarchar(20)primarykey ,
CourseTitlevarchar(60)notnull,
InstructorNamevarchar(60)
);
createtableInstructorInfo
(
InstructorNamevarchar(60)notnullprimarykey,
InstructorLocationvarchar(100)notnull
);
createtableStudentScore
(
StudentIDvarchar(20)notnull,
CourseIDvarchar(20)notnull,
Gradevarchar(2),
primarykey(StudentID,CourseID)
);
alter table StudentScore add constraint c1 foreign key(StudentID) references
StudentInfo(StudentID);
alter table StudentScore add constraint c2 foreign key(CourseID) references
CourseInfo(CourseID);
insert into StudentInfo(StudentID,StudentName,Major,CampusAddress)
values('168300458','Williams','IS','208Brooks');
insert into StudentInfo(StudentID,StudentName,Major,CampusAddress)
values('543291073','Baker','Acctg','104Phillips');
insertintoCourseInfo(CourseID,CourseTitle,InstructorName)values('IS350','Database
Mgt','Codd');
insert into CourseInfo(CourseID,CourseTitle,InstructorName) values('IS465','Systems
Analysis','Parsons');
insert into CourseInfo(CourseID,CourseTitle,InstructorName) values('Acct 201','Fund
Acctg','Miller');
- 1
- 2
前往页