关系模式:出版社(出版社名,地址,邮编,电话)出版社名为主键 书(书号,出版社名,读者号,书名,作者,ISBN,借出日期,应还日期)书号为主键,出版社名和读者号为外键, 借阅者(读者号,姓名,地址,性别,年龄,单位)读者号为主键 , 根据关系模式创建表
时间: 2023-11-30 22:03:42 浏览: 28
创建出版社表:
```
CREATE TABLE Publisher (
publisher_name VARCHAR(50) PRIMARY KEY,
address VARCHAR(100),
zip_code VARCHAR(10),
phone VARCHAR(20)
);
```
创建书表:
```
CREATE TABLE Book (
book_id INT PRIMARY KEY,
publisher_name VARCHAR(50),
reader_id INT,
title VARCHAR(100),
author VARCHAR(50),
isbn VARCHAR(20),
borrow_date DATE,
due_date DATE,
FOREIGN KEY (publisher_name) REFERENCES Publisher(publisher_name),
FOREIGN KEY (reader_id) REFERENCES Borrower(reader_id)
);
```
创建借阅者表:
```
CREATE TABLE Borrower (
reader_id INT PRIMARY KEY,
name VARCHAR(50),
address VARCHAR(100),
gender CHAR(1),
age INT,
company VARCHAR(100)
);
```