1.寫出建立BORROW表的SQL語句,要求定義主碼完整性約束和引用完整性約束。 2.找出借書超過5本的讀者,輸出借書卡號及所借圖書冊數(shù)。 3.查詢借閱了"水滸"一書的讀者,輸出姓名及班級。 4.查詢過期未還圖書,輸出借閱者(卡號)、書號及還書日期。 5.查詢書名包括"網(wǎng)絡"關鍵詞的圖書,輸出書號、書名、作者。 6.查詢現(xiàn)有圖書中價格最高的圖書,輸出書名及作者。 7.查詢當前借了“計算方法”但沒有借“計算方法習題集”的讀者,輸出其借書卡號,并按卡號降序排序輸出。 8.將“C01”班同學所借圖書的還期都延長一周。 9.從BOOKS表中刪除當前無人借閱的圖書記錄。 10.如果經(jīng)常按書名查詢圖書信息,請建立合適的索引。 11.建立一個視圖,顯示“力01”班學生的借書信息(只要求顯示姓名和書名)。 12.查詢當前同時借有“計算方法”和“組合數(shù)學”兩本書的讀者,輸出其借書卡號,并按卡號升序排序輸出。 13.假定在建BOOKS表時沒有定義主碼,寫出為BOOKS表追加定義主碼的語句。 14.對CARD表做如下修改: a.將NAME最大列寬增加到10個字符(假定原為6個字符)。 b.為該表增加1列NAME(系名),可變長,最大20個字符。
上傳時間: 2014-01-03
上傳用戶:xhz1993
Perl and XML XML is a text-based markup language that has taken the programming world by storm. More powerful than HTML yet less demanding than SGML, XML has proven itself to be flexible and resilient. XML is the perfect tool for formatting documents with even the smallest bit of complexity, from Web pages to legal contracts to BOOKS. However, XML has also proven itself to be indispensable for organizing and conveying other sorts of data as well, thus its central role in web services like SOAP and XML-RPC. As the Perl programming language was tailor-
標簽: programming text-based XML language
上傳時間: 2014-01-07
上傳用戶:jichenxi0730
the function of the system is simulated ATM machine landing, balance inquiries, withdrawals, change passwords, and other functions, use the JDBC interface, such as SWING. If ATM landing, withdrawals and change password must use JDBC interface and database links, I encountered a lot of problems, but the most important is that the database setting, in order to solve this problem, I read four BOOKS, Inquiries related information ( s burden
標簽: withdrawals the inquiries simulated
上傳時間: 2017-01-27
上傳用戶:我們的船長
)。-the function of the system is simulated ATM machine landing, balance inquiries, withdrawals, change passwords, and other functions, use the JDBC interface, such as SWING. If ATM landing, withdrawals and change password must use JDBC interface and database links, I encountered a lot of problems, but the most important is that the database setting, in order to solve this problem, I read four BOOKS, Inquiries related information
標簽: withdrawals the inquiries simulated
上傳時間: 2014-01-16
上傳用戶:lnnn30
)。-the function of the system is simulated ATM machine landing, balance inquiries, withdrawals, change passwords, and other functions, use the JDBC interface, such as SWING. If ATM landing, withdrawals and change password must use JDBC interface and database links, I encountered a lot of problems, but the most important is that the database setting, in order to solve this problem, I read four BOOKS, Inquiries related information
標簽: withdrawals the inquiries simulated
上傳時間: 2017-01-27
上傳用戶:ainimao
Start it with this document[13 pages only] if you want to develop some good web application using Java instead of reading large BOOKS. This document prepared by myself. Clearly explains what is JDBC. and how you can connect to a particular database through JSP and Servlets. Examples are given.
標簽: application document develop Start
上傳時間: 2017-03-11
上傳用戶:頂?shù)弥?/p>
Each exploration in this book is a mixture of text and interactive exercises. The exercises are unlike anything you鈥檝e seen in other BOOKS. Instead of multiple choice, fill-in-the-blank, or simple Q&A exercises, lessons are interactive explorations of key C++ features.
標簽: exercises exploration interactive mixture
上傳時間: 2017-05-14
上傳用戶:whenfly
The world s bestselling computer security book--fully expanded and updated is one of the most successful security BOOKS ever written. Leverage the valuable insights Hacking Exposed 6 provides to help yourself, your company to fight cyber-crime.
標簽: bestselling computer security expanded
上傳時間: 2017-05-14
上傳用戶:thuyenvinh
This is a code of Pseudo-Arc Length Continuation Method , the method can be used for solving the nonlinear equations, the principle can re found in some text BOOKS. In the code,I prove the agreement of the code with other methods
標簽: Continuation Pseudo-Arc the solving
上傳時間: 2013-12-03
上傳用戶:xzt
對于ARM體系來說,不同語言撰寫的函數(shù)之間相互調用(mix calls)遵循的是 ATPCS(ARM-Thumb Procedure Call Standard),ATPCS主要是定義了函數(shù)呼叫時參數(shù)的傳遞規(guī)則以及如何從函數(shù)返回,關于ATPCS的詳細內(nèi)容可以查看ADS1.2 Online BOOKS ——Developer Guide的2.1節(jié)。這篇文檔要講的是匯編代碼中對C函數(shù)調用時如何進行參數(shù)的傳遞以及如何從C函數(shù)正確返回
標簽: ARM
上傳時間: 2014-01-16
上傳用戶:zyt