ITM345-Summer 2016
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
#WDate TopicsPart I (1:30 - 2:30 pm)Part II (2:45 -3:45 pm)Assignments*
2
1M05-23-2016INTROIntroduction to Course StructureIntroduction to Data System (A1)Create an account with Google Classroom
3
2W05-25-2016OPERATIONAL DATABASESDatabase Requirements and ER Modeling (A2) MC I: ER ModelingMini Case Study I (10%) by 6/1
4
3F05-27-2016Relational Database Modeling (A3)MC II: Relational schemaMini Case Study II (10%) by 6/3
5
-M05-30-2016Holiday: Memorial Day (non-instructional day)
6
4W06-01-2016Update Operations, Update Anomalies, and Normalization (A4)Review Appendix A, Enhanced ER and B, Higher Normal Forms
7
5F06-03-2016SQLSQL (A5) -- Part ISQL Intro LabLab Assignment I (20%) by 6/13
8
6M06-06-2016SQL (A5) -- Part IISQL Intro Lab
9
7W06-08-2016SQL (A5) -- Part IIITransformation in SQLLab Assignment II (15%) by 6/15
10
-F06-10-2016Holiday observed: Kamehameha Day (non-instructional day)
11
8M06-13-2016Database Implementation and Use (A6)MC III: Oracle SQLMini Case Study III (10%) by 6/20
12
9W06-15-2016ANALYTICAL DATABASESData Warehousing Concepts (A7)Review Appendix C, Enterprise Resource Planning (ERP)
13
10F06-17-2016Datawarehouse and Datamart Modeling (A8)MC IV: Analytical databaseMini Case Study IV (10%) by 6/24
14
11M06-20-2016Reverse Engineering a Data Model (Case of Aloha 2Go)Designing a Data Warehouse to Analyze Business MetricsLab Assignment III (15%) by 6/29
15
12W06-22-2016Data Warehouse Implementation and Use (A9)Analyzing Business Metrics with SQLReview Appendix D, Data Governance and Master Data Management
16
13F06-24-2016DATA ADMINISTRATION DBMS Functionalities and Database Administration (A10)
Distributed Databases, Parallel Databases, and Cloud Computing (AF)
Review Appendix F, Distributed Databases, Parallel Databases, and Cloud Computing + eCafe Survey
17
14M06-27-2016Security and Administration Transparencies (B20)Review Appendix G, Data Mining
18
15W06-29-2016
Professional, Legal, and Ethical Issues in Data Management (B21)
Developing an Audit Program (Case of UH registration Office)eCafe Survey
19
16F07-01-2016NOSQLSemistructured Data and XML (B30)NOSQL DBMS & Big Data Storage (C23)Review Appendix H, XML
20
21
Lectures
22
Lab Activities: Mini Cases
23
Lab Activities: Codecademy/Groupwork
24
Readings
25
26
A
Database Systems: Introduction to Databases and Data Warehouses, By Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov, Published by Pearson Copyright © 2014
27
B
Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, By Thomas Connolly, Carolyn Begg, Published by Pearson Copyright © 2015
28
C
Fundamentals of Database Systems, 6th Edition, By Ramez Elmasri, Shamkant B. Navathe, Published by Pearson Copyright © 2016
29
30
*
20% penalty for any late submission
31
32
ver.
Last update: 7/1/16
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu