教學大綱 Syllabus

科目名稱：資料庫管理

Course Name: Database Management Systems
  • 學年學期：113-2 Spring Semester, 2025
  • 科目代碼：306008001 Course No.306008001

修別：必

Type of Credit: Required

3.0

學分數

Credit(s)

70

預收人數

Number of Students

課程資料Course Details
  • 開課單位：資管二甲、資管二乙 Course Department:Management Information Systems/B/2
  • 授課老師：周致遠 Instructor: CHOU CHIH-YUAN
  • 先修科目：無Prerequisite(N/A)
  • 上課時間：一D56 Session: mon13-16

課程簡介Course Description

The course of Database Management Systems provides an introduction to the management of database management systems (DBMS). Students will learn multiple principles, tools, and practices of database management and database design. Specifically, the following materials will be covered during the semester: (1) The fundamentals of relational database systems including data models, database architectures, and database manipulations, (2) The database conceptual design, (3) The management issues on database systems, (4) The applications of database management systems, and (5) The new developments and trends of database management. Both technical and practical knowledge will be emphasized.

* To facilitate our course scedule to fit the current 16+2 and the future 16+0 school policy, we will have a full THREE-HOUR lecture & TA session in the first week (Feb 17, 2025). Manual course adding will be decided during the first or second hour after we finish the course introduction part. 

* To balance the number of students in our both classes to achieve better teaching quality, the number of manual course-adding students for this class may be limited depending on the number of enrolled students we have on both classes. The actual policy will be announced before the semester starts.

* Asynchronous course videos for our classes both in English and in Mandarin Chinese will be provided to all our enrolled students for course review in both classes. We encourage students to choose English class on Mondays due to the limited space especially if student(s) need course manual course-adding. Manual course-adding policy will be announced after we know the results from course selection during the winter break.

* We extremely welcome exchange students to join us! Proactive cooperation with our local students will earn additional bonus points.

 

* (Updated on Feb 14, 2025)

Manual course-adding policy for Spring 2025 DBMS classes can be found as follows. ALL the students who need manual course-adding should attend our first class to express their intentions.

Target numbers of students (subject to change):

  • Monday’s class: about 15 - 20 (Our expected enrollment total is 65-70.)
  • Tuesday’s class: about 10 - 15 (Our expected enrollment total is 65-70.)

Ordered List for Manual Course-adding Priority:

  1. Protected list (extremely limited)
  2. Exchange students (if available)
  3. Students from University System of Taiwan (NCU, NTHU, & NYCU) (if available)
  4. NCCU MIS sophomore students
  5. NCCU MIS other students (including those with admission from our MS program)
  6. NCCU College of Commerce ETP students (for Monday's class only)
  7. NCCU FinTech Program students
  8. NCCU College of Commerce Big Data Analysis Program students
  9. NCCU Department of Accounting Big Data Program students
  10. NCCU College of Commerce students
  11. Other NCCU students
  12. Students from other universities (if available)

The above policy is subject to change.

核心能力分析圖 Core Competence Analysis Chart

能力項目說明

    課程目標與學習成效Course Objectives & Learning Outcomes

    The major objectives of this course revolve around helping the student:

    • Understanding and interpreting the main terminology of database management & design.
    • Analyze the business needs and provide easier, technology-based solutions where appropriate.
    • Be familiar with basic conceptual database design and system development processes.
    • Understand how database management systems can be put to effective use in the real context.
    • Be able to retrieve data using SQL
    • Study the various types of logical data models in use today and likely to emerge in the coming years.

    每周課程進度與作業要求 Course Schedule & Requirements

    教學週次Course Week 彈性補充教學週次Flexible Supplemental Instruction Week 彈性補充教學類別Flexible Supplemental Instruction Type

    週次

    Week

    課程主題

    Topic

    課程內容與指定閱讀

    Content and Reading Assignment

    教學活動與作業

    Teaching Activities and Homework

    學習投入時間

    Student workload expectation

    助教討論課

    TA Sessions

    (Mondays 4-6 pm)

    課堂講授

    In-class Hours

    課程前後

    Outside-of-class Hours

    1

    Database

    Management Basics

    DBMS Introduction, System Development Process, SCRUM, & Agile Practices

    (Feb 17)

     

    1. Lectures & Discussions
    2. Additional Discussion Sessions May Be Requested
    3. Pop Quizzes Available
    4. Bonus Homework Assignments Available

    3.0

    6.0

    Final Project & TA Class Introduction + Git Intro

    2

    Entity-Relational (ER) Modeling

    (Feb 24)

    3.0

    6.0

    Back-End (1): JavaScript Intro + Web App Architecture + ExpressJS Intro + Project Setup & Connect to DB

    3

    Relational Model & ER to Relations

    (Mar 03)

    3.0

    6.0

    Back-End (2): RESTful API design + SQL Basics + CRUD APIs + Auth

    4

    Functional Dependency & Normalization

    (Mar 10)

    3.0

    6.0

    Discussion (I)

    5

    SQL (I)

    (Mar 17)

    3.0

    6.0

    Front-End (1): Bootstrap

    6

    SQL (II) & DBMS Programming

    (Mar 24)

    3.0

    6.0

    Frontend (2): AJAX & Axios

    7

    Exam

    Midterm Exam

    (Mar 31, 6-9 pm)

    Exam

    3.0

    6.0

    No Session

    8

    Database Transaction Processing

    Transaction Management & Failure Recovery (I)

    (Apr 07)
    1. Lectures & Discussions
    2. Additional Discussion Sessions May Be Requested
    3. Pop Quizzes Available
    4. Bonus Homework Assignments Available

    3.0

    6.0

    Discussion (II)

    9

    DBMS Storage & Failure Recovery (II)

    (Apr 14)

    3.0

    6.0

    SQL: Basic Recap, Query Performance, Implementation Explanation, Indexing, & some more functions

    10

    Scheduling & Concurrency Control (I)

    (Apr 21)

    3.0

    6.0

    Flexible course (Content TBD)

    11

    Concurrency Control (II)

    (Apr 28)

    3.0

    6.0

    Final Project Q&A

    12

    Advanced Topics

    Database Trending Topics

    (May 05)

    3.0

    6.0

    		 Discussion (III) (Flexible)

    13

    Exam

    Final Exam

    (May 12, 6-9 pm)

    Exam

    3.0

    6.0

    No Session

    14

    No Class

    School Anniversary Break Week
    (No Class on May 19)

    Demo Preparation

    0.0

    6.0

    No Session

    15

    Demo

    Main Functions Demo

    (May 26 or 27)

    Demo group-by-group

    3.0

    6.0

    Demo

    (May 26/27)

    16-18

    Presentation & Peer Review

    Video Presentation

    (Submit online, due on May 27)

    (Online peer review due on Jun 10)

    Student Presentation, Discussion, & Between-Group Peer Review

    6.0

    18.0

    No Session

    Notes
    • The course schedule is subject to change. Lectures about indexing and/or query optimization may be added during the semester, depending on the course schedule availability.
    • The lecture about database trending topics may include data-related careers introduction, NOSQL, data warehouse, and/or database security issues, depending on the course schedule availability.
    • ALL the students are required to attend the TA class.
    • Schedule for TA Sessions will be adjusted if needed.
    • The course is designed for sophomore students in the Department of Management Information Systems. Final grades with detailed comments may be available to all our students by the Mid-July (or earlier). Please be aware of the schedule and be patient for the results. Graduate students, senior students, or exchange students will NOT receive early results due to the fair grading process.

    授課方式Teaching Approach

    70%

    講述 Lecture

    10%

    討論 Discussion

    10%

    小組活動 Group activity

    10%

    數位學習 E-learning

    0%

    其他： Others:

    評量工具與策略、評分標準成效Evaluation Criteria

    • Pop Quizzes (Bonus points, if any), Midterm Exam (22.5%) & Final Exam (27.5%): Two closed-book midterm exams and several in-class pop quizzes (bonus points available) will be administered during the semester. If the exam(s) will be missed because of a University-excused absence (and prior notice and evidence are provided), the exam(s) may be rescheduled by the instructor based on his discretion. The format of the make-up exam(s) may vary from the formats of regularly scheduled exams. The instructor has the sole right to make determinations concerning the potential for make-up exams. For the exams, no reasons of absence will be accepted, and no make-up exam will be offered. Please make sure that you are able to attend both exams before selecting our course.
      • Midterm Exam: Monday, March 31, 2025, 6-9 pm; Scope: All the materials before Week 7.
      • Final Exam: Monday, May 12, 2025, 6-9 pm; Scope: All the materials during this semester.
         
    • Final Project & Homework Assignments (45%): You will join to a team to work on the project and homework assignments. In the project, you will need to design a database for real business(es) and analyze your design strategy. Students do not need to build a real complete database. However, need analysis, agile practices, data modeling (diagrams & descriptions), RDBS explanation, BCNF proof, potential programming needs and generated reports will be examined. Main functions of the database systems should be developed and tested. (Our teaching assistants will help you identify the main functions.) Bonus may be offered to the more complete system prototype(s) if any. (We may offer at most 5 points, not necessary. Please do not spend too much time here.) Students choose the topic on their own, but the topic should be “semi-real” problem. That is, you will not build the database systems in real context but may still need to conduct interviews or surveys with real business(es) to know the real needs for your proposed database design. A late penalty of 20% per 24-hour period will be imposed for projects/homework assignments turned in after the submission time. Saturday and Sunday count as one 24-hour period.
      • Video Presentation (25%): You will need to present your findings or thoughts from your project by uploading your pre-recorded 15-minutes video(s). Students in the same group will receive the same grade. (Students SHOULD participate in the group work to receive the grade. The in-group peer evaluation will be utilized to adjust your grade.) At least two students in a group should be presenters. You will need to pre-record a 15-minutes video and then upload to our course platform to share with everyone in class by Tuesday, May 27, 2025 (Taipei Time). Please make your article title with your group numbers (e.g., Group 1) so that every other group will be able to know which group you are. You may refer to the rubrics for video presentation for more details (will announce during semester).
      • Between-group peer evaluation (Bonus points available): You will need to provide comments, suggestions, and ranking for all the other presentations in a survey. We will not let groups know who leaves the comments, so please be open to write anything that might be helpful or critical to your peer groups. Bonus point(s) will be offered to the groups who provide excellent comments and who get the highest vote from your peer groups. (It is okay to write your comments in either Traditional Chinese or English.) Please upload the evaluation file you have filled up by 11:59:59 pm on Jun 10, 2025 (Taipei Time).
      • Main Functions Demo (20% + Bonus points available): You will need to develop and test the main functions for your proposed database systems using any type of programming language (e.g., Java, C#, PHP, Python, etc.). It is necessary to prove that your main functions could be successfully linked with database and implemented with SQL commands. Bonus points will be offered to a more complete functional system prototype (Not necessary. Please do not spend too much time here.). ALL the groups will need to present their demo for main functions in the end of the semester (on Week 15). Instructions will be provided during the TA Practical Sessions and some potential additional discussion opportunities with our teaching assistants outside classes.
      • Homework Assignments (Bonus points, if any): You may be assigned take-home group assignments in certain classes. Students in the same group will receive the same grade. (Students SHOULD participate in the group work to receive the grade.)
      • In-group peer evaluation (Bonus points available): your will need to provide your job distribution, comments, appraisal, or complaints to your group members, and suggestions to our course in another survey. We will not let other people know who leaves the comments, so please be open and honest to provide your opinions. Points will be cut from your total final score up to 60 points if you have been complaint by your partners with credible specific reasons. Bonus point(s) may be offered to the member who receive outstanding appraisals. Otherwise, all your group members will receive the same grade for the group work. (It is okay to write your comments in either Traditional Chinese or English.)
         
    • TA Practical Sessions (5%): To help students develop their ideas on the final projects step-by-step, a weekly practical TA class is offered (Mondays 4 -6 pm at College of Commerce Building 5th floor Computer Classroom 260509). Students are required to attend the practical TA class. Participation, and tasks or worksheets provided and assigned in the sessions may be counted and will be highly beneficial to the final project (which counts for 45 points). Bonus points may be offered as well. Because of the space limit, students should attend their TA practical session for selected class only. It is possible to attend TA classes in another session only if you obtain the agreement from our teaching assistants & there are additional available seats.

    指定/參考書目Textbook & References

    Required Textbook: Modern Database Management by J. Hoffer, R. Venkarataman, and H. Top, Pearson FT Press, 13th Edition/Global Edition. (代理商: 開發圖書有限公司) (ISBN-13: 978-1292263359 | ISBN-10: 1292263350)

    Recommended Reference: Fundamentals of Database Systems by R. Elmasri and S. B. Navathe, Pearson IT Certifica, 7th Edition/Global Edition. (代理商: 高立圖書有限公司) (ISBN-13: 978-1292097619 | ISBN-10: 1292097612)

    Optional References:

    * Concepts of Database Management by L. Friedrichsen, L. Ruffolo, E. Monk, J. L. Starks, P. J. Pratt, and M. Z. Last, Cengage Learning, 10th Edition. (代理商: 華泰文化) (ISBN-13: 978-0357422083 | ISBN-10: 0357422082)

    * Database Systems: Design, Implementation, & Management by C. Coronel and S. Morris, Cengage Learning, 13th Edition. (ISBN-13: 978-1337627900 | ISBN-10: 1337627909)

    * Database Administration: The Complete Guide to DBA Practices and Procedures by C. S. Mullins, Addison-Wesley Professional, 2nd Edition. (ISBN-13: 978-0321822949 | ISBN-10: 0321822943)

    * Data Mining: A Tutorial-Based Primer by R. J. Roiger, Chapman and Hall/CRC, 2nd Edition. (ISBN-13: 978-1498763974 | ISBN-10: 1498763979)

    * Data Science and Big Data Analytics by EMC Education Services, John Wiley & Sons. (ISBN-13: 978-1118876138 | ISBN-10: 111887613X)

    * Big Data and Social Science: A Practical Guide to Methods and Tools by I. Foster, R. Ghani, R. Jarmin, F. Kreuter, and J. Lane, Chapman and Hall/CRC. (ISBN-13: 978-0367341879 | ISBN-10: 0367341875)

    * Big Data: A Revolution That Will Transform How We Live, Work, and Think by V. Mayer-Schönberger and K. Cukier, Mariner Books. (ISBN-13: 978-0544227750 | ISBN-10: 0544227751)

    * SCRUM: The Art of Doing Twice the Work in Half the Time by J. Sutherland and J. J. Sutherland, Crown Business. (ISBN-13: 978-0385346450 | ISBN-10: 038534645X)

    * Software Build Systems: Principles and Experience by P. Smith, Addison-Wesley Professional. (ISBN-13: 978-0321717283 | ISBN-10: 0321717287)

    已申請之圖書館指定參考書目 圖書館指定參考書查詢 |相關處理要點

    書名 Book Title 作者 Author 出版年 Publish Year 出版者 Publisher ISBN 館藏來源* 備註 Note

    維護智慧財產權，務必使用正版書籍。 Respect Copyright.

    本課程可否使用生成式AI工具Course Policies on the Use of Generative AI Tools

    有條件開放使用:Students remain accountable for all content submitted for the course, whether it has been generated or proofread by GenAI tools or humans. Details will be announced in the beginning of the semester. Conditional Permitted to Use

    課程相關連結Course Related Links

    https://moodle-course02.nccu.edu.tw/course/view.php?id=4533

    課程附件Course Attachments

    課程進行中，使用智慧型手機、平板等隨身設備 To Use Smart Devices During the Class

    需經教師同意始得使用 Approval

    列印