Tentative Schedule


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 DATA 520    
  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. Internet-Enabled Database Construction    
  4.1 Technologies for website building    
  4.2 Website construction summary    
  4.3 An example    
5 09/24
09/26
5. Oracle Databases    
  5.1 Oracle Database 21c    
  5.2 Oracle SQL*Plus    
  5.3 Oracle data dictionary    
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 EX I  
7 10/10 7. JDBC Programming    
  7.1 Database connection    
  7.2 Query execution    
  7.3 Processing the result sets    
10/08
Exam I (for both on-campus and on-line students; 06:30pm – 08:30pm, Tuesday)
   
8 10/15
10/17
8. Android Mobile Operating System    
  8.1 Programming Exercise II    
  8.2 Downloading and installing Android Studio    
  8.3 Programming Android    
9 10/22
10/24
9. An Android Hello-World Project    
  9.1 Manifest file    
  9.2 Layout XML code    
  9.3 Layout XML code    
10 10/29
10/31
10. Android User Interface Processing    
  10.1 Hypertext    
  10.2 Radio buttons    
  10.3 Checkboxes    
11 11/05
11/07
11. Android Server Connection    
  11.1 Android URL connection    
  11.2 Java source code    
  11.3 Server-side scripts    
12 11/12
11/14
12. Relational Model and Algebra    
  12.1 Relational tables    
  12.2 Relational rules    
  12.3 Relational algebra    
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. SQL Query Language    
  13.1 Introduction to SQL    
  13.2 Data definition commands    
  13.3 Data manipulation commands    
11/19
Exam II (for both on-campus and on-line students; 06:30pm – 08:30pm, Tuesday)
   
14 11/26 14. Database Design    
  14.1 Basic modeling concepts    
  14.2 Entity-relationship (E-R) model    
  14.3 Transformation rules    
11/27
11/28
11/29
Holidays, Thanksgiving Break (WeThFr) — no classes
   
15 12/03
12/05
15. SQL Query Language (Cont.)    
  15.1 Advanced data manipulation commands    
  15.2 SQL examples    
  15.3 Power of SQL    
16 12/10
12/12
16. Database Design (Cont.)    
  16.1 Normalization    
  16.2 Normal forms    
  16.3 A case study EX II  
17 12/17
Final exam (for both on-campus and on-line students; 06:30pm – 08:30pm, Tuesday)
 
18 12/24 Grades posted before noon, Tuesday    





      If it’s not one thing, it’s another.