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/27 08/29 |
1. Introduction to CSCI 513 | ||||||
1.1 Course outline | ||||||||
1.2 Databases to build | ||||||||
1.3 Software to be used | ||||||||
2 | 09/03 09/05 |
2. Programming Exercise I | ||||||
2.1 Specifications | ||||||||
2.2 A sample website | ||||||||
2.3 Construction steps | ||||||||
09/04 |
Last day to add a course or drop without record — 100% refund 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/10 09/12 |
3. Essential Technologies for Exercise Construction | ||||||
3.1 HTML (Hypertext Markup Language) | ||||||||
3.2 CGI (Common Gateway Interface) | ||||||||
3.3 Using Oracle | ||||||||
4 | 09/17 09/19 |
4. Database Models | ||||||
4.1 Relational databases | ||||||||
4.2 Object-oriented databases | ||||||||
4.3 Website construction summary | ||||||||
5 | 09/24 09/26 |
5. Oracle Databases | ||||||
5.1 Oracle SQL*Plus | ||||||||
5.2 Oracle data dictionary | ||||||||
5.3 SQL (Structured Query Langauge) | ||||||||
6 | 10/01 10/03 |
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/10 | 7. JDBC Programming | ||||||
7.1 Database connection | ||||||||
7.2 Query execution | ||||||||
7.3 Processing the result sets | ||||||||
10/08 |
|
|||||||
8 | 10/15 10/17 |
8. Introduction to Android Programming | ||||||
8.1 Programming Exercise II | ||||||||
8.2 Android introduction | ||||||||
8.3 An Android hello-world project | ||||||||
9 | 10/22 10/24 |
9. Android User Interface Processing | ||||||
9.1 Hypertext | ||||||||
9.2 Radio buttons | ||||||||
9.3 Checkboxes | ||||||||
10 | 10/29 10/31 |
10. Android SQLite Database | ||||||
10.1 Using SQLite | ||||||||
10.2 SQLite shell commands | ||||||||
10.3 SQLite in Android | ||||||||
11 | 11/05 11/07 |
11. An Android SQLite Project | ||||||
11.1 SQLite data declaration | ||||||||
11.2 SQLite data management | ||||||||
11.3 An SQLite example | ||||||||
12 | 11/12 11/14 |
12. Oracle Object-Relational SQL | ||||||
12.1 Object types, tables, and references | ||||||||
12.2 Constructor methods | ||||||||
12.3 Data dictionary and objects | ||||||||
11/15 |
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/21 | 13. Oracle PL/SQL | ||||||
13.1 Control structures | ||||||||
13.2 Cursors | ||||||||
13.3 Procedures and functions | ||||||||
11/19 |
|
|||||||
14 | 11/26 | 14. Oracle Object-Relational SQL (Cont.) | ||||||
14.1 Nested tables | ||||||||
14.2 VARRAY (varying-length array) |
||||||||
14.3 Methods | ||||||||
11/27 11/28 11/29 |
|
|||||||
15 | 12/03 12/05 |
15. Object-Oriented DBMSs | ||||||
15.1 A non-relational representation | ||||||||
15.2 Object-oriented properties | ||||||||
15.3 Object-oriented database properties | ||||||||
16 | 12/10 12/12 |
16. Object-Oriented DBMSs (Cont.) | ||||||
16.1 A DBMS classification matrix | ||||||||
16.2 Aspects of OODB languages | ||||||||
16.3 OODB language features | ||||||||
17 | 12/17 |
|
||||||
18 | 12/24 | Grades posted before noon, Tuesday |
If it’s not one thing, it’s another. |