高普考題庫
96 年 096年公務人員高等考試三級考試暨普通考試・資料庫應用
申論 3假設某圖書館之關連資料庫中有七個關連資料表其資料綱要(data schema)如下,底線代表主要鍵,箭頭曲線代表外鍵。BOOK(BookId, Title, PublisherName)BOOK_AUTHORS(BookId, AuthorName)PUBLISHER(Name, Address, Phone)BOOK_COPIES(BookId, BranchId, No_Of_Copies)BOOK_LOANS(BookId, BranchId, CardNo, DateOut, DueDate)LIBRARY_BRANCH(BranchId, BranchName, Address)BORROWER(CardNo, Name, Address, Phone)BOOK BOOK_AUTHORSBookId Title PublisherName BookId AuthorNamePUBLISHERName AddressPhoneBOOK_COPIES BOOK_LOANSBookId BranchId No_Of_CopiesBookId BranchIdCardNoDateOut DueDateLIBRARY_BRANCH BORROWERBranchId BranchName AddressCardNoName Address Phone試寫出以下查詢之SQL:(每小題10 分,共20 分)㈠該圖書館的各分館各擁有多少本書且其書名為“Lord of the Rings"?㈡那些借閱人現在在各分館借出“Lord of the Rings"這本書?