CSC 319 - Fall 2001-2002

Announcements:

• FINAL: - Monday, Nov 19^th @ 5:45pm. Remember to review the tutorial problems and solutions. Also, see the Q5 solutions.
• Reminder: The second half of the class session on Monday, 11/12 will be a tutorial. Remember that the tutorial is optional and is intended for students who would like extra help preparing for the final exam.
• Quiz #5 will be on Mon, 11/12. Review the ER Model I, ER Model II, and the Model Transformation lecture notes. Remember to review the readings from the text indicated in the notes. Sample problems and solutions are available.
• Reminder: We will not have a quiz on Mon, 11/5. Quiz #5 (last quiz for the quarter) will be on Mon, 11/12. Remember that the lowest two quiz scores will be dropped.
• Quiz #4 will be on Mon, 10/29. Review Subqueries, Outer Join, and Changing Data (see Chapter 9, pg 244-245, 247-248, 250-251 and the SQL III lecture notes). Remember that the lecture notes provide a more extensive treatment of Outer Join than the text, so make sure that you review the lecture notes. Work problems 9.18, 9.21 (use SQL92 syntax), 9.25 - 9.31. Solutions are available. Additional practice problems and solutions are also available.
• Quiz #3 will be on Mon, 10/22. Review Sorting (see SQL I, page 241 of text), Grouping and Basic Join (see SQL II, page 242, 246 of text). Also, review the lecture notes on Renaming (see SQL III). Work problems 9.9, 9.14, 9.17, 9.19 on pages 252-253 of the text. Solutions are available. Here are additional practice problems.
• Note: Project #1 may be turned in on 10/22 without penalty.
• Note: For SQLServer E-commerce lab users. To get to SQL Server follow the menu options from the Start button as follows:
  Start -> Programs -> MS SQL Server -> Query Analyzer
  You will then be presented with a dialog box. Use vaughn.cs.depaul.edu for the SQL Server entry and the login name and password that you got from me. Also, remember to select the pubs database from the dropdown list box on the menu bar.
• Reminder: For SQLServer E-commerce lab users. The pubs database already exists and so you do not need to create the database or the tables. However, do not be surprised if the data is not quite the same as the raw data provided below. Remember that this is a shared resource and so users have the ability to modify the data. If this is the case you may get slightly different results than your classmates.
• Note: If you choose to use MSAccess, notice the details below.
• Note: Accounts and passwords for SQLServer (E-commerce lab) are now available. If you have not been notified by email contact me (phone or email) to receive your account. Remember that the lab is on the 7^th floor of the CTI building and is open from 10:00am to 10:00pm (M-F); 10:00am to 6:00pm (Sat); 12:00noon to 6:00pm (Sun). Classes are sometimes scheduled in the lab so it is not always open. I am providing short demos of SQLServer on an individual basis so contact me if you need a demo.
• The lab session scheduled after the Midterm on Mon, 10/8 has been cancelled.
• Midterm: Monday, Oct 8^th @ 5:45pm.
• See the SQL Server 2000 note below for SQL Server 2000 options.
• Quiz #2 will be on Mon, 10/1. Review the Relational Algebra lecture notes (i.e. set I and set II - Join section only). Also, review Chapter 8, pg 221-229 of the text (skip the Outer Join section on pg 227). Review worked problems 1 - 5 on pg 228 - 229. Work problems 8.20 - 8.26 on pg 232 and 8.27, 8.28a - 8.28e on pg 233. Solutions are available.
• The due date for Project #1 is now 10/15.
• Reminder: We will not have a quiz on Mon, 9/24. Quiz #2 will be on Mon, 10/1.
• Quiz #1 will be on Mon, 9/17. Review the Set Theory and Logic lecture notes. Practice problems and solutions are available.
• Lecture Notes and Readings have been updated to include references to the 8^th edition of the text.

Note: We will have weekly quizzes starting week 2. The first project will be handed out week 3.

• Syllabus
• Readings
• Lecture Notes
• Projects
  Note: The SQL Server 2000 CD should install without problems on Windows NT (SP5 required). However, you may encounter problems with ME and 98.
  Alternatives to SQL Server 2000:
  • MS Access is available in all CTI Labs. Here is a tutorial if you need a refresher. Remember that you will need to create the required tables and import the data (click on the links for each table).
  • SQL Server 2000 is available in the CTI E-Commerce lab. If you plan to use this option please submit your name to me by noon, Mon, 10/1. If you are working in a group then submit one name only from your group. Access details will be discussed in class on Mon, 10/1.
  • You may download MySQL from this site. The download file is a 12MB zipped file. MySQL is free under the GNU General Public Licence (GPL).
    Note: If you choose this option, you will have to create and load the tables mentioned in the assignment. Raw data is available as ascii text at this link. DDL to create the tables is available at this link. See the MySQL online documentation for bulk load instructions using the LOAD DATA command.
  • SQL Server v7 installs without problems on NT, 98, and ME. You may use this version if you are able to locate it. I have an installation CD and will try to get additional CD's by Mon, 10/1.
  • The 120 day downloadable evaluation copy of SQL Server 2000 works with NT only (SP5 required).