| Relevance of Course Objectives and Core Learning Outcomes(%) |
Teaching and Assessment Methods for Course Objectives |
| Course Objectives |
Competency Indicators |
Ratio(%) |
Teaching Methods |
Assessment Methods |
1.Establish a basic understanding of database systems
2.Ability to operate databases using Structured Query Language (SQL)
3.Ability to use Tableau for data visualization |
| 1.Critical Thinking |
| 4.Innovation |
| 5.Leadership |
| 6.Independent Problem-Solving |
|
|
| Exercises |
| Discussion |
| Lecturing |
|
| Written Presentation |
| Attendance |
| Oral Presentation |
| Quiz |
| Internship |
|
| Course Content and Homework/Schedule/Tests Schedule |
| Week |
Course Content |
| Week 1 |
Course Overview |
| Week 2 |
DB System Concepts and Architecture |
| Week 3 |
Relational Data Model |
| Week 4 |
SQL I |
| Week 5 |
SQL II |
| Week 6 |
SQL III |
| Week 7 |
Midterm Exam Review |
| Week 8 |
Midterm Exam |
| Week 9 |
Tableau Workshop |
| Week 10 |
Entity-Relationship Model |
| Week 11 |
Index Structures; Database Design Informal Guidelines |
| Week 12 |
Database Normalization |
| Week 13 |
Final Project Presentation |
| Week 14 |
Final Project Presentation |
| Week 15 |
Final Exam Review |
| Week 16 |
Final Exam |
self-directed
learning |
02.Viewing multimedia materials related to industry and academia.
03.Preparing presentations or reports related to industry and academia.
SQL online practice & Final project report submission |
|
| Evaluation |
- Class participation(10%)
- Midterm exam(27.5%)
- Final Exam(27.5%)
- Group final project (35%)：Students are free to choose topics they’re interested in for database design, including drawing ER Models, basic SQL operations, and data visualization (using Tableau). |
| Textbook & other References |
| Database Systems Design, Implementation, and Management, 14/e, Cengage, 2023, By Coronel & Morris. |
| Teaching Aids & Teacher's Website |
| 自製教材，將於每周上課前上傳至iLearning |
| Office Hours |
| Tuesday 10:00~12:00 |
| Sustainable Development Goals, SDGs(Link URL) |
| include experience courses：N |
|