Information is the currency of the Information Age, but having vast quantities of information is useless if you cannot quickly locate the relevant data. Computer databases are used to store, organize, and retrieve information in a useful way. Databases are extremely common, particularly in conjunction with Web sites - if you've ever used amazon.com, eBay, or HWS' library catalog (to name just a few sites), you've interacted with a database.
The goal of this course is to provide an introduction to the theory and practice of relational databases. Three major aspects of relational databases will be addressed: designing, implementing, and querying a database; building a Web site which interacts with a database; and understanding how database systems store and process information reliably, securely, and efficiently. Both practical skills and the necessary theoretical underpinnings will be emphasized.
M 1:30-2:30pm, T 2:30-3:30pm, W 4:00-5:00pm, F 9:30-10:30am
|Class Hours and Meeting Place||
Lecture/discussion MWF 3:00-3:55pm, Lansing 300
Some meetings will be in the Lansing 310 computer lab; these will be announced in advance.
(general information about the course, including assessment)
(course policies on attendance, collaboration, late/makeup work, and other things)
(syllabus, including links to handouts, assignments, reading material...pretty much everything you want on a daily basis is here)
(reference materials for MySQL)
(everything you need to know about the term project)
[12/5] A list of review topics and sample problems for the final exam has been posted.
[11/29] Solutions for the second midterm have been posted.
[11/29] What is expected for the alpha release of the project: get at least some part of your project implemented, which involves at least one dynamically-generated page resulting from a query. You may need a few additional pages to get to that point (e.g. the main entry page with a menu, and the page(s) to implement one of the menu options). What to hand in: use ant handin to create a zip file for the web application, then copy the zip file to the handin directory as directed in the project information page. You only need to hand in one copy per group.
[11/16] Solutions for homework #6 have been posted.
[11/15] Solutions for homework #5 have been posted. Solutions for homework #6 will be posted soon.