oracle數(shù)據(jù)庫(kù)系統(tǒng)-課程設(shè)計(jì)文檔畢業(yè)論文(編輯修改稿)
2025-07-31 21:23 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 t null, Course_Hour number(2) not null, Course_Credit number(2) not null, Teacher_Name Varchar2(30), Course_Intro Varchar2(200), )。 創(chuàng)建年級(jí)課程設(shè)置表create table GCourse_Setting( Grade_No varchar2(20), Course_Name varchar2(32), Constraint PRI_GCourse primary key (Grade_No,Course_Name) constraint PR_Mark primary key (Exam_No,Student_ID,Course_Name,Class_No) )。 create table Student_Mark( Exam_No varchar2(10) not null, Student_ID Varchar2(15) not null, Course_Name varchar2(32) not null, Course_Mark number(15,2) check(Course_Mark between 0 and 100), Class_No varchar2(20), constraint FK_StuID foreign key (Student_ID) references Student_info(Student_ID) )。 常見(jiàn)用戶(hù)信息表Create table User_info( User_Name varchar2(10) primary key, User_Type varchar2(10) not null, Passward varchar2(8) )。 插入測(cè)試數(shù)據(jù)insert into Student_info values(39。s000139。,39。王一39。,39。男39。,to_date(39。1988020939。,39。yyyymmdd39。),39。010139。,39。000139。,39。12345639。,39。長(zhǎng)春39。)。insert into Student_info values(39。s000239。,39。張金39。,39。男39。,to_date(39。1987070539。,39。yyyymmdd39。),39。010139。,39。000139。,39。14599739。,39。西安39。)。insert into Student_info values(39。s000339。,39。李四39。,39。女39。,to_date(39。1988020439。,39。yyyymmdd39。),39。010239。,39。000139。,39。12344639。,39。武漢39。)。insert into Student_info values(39。s000439。,39。王建39。,39。男39。,to_date(39。1987050839。,39。yyyymmdd39。),39。010239。,39。000139。,39。14597739。,39。西寧39。)。insert into Student_info values(39。s000539。,39。胡說(shuō)39。,39。女39。,to_date(39。1987080939。,39。yyyymmdd39。),39。020139。,39。000239。,39。12345639。,39。杭州39。)。insert into Student_info values(39。s000639。,39。劉力39。,39。男39。,to_date(39。1986051539。,39。yyyymmdd39。),39。020139。,39。000239。,39。14599739。,39。咸陽(yáng)39。)。insert into Student_info values(39。s000739。,39。田鍵39。,39。女39。,to_date(39。1986022339。,39。yyyymmdd39。),39。020239。,39。000239。,39。12345639。,39。長(zhǎng)春39。)。insert into Student_info values(39。s000839。,39。白春39。,39。男39。,to_date(39。1987071239。,39。yyyymmdd39。),39。020239。,39。000239。,39。14599739。,39。西安39。)。 insert into Course_info values(39。000139。,39。計(jì)算機(jī)導(dǎo)論39。,40,4,39。朱鐵英39。,39。計(jì)算機(jī)專(zhuān)業(yè)入門(mén)課程39。)。insert into Course_info values(39。000239。,39。c程序設(shè)計(jì)39。,40,4,39。劉淑華39。,39。計(jì)算機(jī)專(zhuān)業(yè)第一門(mén)語(yǔ)言課39。)。insert into Course_info values(39。000339。,39。數(shù)據(jù)結(jié)構(gòu)39。,40,4,39。
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1