图书管理系统

–图书管理系统 Books Management System (BMS)
涉及到的对象有（图书分类booksort，图书bookname，学生sudent，借书记录record）

–创建图书表
create table book
(
book_no varchar2(64),
book_name varchar2(32),
author varchar2(32),
sort varchar2(32),
record varchar2(32),
constraint book_PRIMARY primary key(book_no)
) a

– 创建学生表
create table student
(
student_no varchar2(64),
student_name varchar2(10),
sex varchar2(1),
record varchar2(32),
constraint student_PRIMARY primary key(student_no)
);

insert into book (book_no,book_name)
values (‘001’,‘从你的全世界路过’);
insert into book (book_no,book_name)
values (‘002’,‘往事并不如焉’);
insert into book (book_no,book_name)
values (‘003’,‘西厢记’）;
insert into book (book_no,book_name)
values (‘004’,‘三体’);
insert into author(book_name,author)
values (‘从你的全世界路过’,‘张嘉佳’);
insert into author(book_name,author)
values (‘往事并不如焉’,‘张莉’);
insert into author(book_name,author)
values (‘西厢记’,‘王实甫’);
insert into author(book_name,author)
values（‘三体’,‘刘慈欣’）;
insert into classification(book_name,sort)
values (‘从你的全世界路过’,‘小说’);
insert into classification(book_name,sort)
values (‘往事并不如焉’,‘散文’);
insert into classification(book_name,sort)
values (‘西厢记’,‘杂剧’);
insert into classification(book_name,sort)
values （‘三体’,‘小说’）;

##会继续修改