一、创建名为booK的数据库
create database book;
二、在book下创建以下4张表
1、创建表字段,确定字段属性,约束条件
use book;
读者信息表
create table readerinfo (
card_id char(18) primary key,
name varchar(30) not null,
sex enum('男','女') not null,
age tinyint not null,
balance decimal(7,3) not null
);
图书信息表
create table bookinfo (
book_id char(10) primary key,
book_category_id varchar(10) not null ,
book_name varchar(20) unique not null,
author varchar(20) not null,
price float(7,3) not null,
press varchar(20) not null,
pubdate date not null,
store int(10) not null
);
图书类别表
create table bookcategory (
category_id char(18) primary key,
category varchar(20) not null,
);
alter table bookinfo add foreign key (book_category_id) references bookcategory (category_id); 外键
借阅信息表
create table borrowinfo (
book_id char(10) not null,
card_id char(18)not null,
borrow_date date not null,
return_date date not null,
staus enum('是','否') ,
primary key (book_id,card_id)
);