Database Management (資料庫管理) - Spring 2024 (112-2)
Last updated on 12/29/2023
home . back

Instructor: Jieh-Shan George YEH 葉介山

Phone: 04-2632-8001 Ext. 18113 , 11700
E-mail: jsyeh@pu.edu.tw
Office: 677 Providence Hall (主顧樓677)
Office Hours: Mon. & Thu. 1:10 pm-3:00 pm or by appointments 

 

Course Web Page: http://www1.pu.edu.tw/~jsyeh/1122/

Course Objectives:

A Database is one of the important basic components in designing modern applications. Most of transaction data of an application system are stored in its database. An efficient database may reduce the response time of transaction processing, while an effective database will provide good information for decision making. In order to design a database well, we must understand data models, the relationship between data, and the inquire styles of database users.
In this course, students will learn the concepts and skills of designing an efficient relational database.

Textbook:

References:

  1. D. M. Kroenke, D. J. Auer, "Database Processing: Fundamentals, Design, and Implementation (15th Edition)," Pearson Education Inc., 2018.
  2. J. A. Hoffer, M. B. Prescott, H. Topi, "Modern Database Management (12th Edition)," Pearson Education, Inc., 2015.

Useful WebSite and Info:

  1. cengagebrain.com https://login.cengage.com/cb/ (出版社學習資源)jsyeh@pu.edu.tw, ynxxxxxxx
  2. This Course on quizlet (online learning tool-flashcards) (b73@g, 2xx3jxx)
  3. paper.dropbox.com (Dropbox paper 補充內容) (on@g, jxxjxx)
  4. 國家教育研究院雙語詞彙、學術名詞暨辭書資訊網
  5. SQL Tutorial http://www.w3schools.com/sql/
  6. International Computer Driving Licence (ICDL) 認證
    1. Using Databases電子資料庫
    2. Advanced Database進階電子資料庫
  7. Microsoft Office Specialist (MOS) 認證
  8. DB-Engines Ranking, https://db-engines.com/en/ranking
  9. Open textbooks 參考網站：
  10. DBML - Database Markup Language
  11. dbdiagram.io is a free tool to help you visualize database diagrams from DBML code.
  12. dbdocs.io is a free tool to help you build database documents from DBML code.
  13. 其他網站

Grading Policy:

Class Participation
10 points
    
Assignments
15 points
    
Quiz
15 points
  
Midterm Exam
30 points
   in the 9th week
Final Exam
30 points
   in the 16th week
Total
100 points
    

House Rules:

  1. NEW MOVEMENT: Make good use of mobile phones. 新運動：善用手機。
  2. Attending Classes and Labs are mandatory. 上課及實習課是學生的被要求的本分。
  3. If you need to come in late or leave earlier, do not interrupt the class or disturb your classmates.
  4. There is no stupid question! Please ask if you cannot follow me.
  5. NO MAKEUP EXAM! 不接受補考。
  6. NO LATE ASSIGNMENTS! 不接受逾期作業。
  7. Class Etiquette Rules 「教室禮儀」

Topics & Class Notes:

Week 資管二B 資管二A Topic Class Notes Reading Assignment & Reference Website Practice
1 2/20 2/22

Syllabus

Part I: DATABASE CONCEPTS

2. Data Models

 https://tronclass.pu.edu.tw (靜宜大學玩課雲 WOW Class)

 

 Questions:
  1. What is a database?
  2. What are the Advantages of a DBMS?
  3. What types of Databases are there?
  4. Problems with File System Data Processing

Questions:

  1. Importance of Data Models
  2. Data Abstraction Levels
  3. What are the three parts involved in any SQL-based relational database application?
2

2/27

 2/29

2. Data Models

Part II: DESIGN CONCEPTS
3. The Relational Database Model

為線上電影租借平台設計資料庫模型，該平台必須能記載會員的影片租借記錄。
3 3/5 3/7

Part II: DESIGN CONCEPTS
3. The Relational Database Model

4. Entity Relationship (ER) Modeling

 Assignment 1 due

為大學的修課系統設計 ER model
4 3/12 3/14 4. Entity Relationship (ER) Modeling

Quiz 1

 

others
5 3/19 3/21


6. Normalization of Database Tables

 Assignment 2 due
6 3/26 3/28

6. Normalization of Database Tables

5. Advanced Data Modelinge

 Assignment 3 due
7 4/2 4/4(放假)

5. Advanced Data Modelinge

  
8 4/9 4/11

5. Advanced Data Modeling

review

Assignment 4 due

Quiz 2

    
9 4/16 4/18

Midterm Exam
  • 資管二B: 4/16, 13:10pm-15:00pm
  • 資管二A: 4/18, 9:10am-11:00am
  
10 4/23 4/25

Part III: ADVANCED DESIGN AND IMPLEMENTATION
7. Introduction to Structured Query Language (SQL)

The Try-SQL Editor (無廣告)

SQL online
11 4/30 5/2

8. Advanced SQL
12 5/7

5/9

(校務評鑑)

8. Advanced SQL

資料庫安全： 1-1資安事件與資料管理規範介紹
13 5/14 5/16

Part IV: ADVANCED DATABASE CONCEPTS
10. Transaction Management and Concurrency Control

資料庫安全：1-3資料庫系統環境簡介
14 5/21 5/23

11. Database Performance Tuning and Query Optimization

Assignment 5 due

Quiz 3
15 5/28 5/30

13. Business Intelligence and Data Warehouses

資料庫安全： 2-1隱碼攻擊

Review
16 6/4 6/6

Final Exam

  
17 6/11 6/13

課程回顧(線上課程)

  

 
18    

(線上課程)

Open Data

政府開放資料範例：

  

Assignments:

  1. Assignments MUST be submitted via https://tronclass.pu.edu.tw (靜宜大學玩課雲 WOW Class).
  2. Again, NO LATE ASSIGNMENT will be accepted.
Assigment Content 資管二B
Due Date		 資管二A
Due Date
Assignment 1: Self-Introduction with Goals and Objectives (3 points)
  • Please provide one or two paragraphs of your self-introduction.
  • Please provide your one-year, three-year and ten-year goals and objectives.
    • Goals are the broad results that you want to achieve, the "destination" of your work.
    • Objectives are the smaller steps that take you toward your goals, a "road map" to guide you to your destination. Without a destination and a map to reach it, you won't get too far.
  • Please provide your printed/digital photo.
  • Name your homework as
    • 1112DBM-Assignment1.副檔名 (.doc, .ppt, .pdf, .html, etc.)
  • Upload your assignment to https://tronclass.pu.edu.tw (靜宜大學玩課雲 WOW Class)
  • Again, NO LATE ASSIGNMENT will be accepted.
  • Example: 1122DBM-Assignment1.htm
3/5, 11PM 3/7, 11PM
Assignment 2: Data Models (3 points) 3/19, 11PM 3/21, 11PM
Assignment 3: ER Modeling (3 points) 3/26, 11PM 3/28, 11PM
Assignment 4: Normalization of Database Tables (3 points) 4/9, 11PM 4/11, 11PM
Assignment 5: Structured Query Language (SQL) (3 points) 5/21, 11PM 5/23, 11PM

Quiz:

Quiz Content 資管二B 資管二A
Quiz 1: (5 points)
  • Quiz will cover
    • 3. The Relational Database Model
    • 4. Entity Relationship (ER) Modeling
  • Draw the database model in Chen’s Model or Crow’s Foot Model
  • 紙筆作答
 3/12 3/14
Quiz 2: (5 points)
  • Quiz will cover
    • 6. Normalization of Database Tables
  • normalize database table
  • 紙筆作答
 4/9 4/11
Quiz 3: (5 points)
  • Quiz will cover
    • 7. Introduction to Structured Query Language (SQL)
    • 8. Advanced SQL
  • 紙筆作答
 5/21 5/23

Midterm Exam:

  • Midterm exam will be in the 9th week's class
    • 資管二A: 4/18, 9:10am-11:00am
    • 資管二B: 4/16, 13:10pm-15:00pm
  • Midterm exam will cover
    • 1. Database Systems.
    • 2. Data Models.
    • 3. The Relational Database Model.
    • 4. Entity Relationship (ER) Modeling.
    • 6. Normalization of Database Tables.
  • Exam Questions: True/False Questions, Multiple Choice Questions, Filling Questions, and Short Answer Questions.
  • Sample questions:
    • True/False, Multiple Choice, and Filling question samples can be download at https://tronclass.pu.edu.tw (靜宜大學玩課雲 WOW Class)
    • Ch2 Problems: #4, #5, #6, #7, #8, #13, #14, #15
    • Ch3 Review Questions: #14, #18~ #21
    • Ch3 Problems: #10, #11, #12, #17~#23
    • Ch4 Review Questions: #5, #17~#21
    • Ch4 Problems: #1, #4
    • Ch6 Review Questions: #6, #7, #8
    • Ch6 Problems: #4, #6, #8, #9
  • It is a open-book exam.

Final Exam:

  • Final exam will be in the 17th week's class
    • 資管二A: 6/6, 9:10am-11:00pm
    • 資管二B: 6/4, 13:10pm-15:00pm
  • Final exam will cover
    • 7. Introduction to Structured Query Language (SQL).
    • 8. Advanced SQL.
    • 10. Transaction Management and Concurrency Control.
    • 11. Database Performance Tuning and Query Optimization
    • 13. Business Intelligence and Data Warehouses.
  • Exam Questions: True/False Questions, Multiple Choice Questions, Filling Questions, and Short Answer Questions.
  • Sample questions:
    • Ch7 Problems: #26~#43 (based on Ch07_SaleCo.mdb)
    • Ch8 Problems: #19~#22 (based on Ch08_LargeCo.mdb)
    • Ch11 Problems: #1~#3
  • It is an ONLINE open-book exam.

George Yeh 宣言

正念、利人；慈悲、同理。 智慧、康健；觀心、篤行。

反核、愛台灣

尊重著作權、注意隱私權

2020 All rights reserved.