A private library in Taipei maintains a relational database that keeps the basic information of books. We are going to focus on the following tables: Book, Book_Author, Book_Copy, Library_Branch, Publisher. Below is a list of the columns in these tables. Underlined columns in the source PDF are the primary key of a table; they are marked [PK] below. • Book (BookId [PK], Title, PublisherId) • Book_Copy (BookId [PK], CopyId [PK], BranchId) • Library_Branch (BranchId [PK], Name, Address) • Publisher (PublisherId [PK], Name, Address, Phone) These tables have the following foreign key relations: • BookId in Book_Copy references BookId in Book. • BranchId in Book_Copy references BranchId in Library_Branch. • PublisherId in Book references PublisherId in Publisher. Please answer the following questions: (1) Write down the SQL command that lists the Book Title, Branch Name, and Branch Address that owns books with the title "Twilight." (8%) (2) Write down the SQL command that lists the BranchId, Branch Name, and the count of copies for books with the title "Fire and Fury." The output should be ordered so that branches with the most copies are listed first. (9%) (3) Write down the SQL command that lists the BranchId and Branch Name of Library Branches that owns at least two copies for books with the title "Only the Rain." The output should be ordered so that branches with the most copies are listed first. (8%)
這是申論或開放題,不使用 A–E 自動判分。請先在紙上完成答案,再查看參考解析並自行評估。