图书管理数据库代码

-- 创建Books表
CREATE TABLE Books (
    BookID INT PRIMARY KEY AUTO_INCREMENT,
    Title VARCHAR(255) NOT NULL,
    ISBN VARCHAR(13) UNIQUE NOT NULL,
    PublisherID INT,
    PublishDate DATE,
    FOREIGN KEY (PublisherID) REFERENCES Publishers(PublisherID)
);

-- 创建Authors表
CREATE TABLE Authors (
    AuthorID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(255) NOT NULL
);

-- 创建Book_Authors表
CREATE TABLE Book_Authors (
    BookID INT,
    AuthorID INT,
    PRIMARY KEY (BookID, AuthorID),
    FOREIGN KEY (BookID) REFERENCES Books(BookID),
    FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID)
);

-- 插入示例数据
INSERT INTO Books (Title, ISBN, PublisherID, PublishDate)
VALUES ('Effective Java', '9780321356680', 1, '2018-02-27');

INSERT INTO Authors (Name)
VALUES ('Joshua Bloch');

INSERT INTO Book_Authors (BookID, AuthorID)
VALUES (1, 1);