Week |
Class | Topic | Due | Where | ||||
---|---|---|---|---|---|---|---|---|
0 | 0. Computer Career and Data Research & Technologies | |||||||
0.1 A computer career | ||||||||
0.2 Data research | ||||||||
0.3 Data technologies | ||||||||
1 | 08/22 08/24 |
1. Introduction to DATA 520 | ||||||
1.1 Course outline | ||||||||
1.2 Introduction to databases | ||||||||
1.3 Software to be used | ||||||||
2 | 08/29 08/31 |
2. Programming Exercise I | ||||||
2.1 Specifications | ||||||||
2.2 A sample website | ||||||||
2.3 Construction steps | ||||||||
08/30 |
Last day to add a course or drop without record Last day to add audit or change to/from audit Last day to receive a refund on a dropped class Drops after the last day to add will appear on a transcript. |
|||||||
3 | 09/05 09/07 |
3. Internet-Enabled Database Construction | ||||||
3.1 User interfaces | ||||||||
3.2 Functional modules | ||||||||
3.3 Databases | ||||||||
4 | 09/12 09/14 |
4. Essential Technologies for Exercise Construction | ||||||
4.1 Client-server architecture | ||||||||
4.2 CGI (Common Gateway Interface) | ||||||||
4.3 Oracle databases | ||||||||
5 | 09/19 09/21 |
5. HTML (HyperText Markup Language) | ||||||
5.1 Introduction to HTML | ||||||||
5.2 HTML tags | ||||||||
5.3 HTML input forms | ||||||||
6 | 09/26 09/28 |
6. Web-JDBC Programming | ||||||
6.1 GET and POST methods | ||||||||
6.2 CGI forms and input fields | ||||||||
6.3 CGI radio buttons and checkboxes | ||||||||
7 | 10/05 | 7. Web-JDBC Programming (Cont.) | ||||||
7.1 Database connection | ||||||||
7.2 Query execution | ||||||||
7.3 Processing the result sets | ||||||||
10/03 |
|
|||||||
8 | 10/10 10/12 |
8. Relational Model and Algebra | ||||||
8.1 Relational tables | ||||||||
8.2 Relational rules | ||||||||
8.3 Relational algebra | ||||||||
9 | 10/17 10/19 |
9. SQL Query Language | ||||||
9.1 Introduction to SQL | ||||||||
9.2 Data definition commands | ||||||||
9.3 Data manipulation commands | ||||||||
10 | 10/24 10/26 |
10. Database Design | ||||||
10.1 Basic modeling concepts | ||||||||
10.2 Entity-relationship (E-R) model | ||||||||
10.3 Transformation rules | ||||||||
11 | 10/31 11/02 |
11. Android Mobile Operating System | ||||||
11.1 Programming Exercise III | ||||||||
11.2 Downloading and installing Android Studio | ||||||||
11.3 Android programming | ||||||||
12 | 11/07 11/09 |
12. An Android Hello-World Project | ||||||
12.1 Manifest file | ||||||||
12.2 Layout XML code | ||||||||
12.3 Java source code | ||||||||
11/09 |
Last day to change to or from S/U grading Last day to change to or from audit grading Last day to drop a full-term course or withdraw from school |
|||||||
13 | 11/16 | 13. Android User Interface Processing | ||||||
13.1 Hypertext | ||||||||
13.2 Radio buttons | ||||||||
13.3 Checkboxes | ||||||||
11/14 |
|
|||||||
14 | 11/21 | 14. Android Server Connection | ||||||
14.1 Android URL connection | ||||||||
14.2 Java source code | ||||||||
14.3 Server-side scripts | ||||||||
11/22 11/23 11/24 |
|
|||||||
15 | 11/28 11/30 |
15. SQL Query Language (Cont.) | ||||||
15.1 Advanced data manipulation commands | ||||||||
15.2 SQL examples | ||||||||
15.3 Power of SQL | ||||||||
16 | 12/05 12/07 |
16. Database Design (Cont.) | ||||||
16.1 Normalization | ||||||||
16.2 Normal forms | ||||||||
16.3 A case study | ||||||||
17 | 12/12 |
|
||||||
18 | 12/19 | Grades posted before noon, Tuesday |
If it’s not one thing, it’s another. |