|
課程名稱 |
醫學資料庫
Medical Database Systems |
|
開課學期 |
101-1 |
|
授課對象 |
學程 傳染病學學程 |
|
授課教師 |
蔣以仁 |
|
課號 |
Biomed7021 |
|
課程識別碼 |
548EM0450 |
|
班次 |
|
|
學分 |
3 |
|
全/半年 |
半年 |
|
必/選修 |
選修 |
|
上課時間 |
星期三2,3,4(9:10~12:10) |
|
上課地點 |
聯教館211 |
|
備註 |
本課程以英語授課。
總人數上限：20人 |
|
Ceiba 課程網頁 |
http://ceiba.ntu.edu.tw/1011Biomed7021 |
|
課程簡介影片 |
|
|
核心能力關聯 |
核心能力與課程規劃關聯圖 |
|
課程大綱
|
|
為確保您我的權利,請尊重智慧財產權及不得非法影印
|
|
課程概述 |
Tentative schedule:
Introduction, The Database Environment
Entry-Relationship (ER) modelling
Relational Database model, Hierarchical model, Network mode, Normalization
Normalization
Relational Algebra & Relational Calculus
Physical Database Design, intro to SQL
SQL
Recess
Data and Database Administration
Object Oriented Modeling
Object Oriented Relational Modeling
Client/Server and Databases
Distributed databases
Data warehousing
Standard and Protocol (HL7 & DICOM)
Database for Cross Domains
XML Database
Biomedical Databank
New Generation Database
|
|
課程目標 |
Upon completion of this course, participants will have gained knowledge of medical database system concepts and the ability to:
Develop an appreciation of the role of medical data, files and databases in information systems
Understand the database development activities in medical areas
Be familiar with the data modeling and schema concepts (ER, ER2, Relational Algebra, and Relational Calculus) used in database design
Develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules
Integrate and merge database views into conceptual model
Apply normalization techniques
Be able to create databases and pose complex SQL queries of relational databases
Develop appreciation of DBMS (ACESS, SQL Server or ORACLE) or repositories (DSpace or Fedora)
Be familiar with a broad range of data management issues including data integrity and security
|
|
課程要求 |
無 |
|
預期每週課後學習時數 |
|
|
Office Hours |
每週三 09:10~12:10 |
|
指定閱讀 |
無 |
|
參考書目 |
Textbook: Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, 3rd Edition |
|
評量方式
(僅供參考) |
|
No. |
項目 |
百分比 |
說明 |
|
1. |
project |
50% |
|
2. |
mid-term |
50% |
|
|
|
週次 |
日期 |
單元主題 |
|
第1週 |
9/12 |
Introduction to Database 核心能力(新)3、4 |
|
第2週 |
9/19 |
The Entity-Relationship Model 核心能力(新)3、4 |
|
第3週 |
9/26 |
Data Models 核心能力(新)3、4 |
|
第4週 |
10/03 |
Advanced ER modeling techniques 核心能力(新)3、4 |
|
第5週 |
10/10 |
Data Manipulation & Entity Relationship Model 核心能力(新)3、4 |
|
第6週 |
10/17 |
Relational Model 核心能力(新)3、4 |
|
第7週 |
10/24 |
Relational Algebra 核心能力(新)3、4 |
|
第8週 |
10/31 |
Relational Calculus 核心能力(新)3、4 |
|
第9週 |
11/07 |
Structured Query Language & SQL II 核心能力(新)3、4 |
|
第10週 |
11/14 |
Storing Data: Disks and Files 核心能力(新)3、4 |
|
第11週 |
11/21 |
Normalization 核心能力(新)3、4 |
|
第12週 |
11/28 |
File Organizations and Indexing 核心能力(新)3、4 |
|
第13週 |
12/05 |
Keys with Upward Wildcards for XML 核心能力(新)3、4 |
|
第14週 |
12/12 |
Data Warehousing 核心能力(新)3、4 |
|
第15週 |
12/19 |
Introduction to Semistructured Data and XML 核心能力(新)3、4 |
|
第16週 |
12/26 |
Qualification (20pts/question) 核心能力(新)3、4 |
|
第17週 |
1/02 |
project presentation 核心能力(新)3、4 |
|
第18週 |
1/9 |
project presentation 核心能力(新)3、4 |
|