Topic outline
- General
General
- Week 1
Week 1
Monday, September 5
Results of a survey related to COBOL.
Tuesday, September 6
Read section 9.2 of Rosen (quickly) and hand in problems 10, 14, 18, 19, 28 from section 9.2. Due Thursday at 9:30.
A Relational Model of Data for Large Shared Data Banks
Wednesday, September 7
Imagine tracking client contacts in the table you built in Tuesday's lab. This would exhibit the kind of redundancies we discussed in class on Monday, and would be subject to all sorts of modification anomalies. Fixing that architecture is the purpose of today's lab.
Thursday, September 8
Friday, September 9
The Entity-Relationship Model--Toward a Unified View of Data
Monday, September 12
Tuesday, September 13
Wednesday, September 14
Exam 1 is from 9 to 11 in our Law 113 lab classroom
- Week 2
Week 2
Thursday, September 15
you should spend 45 minutes each of the next 2 days going through these tutorials--
Pay special attention to K--this is a trick you will need to know
Friday, September 16
Monday, September 19
Transactions, Constraints, Triggers, Views, Indices
Tuesday, September 20
Extra coverage of Views on pp. E1 - E16
Introduction to php/MySQL n-tier systems lab
See http://www.w3schools.com/sql/sql_injection.asp for an explanation of this comic.
Wednesday, September 21
PHP/MySQL n-tier lab and assignment
- Week 3
Week 3
Thursday, September 22
Java client/server lab
Friday, September 23
Exam 2 is from 9 a.m. to 11:30 a.m. in our Law 113 Lab/classroom
Monday, September 26
Highly recommended, again from W3 schools
This is hidden under W3 schools Javascript tutorial. I wonder why?
Tuesday, September 27
- Week 4
Week 4