基本素養 Basic Literacy

注重人性的尊嚴、價值與培養自信心
The aim is to emphasize dignity and values of humanity, and cultivate self-confidence.
具備法治觀念與培養尊重及包容的工作態度與倫理
The aim is to learn rules of law education and develop working manner and ethics with honor and tolerance.
熱愛生命,關懷弱勢
The aim is to learn to adore life and to show care for the vulnerable.
培養外語能力並積極參與國際學術活動
The aim is to acquire knowledge and develop capabilities in learning foreign languages and aggressively joining international academic activities.

核心能力 Competence

具備製造資訊與系統領域相關知識之能力。
The aim is to acquire knowledge and develop capabilities in manufacturing information and systems.
具備E化製造領域相關知識之能力
The aim is to acquire knowledge and developing capabilities in e-Manufacturing infrastructure.
資訊技術導入工業自動化相關領與能力
The aim is to apply Information and System technology into industry for improving the efficiency and performance of manufacturing technology.
具備獨立思考、分析判斷與解決製造資訊與系統領域問題之能力
The aim is to acquire knowledge and develop capabilities of independently thinking, analyzing, and solving problems in manufacturing information and systems.
具備研究結果分析與判斷之能力
The aim is to acquire knowledge to analize research results.
具備跨領域有效溝通表達的專業語文能力
The aim is to acquire knowledge of efficient communications for crossing research area through professional language expression.
具備研讀及撰寫專業論文之能力
The aim is to acquire knowledge of reading and writing professional papers.
具備組織與領導團隊及從事創新設計之能力
The aim is to acquire knowledge of leadership for team working and innovative design.
具備凝聚團隊精神、創新製造資訊與系統領域實務所需之技術及系統整合溝通之能力
The aim is to acquire knowledge and develop capabilities of solidifying team-working spirit, and acquire knowledge of practical techniques and communication for system integration in the innovative manufacturing information and systems.

課程概述 Course Description

P953600資料庫管理系統與實務 任課老師:陳朝鈞 ( 3學分、開授學期:博碩上) 這門課提供給對資料庫系統與應用有興趣的同學。資料庫系統應用非常廣泛,例如建造一個客製化的製造系統或是智慧型自動與控制系統。本課程的主要目的是學習設計與使用資料庫系統的基本觀念。另外,我們也會讓同學親自動手完成一個小系統。透過親自實作,同學將對資料庫有更深入且具體的了解。本課程內容包括:  Introduction  DB system concepts and architecture  ER model  Relational data model  SQL programming & web databases  File organizations and index structures  Database design theory (Normalization for Relational Databases)  Transaction processing concepts  Recent advances in databases systems
This course is offered for those who are interested in understanding the design and implementation of database systems/applications for achieving the goal of building a customized computer-aided manufacturing systems and/or intelligent industrial automation and control systems. The main objective of this course is to study the fundamental concepts necessary for designing, using, and implementing database systems. In addition, students in this course also learn system implementation techniques, and will implement a system prototype in the end of the semester.

課程學習目標 Course Objectives

  • 了解資料庫設計原理
  • 了解資料庫語言
  • 撰寫資料庫應用系統技術
  • 課程進度 Progress Description

    進度說明 Progress Description
    1Introduction
    2DB system concepts and architecture
    3ER model
    4Relational data model
    5SQL (1)
    6SQL (2)
    7SQL (3)
    8database programming & web databases
    9midterm exam
    10File organizations, index structures, normalization
    11Concurrency control
    12Transaction processing
    13Advanced topics
    14paper presentation
    15paper presentation
    16paper presentation
    17paper presentation
    18final project
     以上每週進度教師可依上課情況做適度調整。The schedule may be subject to change.

    有關課程其他調查 Other Surveys of Courses

    1.本課程是否規劃業界教師參與教學或演講? 否
    Is there any industry specialist invited in this course? How many times? No
    2.本課程是否規劃含校外實習(並非參訪)? 否
    Are there any internships involved in the course? How many hours? No
    3.本課程是否可歸認為學術倫理課程? 否
    Is this course recognized as an academic ethics course? In the course how many hours are regarding academic ethics topics? No
    4.本課程是否屬進入社區實踐課程?
    Is this course recognized as a Community engagement and Service learning course? Which community will be engaged?