本課程教導學生認識資料庫管理系統,開發資料庫系統的步驟,以Microsoft SQL 2012為課堂實作環境,教導學生如何進行關聯式資料庫的規劃分析與建置、資料表正規化原理及SQL語法之DDL指令。
1.認識資料庫管理系統架構
2.資料庫系統設計
3.資料庫查詢語法This course teaches students how to understand the database management system, develop the database system, and use Microsoft SQL 2012 as the classroom environment, and teaches students how to conduct the planning analysis and construction of related databases, the principle of table regulation and SQL syntax DDL instructions.
1. Understand the Database Management System Architecture
2. Database system design
3. Database query syntax
桂思強 (2012),SQL Server 2012資料庫設計實務,碁峯資訊 (*)
黃三益 (2012),資料庫的核心理論與實務,前程文化
Gui Siqiang (2012), SQL Server 2012 Database Design and Implementation, Avon Information (*)
Huang Sanyi (2012), Core theory and practice of databases, Future Culture
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
平時成績(出、參與、小考及作業)平時成績(出、參與、小考及作業) Regular results (exam, participation, exam and work) |
50 | 5次以上無故缺席0% |
期中考期中考 Midterm exam |
25 | |
期末報告期末報告 Final report |
25 |