教務(wù)網(wǎng)絡(luò)管理系統(tǒng)-wenkub
2023-04-27 12:58:12 本頁(yè)面
【正文】 char13否是書(shū)號(hào)book_namevarchar30否書(shū)名publish_panyvarchar50否出版社authornvarchar8是作者pricenumeric5,2是價(jià)格班級(jí)基本信息表包含字段如下表所示：表A3 class表列名稱類型寬度允許空值默認(rèn)值主鍵說(shuō)明class_idchar6否班級(jí)號(hào)monitornvarchar8是班主任姓名classroomvarchar13是教室student_numsmallint是學(xué)生人數(shù)教師基本信息表包含字段如下表所示：表A4teacher表列名稱類型寬度允許空值默認(rèn)值主鍵說(shuō)明teacher_idchar9否主鍵教師編號(hào)teacher_namenvarchar8否教師姓名sexbit否性別birthsmalldatetime否出生年月department_idchar6否所在系號(hào)professionnvarchar16否職務(wù)telephonenvarchar15是電話home_addrnchar40是住址postalcodepostalcode是郵編課程基本信息包含字段如下表所示：表A5course表列名稱類型寬度允許空值默認(rèn)值主鍵說(shuō)明course_idchar10否是課程號(hào)course_namenvarchar20否課程名稱book_idchar13否書(shū)標(biāo)識(shí)total_periortinyint是課程總學(xué)時(shí)week_periortinyint是周學(xué)時(shí)credittinyint是課程學(xué)分②打開(kāi)查詢分析器或企業(yè)管理器，在本地服務(wù)器上創(chuàng)建新的數(shù)據(jù)庫(kù)JWGL。設(shè)置時(shí)要求：當(dāng)主表中刪除某條記錄時(shí)，從表中相應(yīng)外鍵的記錄也應(yīng)同時(shí)被刪除。角色與權(quán)限管理： 學(xué)生、教師和教務(wù)處管理人員都有訪問(wèn)所有數(shù)據(jù)表的權(quán)限，但學(xué)生只能在選課時(shí)間對(duì)student_course表的course_id字段進(jìn)行插入和刪除操作權(quán)限，在非選課時(shí)間不能對(duì)任何表進(jìn)行除訪問(wèn)以外的操作。 提醒用戶定時(shí)對(duì)數(shù)據(jù)庫(kù)采取備份手段。student表add constraint course2_id_fkforeign key (course_id)references course(course_id) on delete cascadegoalter table student_course ble student_courseadd constraint student_id_fkforeign key (student_id)references student(student_id) on delete cascadegoteacher _course_class表alter table teacher_course_classadd constraint course3_id_fkforeign key (course_id)references course(course_id) on delete cascadegoalter table teacher_course_classadd constraint teacher_id_fkforeign key (teacher_id)references teacher(teacher_id) on delete cascadegoalter table teacher_course_class add constraint class3_id_fkforeign key (class_id)references class(class_id) on delete cascadego創(chuàng)建存儲(chǔ)過(guò)程/*向student表插入數(shù)據(jù)*/create procedure studentstudent_id int,student_name nvarchar(8),sex bit,birth smalldatetime,class_id char(6),entrance_date smalldatetime,home_addr nvarchar(40)asdelete from student where student_id=student_idinsert into student (student_id, student_name, sex, birth, class_id, entrance_date, home_addr)values(student_id,student_name,sex,birth,class_id,entrance_date,home_addr)go/*向book表插入數(shù)據(jù)*/create procedure bookbook_id char(13),book_name varchar(30),publish_pany varchar(50),author nvarchar(8),price numeric(5,2)asdelete from book where book_id=book_idinsert into book
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1