图书(总编号varchar(6),分类号varchar(8),书名varchar(16),作者varchar(6),出版单位varchar(20),单价numeric(6,2)) 读者(借书证号varchar(4),单位varchar(8),姓名varchar(6),性别varchar(2),职称varchar(6),地址varchar(20)) 借阅(借书证号varchar(4),总编号varchar(6),借书日期datetime)</p>对于图书管理数据库,请写出正确的SQL语句: 建立图书、借阅视
时间: 2023-06-10 15:05:35 浏览: 43
图:
CREATE TABLE book (
book_id varchar(6),
category_id varchar(8),
book_name varchar(16),
author varchar(6),
publisher varchar(20),
price numeric(6,2),
PRIMARY KEY (book_id)
);
CREATE TABLE borrower (
card_id varchar(4),
organization varchar(8),
name varchar(6),
gender varchar(2),
title varchar(6),
address varchar(20),
PRIMARY KEY (card_id)
);
CREATE TABLE borrow (
card_id varchar(4),
book_id varchar(6),
borrow_date datetime,
PRIMARY KEY (card_id, book_id),
FOREIGN KEY (card_id) REFERENCES borrower(card_id),
FOREIGN KEY (book_id) REFERENCES book(book_id)
);
创建图书、借阅视图:
CREATE VIEW book_view AS
SELECT book.book_id, book_category.category_id, book.book_name, book.author, book.publisher, book.price
FROM book
INNER JOIN book_category ON book.category_id = book_category.category_id;
CREATE VIEW borrow_view AS
SELECT borrow.card_id, book.book_name, book.author, borrow.borrow_date
FROM borrow
INNER JOIN book ON borrow.book_id = book.book_id;
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)