This page documents what we do in class. It contains programs that we will discuss in class, reading assignments from our textbook, links to other sources of information, etc.
The reading assignments are listed by the date on which they were assigned. The sample program files are listed by the date on which they were used. When you are viewing a source code page, you can use your browser's "File -> Save As..." menu item to save a copy of the code on your computer. It is a good idea for you to "play" with these example programs; compile them, run them, make simple changes to them and compile and run them again.
- Thursday, December 4.
- The second exam is next Thursday, December 11, at 10:30am. The exam is on the normalization theory, Chapter 6, Sections 6.1-6.7 (pages 193-221) from the textbook. Here is a list of problems from the end of Chapter 6 (pages 246-248) that are examples of what might be on the exam.
- Chapter 6 Exercises: 6.2, 6.4, 6.8, 6.18, 6.21, 6.22, 6.26, 6.27, 6.29.
- Tuesday, December 2.
- The following zip file contains a very simple example of using Java and JDBC with MySQL, PostGreSQL and SQLite to access our SuppliersParts example from earlier in the semester.
- Tuesday, November 25.
- See the homework page for your sixth assignment.
- Read Chapter 8, Sections 8.6-8.7 (pages 307-315).
- The following zip file contains a very simple example of using C with SQLite to access our SuppliersParts example from earlier in the semester.
- Thursday, November 20.
- Read Chapter 8, Sections 8.4-8.5 (pages 286-306).
- The following zip file contains a very simple example of using PHP with MySQL to access our SuppliersParts example from earlier in the semester.
- Thursday, November 13.
- See the homework page for your fifth assignment.
- Read Chapter 8, Sections 8.1-8.2 (pages 267-285).
- Here is the documentation on
CREATE TRIGGER for each of the three database systems that we have been using.
- Tuesday, November 11.
- Here is an explanation of normalization theory that I hope is clearer than what is in most database textbooks.
- Read Chapter 7, Sections 7.1-7.4 (pages 251-265).
- Thursday, October 30.
- Read Chapter 6, Sections 6.6-6.9 (pages 211-233).
- Tuesday, October 21.
- Remember that the midterm exam is Thursday.
- Here is a sheet of review problems for the exam on Thursday.
- Here are two articles about normalization.
- Thursday, October 9.
- NOTE: The date for the midterm exam is being changed (by one week) to Thursday, October 23.
- See the homework page for your fourth assignment.
- Read Chapter 6, Sections 6.1-6.5 (pages 193-211).
- Thursday, October 2.
- See the homework page for your third assignment.
- Read Chapter 5, Sections 5.2.3-5.2.10 (pages 157-182).
- Thursday, September 25.
- Read Chapter 5, Section 5.1.2 (pages 137-147) and Section 5.2.2 (pages 154-157).
- Here is an interesting article.
- Tuesday, September 23.
- See the homework page for your second assignment.
- Read Chapter 5, Section 5.1.1 (pages 127-137) and Section 5.2.1 (pages 147-154).
- Here is a list of exercises from the end of Chapter 5 that you should look at. These are not problems assigned for a grade, but they are the kinds of problems that you might see on the midterm exam. Feel free to ask any questions that you might have about these problems.
- Chapter 5: 5.1, 5.2, 5.7, 5.8.
- Here are two nice summaries of the relational operations from the relational algebra.
- Thursday, September 18.
- Here are links to MySQL documentation concerning constraints.
- Here is a version of PostgreSQL that you can use at home. The first link is to a self-extracting portable version of PostgreSQL. Make sure that you decompress it at the root level of a drive. In the decompressed folder are two batch files to start and stop the database server (just like MySQL in the XAMPP distribution). The server has one user with username "postgres" and no password. The command line client for this database is
usbpg_v9\apps\pgsql\bin\psql.exe
- Thursday, September 11.
- The following four zip files contain scripts for trying out all of the databases we have used in class so far.
- Here are links for downloading the software for using MySQL at home.
- Tuesday, September 9.
- See the homework page for your first assignment.
- Read Chapter 4, Sections 4.2-4.5 (pages 69-95), Section 4.7.1 (pages 106-110), Sections 4.8-4.9 (pages 111-123) from the textbook.
- Here is a list of exercises from the end of Chapters 2 and 3 that you should look at while you are studying these two chapters. These are not problems assigned for a grade, but they are the kinds of problems that you might see on the midterm exam. Feel free to ask any questions that you might have about these problems.
- Chapter 2: 2.1, 2.3, 2.5, 2.6, 2.8, 2.11.
- Chapter 3: 3.6, 3.10, 3.16, 3.17, 3.18.
- Tuesday, September 2.
- Read Chapter 3 (pages 31-65) from the textbook.
- Tuesday, August 26.
- Read Chapters 1 and 2, pages 3-27, from our textbook, Database Systems: An Application-Oriented Approach.
- The following zip file contains all the sample code and databases for today's lecture.
|
|