Q: I am auditing the class. Can I still turn in the projects and homeworks and have the TAs evaluate them?
A: Unfortunately due to time constraints for the TAs, we can't evaluate the projects and homeworks of auditors; auditors should not turn them in at all. You can participate in review sessions if you like, and feel free to come to office hours and ask us questions about the project or homework but keep in mind that registered students should receive first priority.
Q: I tried to log on to Oracle, but was denied access. What did I do wrong?
A:We have not yet set up the Oracle accounts for students, but are planning to do so shortly. We need all registered students to register online in order to give you accounts. All auditors should send an email directly to firstname.lastname@example.org if they wish to open an Oracle account. Accounts should be ready by Monday, April 16, and we will announce when they are ready for access.
Q: I'm having trouble coming up with ideas for the project. Can you give me any advice?
A:First, you might try looking at last year's winning projects to get an idea of the scope of the project. Also, feel free to visit any of the course staff during office hours if you are having trouble getting started.
Something to consider: recall that ultimately you will be creating a web interface for your database. Hypertext can lend itself especially well to viewing data as a graph and exploring it by browsing through links to related information. Take a look at the Internet Movie Database for a good example -- each movie lists links to actors, director, writers, and so forth, which, in turn, have links to other movies they were involved in. Think about other data that might be similarly structured.
You could also choose to build a database that allows for deeper analysis of data than simple listing of relational links. One example might be the Census Bureau's International Database, which allows you to rank, make comparisons, and view different timespans and types of data for different countries demographic statistics.
You could also consider a database that lends itself to electronic commerce, though a great deal of infrastructure that would be necessary for such an application (such as security, credit card transactions, and web sessions) won't be covered (that's not to say that you couldn't try and figure it out yourself, though!). An example of this might be Amazon.com (Amazon is also a great example for a couple of other cool analytical tricks, like determining what books a user might want to purchase based on the purchasing habits of similar customers, and so on).
Or you could consider something fun and interactive (as opposed to just browsing pre-constructed datasets), like "Am I Hot or Not?".