我以前编写过学生管理系统,也就是有个学号,姓名,等等。
增加有增删改查,增加信息,删除信息(以id号删的),修改,以及查找(学生学号)。这几个步骤完成的。
但现在 想写个 大学课表管理系统 不知道怎样去写 ,尤其是 数据库 怎么建立 数据库里包含什么 ,该写些什么 ,这些都很糊涂 ,希望高手给个思路, 谢谢了 ,小生感激不尽...
增加有增删改查,增加信息,删除信息(以id号删的),修改,以及查找(学生学号)。这几个步骤完成的。
但现在 想写个 大学课表管理系统 不知道怎样去写 ,尤其是 数据库 怎么建立 数据库里包含什么 ,该写些什么 ,这些都很糊涂 ,希望高手给个思路, 谢谢了 ,小生感激不尽...
//Table: TEACHER
create table TEACHER
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
NAME char(255),
COLLEGE char(255),
primary key (NUM)
);drop table if exists STUDENT;
//Table: STUDENT
create table STUDENT
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
NO int(10),
primary key (NUM)
);drop table if exists CURRICULUM;
//Table: CURRICULUM
create table CURRICULUM
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
primary key (NUM)
);drop table if exists STU_TEA;
//Table: STU_TEA
create table STU_TEA
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
TEA_NUM int(10),
primary key (NUM)
);drop table if exists TEA_CURR;
//Table: TEA_CURR
create table TEA_CURR
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);
drop table if exists STU_CURR;
//Table: STU_CURR
create table STU_CURR
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);
这些是创建student,teacher,curriculum这三张表以及三张表之间关系的创建语句,大致方向这样,如果你还有自己的需求可以添加!至于后面的打字也没法说清楚,LZ自己去看吧
//Table: TEACHER
create table TEACHER
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
NAME char(255),
COLLEGE char(255),
primary key (NUM)
);drop table if exists STUDENT;
//Table: STUDENT
create table STUDENT
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
NO int(10),
primary key (NUM)
);drop table if exists CURRICULUM;
//Table: CURRICULUM
create table CURRICULUM
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
primary key (NUM)
);drop table if exists STU_TEA;
//Table: STU_TEA
create table STU_TEA
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
TEA_NUM int(10),
primary key (NUM)
);drop table if exists TEA_CURR;
//Table: TEA_CURR
create table TEA_CURR
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);
drop table if exists STU_CURR;
//Table: STU_CURR
create table STU_CURR
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);这是student,teacher,curriculum这三张表以及彼此间关联表的建立语句,大致思路应该是这样,LZ如果有其他需求,可以向表中添加字段!
//Table: TEACHER
create table TEACHER
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
NAME char(255),
COLLEGE char(255),
primary key (NUM)
);drop table if exists STUDENT;
//Table: STUDENT
create table STUDENT
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
NO int(10),
primary key (NUM)
);drop table if exists CURRICULUM;
//Table: CURRICULUM
create table CURRICULUM
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
NAME char(255),
primary key (NUM)
);drop table if exists STU_TEA;
//Table: STU_TEA
create table STU_TEA
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
TEA_NUM int(10),
primary key (NUM)
);drop table if exists TEA_CURR;
//Table: TEA_CURR
create table TEA_CURR
(
NUM int(10) not null auto_increment,
TEA_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);
drop table if exists STU_CURR;
//Table: STU_CURR
create table STU_CURR
(
NUM int(10) not null auto_increment,
STU_NUM int(10),
CURR_NUM int(10),
primary key (NUM)
);这是student,teacher,curriculum这三张表以及彼此间关联表的建立语句,大致思路应该是这样,LZ如果有其他需求,可以向表中添加字段!