SemesterFall Semester, 2018
DepartmentMA Program of Management Information Systems, First Year
Course NameData Models
InstructorCHOU YEN-CHUN
Credit3.0
Course TypeRequired
PrerequisiteDatabase Management、Database Management System、Database Management Systems
Course Objective
Course Description
Course Schedule

Tentative schedule























































































Topic



Schedule



Part 1: Foundation of Database



 



1. Introduction



W1



2. Relational model & ER model



W2



3. Entity relational model



W2 & W3



4. Design of relational database



W4



5. Database definition (DDL) and Physical design (index)



W5



6. Project 1 presentation & Physical design: index



W6



7. Physical design: index & Database queries-part 1



W7 & W8



8. Query performance



W9



9. Transactions: concurrency & recovery



W10



10. Project 2



W12



Part 2: Data warehouse and Big Data



 



11. Overview of data warehouse



W11 & W13



12. Multidimensional data modeling



W13



13. Database queries-part 2


W14

14. NoSQL Introduction



W15



15. Big data overview-IBM



W16



16. Final review



W17



17. Final exam



W18



Teaching Methods
Teaching Assistant

TBD


Requirement/Grading

Exams (24%): final (120 points)



Individual Assignments (27%): 2 take-home assignments and random in-class quizzes



Group Project (45%):  DBMS introduction (50 points), database system implementation (100 points) and data warehouse design (75 points)



Class Participation (4%): class interaction and attendance 


Textbook & Reference

- A First Course in Database Systems, by J.D. Ullman and J. Widom, 3rd Edition, Pear-son/Prentice Hall, 2007.



- Database Processing: fundamentals, Design, and Implementation, by D. M. Kroenke and D. J. Auer, 13th Edition, Pearson Education, Harlow, England, 2014.



- 資料庫的核心理論與實務, by 黃三益, 5th Edition, 前程文化, 2012.



- The Data Warehouse Toolkit: the complete guide to dimensional modeling, By R. Kimball and M. Ross, 3rd Edition, Wiley, 2013.


Urls about Course
Attachment