CSCI 1270: Database Management Systems

• News
• Asgn
• Lectures
• Docs
• Grad
• Staff

Announcements!

• Project 2 up

  11.5.2009 Hi all,
  
  Over at the assignments page, we've posted up Executor. Note that the due date has changed since we've pushed the project back so much in recent weeks: it is now due Monday, November 16.
  
  Good luck!, -TA's

• Mid-term?

  10.29.2009 Hey Everyone! As promised, three to help out with FD's and normalization:

  • My Bag-O-Definitions, a 4-page pdf on definitions and examples on FD's and Normalization
  • Hideaki's Helpsession Slides
  • Last year's Midterm review suggested problems (from the book)

  You are allowed one two-sided standard letter-size sheet of notes. The choice of eyesquinty-ness of font is yours.
  
  Good luck on the Midterm on Monday, and feel free to send us any e-mails ^_^ -TA's

• Homework 4, ETL!

  10.5.2009 Hey everyone! No class next week due to Columbus Day, but we won't leave you starving for DB material!
  
  On the assignments page, we've now posted Homework 4, as well as your first programming project: ETL and Database Design. The programming project has plenty of steps (we also give you three weeks to complete it), so please do not start at the last minute!
  
  Also bear in mind that this is the first time this project goes out, so if you encounter any bumps along the way (there shouldn't be too many) or otherwise have constructive feedback, please let us know.
  
  Good luck, and enjoy your week off from lecture!
  
  -TA's

• Homework 3, Recitations!

  9.29.2009 -

  Hey all, Homework 3 is up on the Assignments page. Also, new to CS127 this year: Recitations!

  Recitations are a way to go over some things that are too tedious/laborious to go through in lecture, but still important. We'll also use recitations for a few topics that have historically tripped up CS127 students.

  Recitation has passed, but here are teh codez:

  import java.sql.*;
  
  public class SQL {
  
  
  	public static void main(String[] args) {
  
  		try {
  			Class.forName("org.postgresql.Driver");
  			Connection dbConnection = DriverManager.getConnection("jdbc:postgresql://csci1270/sudoku","cs127student","cs127student");
  			PreparedStatement statement = dbConnection.prepareStatement("select * from allsolutions where sol_id=?;");
  			statement.setInt(1,206);
  
  			ResultSet results = statement.executeQuery();
  			
  			boolean rows = false;
  			while(results.next()) {
  				rows = true;
  				System.out.println("We've got a "+
  				"solution number " +
  				results.getInt("sol_id") +
  				" with the location " +
  				results.getInt("location") +
  				" and number "+
  				results.getInt("number"));
  			}
  
  			if(!rows) { System.out.println("No results");}
  
  			statement.close();
  			dbConnection.close();
  		}
  		catch (SQLException sqlE) {
  			sqlE.printStackTrace();
  			System.err.println("Failed due to bad SQL");
  		} catch (ClassNotFoundException e) {
  			System.err.println("You don't have /course/cs127/lib/postgres... on your build path.");
  		}
  	}
  
  }

  How Recitations Work

  Recitations operate like labs traditionally work in other classes: we oversee you doing a short set of excercises, and grading of recitation work consists only of us 'checking you off.'

  Recitation sessions are not mandatory to attend, but as the missive notes, work from recitations will be part of your grade. If you do not attend a recitation, you have up to a week after the recitation date to visit a TA on hours and get checked off for the work. After one week, we won't accept recitation work (barring extreme circumstances).

  We post the recitations on the website before the actual lab date, giving you an opportunity to look it over, and in many cases, complete the assignment before arriving.

  CS127 will have four recitations: SQL, Functional Dependencies, B-Trees, and Concurrency/Logging. See the Assignments page for the dates.

  If you have any questions, feel free to shoot us an e-mail. As always, thanks for being great students ^_^

  -TA's

• Homework 2 up!

  9.21.2009 - Now on the Assignments page (or here, save the click!), Homework 2! -TA's

• Handing in Homework 1

  9.16.2009 - To hand in Homework 1, cd into the directory where your files are located (we only want a pdf for this assignment), and type

  /course/cs127/bin/cs127_handin hw1

  The script will alert you on success! Alternatively, you can email your pdf to TAs when you can't access departmental machines (e.g., out of town for a conference), but please do so only when you absolutely have to.
  
  Thanks
  -TA's

• Homework 1 up!

  9.14.2009 - Now on the Assignments page (or here, save the click!), Homework 1! -TA's

• Everything PDF! Learn to Love LaTeX

  9.9.2009 - Since we're going paperless this year with our homeworks, learn all you need to know on producing PDF files, with a special focus on LaTeX! If you don't know it, this is a great opportunity to learn! -TA's

• Welcome to CS127

  9.3.2009 - Welcome to CSC1270: Database Management Systems! The course textbook is Database Systems Concepts, Fifth Edition by Silberschatz, Korth, and Sudarshan.ISBN: 0-07-295886-3.
  
  The course is every Monday, 3:00-5:20, Room 367 of the CIT. The first class is this coming Monday, September 14th. Stop on by!
  
  The website is again glorious! -TA's