Courses:

• Very basic Introduction to SQL
• More on SQL
• Even more on SQL
• More detail regarding the Oracle implementation of SQL from the UC Davis Database site: http://www.db.cs.ucdavis.edu/teaching/sqltutorial/
• A good, short book on SQL: Forta, Ben. Sams Teach Yourself SQL in 10 Minutes

Conceptual Modeling & UML

• Brief Introduction to Conceptual Graphs
• Conceptual graph examples
• Paper on tradeoff in the modeling of large clinical databases. Johnson, Stephen B. "Generic Data Modeling for Clinical Repositories." Journal of the American Medical Informatics Association 3 (5) (Sept-Oct 1996).
• Introduction to UML  the most commonly used conceptual modeling formalism

Homework 2 (PDF)

Below are files associated with Homework 2:

• index.jsp
• pt.jsp
• SqlAccess.java
• Entity.java
• EnglishName.java

Homework 3 (PDF)

Homework 3 Addenda

• Census Data
  
  The original source of the name frequency tables is the U.S. Census Bureau, at the following address: http://www.census.gov/genealogy/names/. The commercial company Hamrick provides an interesting interface that gives geographical distributions of names in the U.S. at http://www.hamrick.com/names/.
  
  One way to access the data on Singapore would be to extend the programs you had built for HW2. 
  
  
• Approach to Answering Questions
  
  Note that many of the questions in this homework ask you to design some method or to estimate something for which none of us is likely to have actual knowledge. I would like you to give actual numerical estimates in order to make sure you have thought through the problem, but you need to explain how you arrived at these in order to let us see your design or deduction process, because we have no way to check the accuracy of the number itself.

Java^® is a trademark or registered trademark of Sun Microsystems, Inc. in the United States and other countries.