Courses/CS 122/Summer 2009

From CSWiki

Jump to: navigation, search

Contents

[edit] General Information

[edit] About This Course

CS122 - Using Relational Databases and SQL is an introductory database course that focuses on the most popular and widely used database -- the relational database. This course will also introduce you to some elementary programming elements through the use of the Structured Query Language, SQL, which we will use to extract data from our database.

[edit] Deadlines

  • Add Deadline: July 6, 2009
  • Drop Deadline (No Record): June 29, 2009
  • Drop Deadline (Withdrawal): August 6, 2009
  • Drop Deadline (Emergency Withdrawal):August 27, 2009

[edit] Class Resources

[edit] Important Documents

[edit] Required Software

[edit] Assignments

[edit] Lab Assignments

  • 10 Questions from the Movie Archive Database
  • 3 Points/Question
  • Upload assignments via CSNS
  • Due at end of laboratory session

[edit] Homework

  • 5 Questions from the Movie Archive Database
  • 3 Points/Question
  • Upload homework via CSNS
  • Due the following Monday at 11:59 PM (one minute before Tuesday)

[edit] Movie Archive Database

[edit] Final Exam Database

[edit] Weekly Schedule

[edit] Resources

[edit] Books

  • The Relational Model for Database Management, Version 2
    A 1990 book by Edgar F. Codd, the inventor of the relational data(base) model. You may find particularly interesting pages 12-13 and chapter 23; since this is an SQL class, check out what Dr. Codd thought about SQL at that time. NOTE: To read this book, you must be either on a school computer or have an Association for Computing Machinery account (it costs roughly $60 per year last time I checked to be a student member and to have complete access to their digital library).

[edit] Journal Articles

  • SEQUEL: A Structured English Query Language
    The original 1974 paper where the relational database query language, SEQUEL (Structured English Query Language, now known as SQL), was introduced. A basic summary of this paper goes like this: "Listen, this ALPHA language and even our own older language that we called SQUARE is just too difficult for someone not entitled "Professor" to understand. We need a new language for people who aren't so mathematical and we've borrowed some elements from structured programming to build a new language called SEQUEL that makes extracting data from a relational database so easy even a caveman can do it."
  • Relational Database: A Practical Foundation for Productivity
    Edgar F. Codd's Turing Award acceptance lecture. A nice summary on the history of the relational database model (you may notice that he uses the more general term "data model" rather than "database model"). Dr. Codd received the Turing Award (ACM's most prestigious technical award, named after Alan Turing) in 1981.

[edit] Research

  • SIGMOD Proceedings, SIGMOD Homepage, and TODS
    Do you want to know more about the database research of TODAY on top of all the YESTERYEAR topics that we teach here in school? Then consider reading some conference papers and research articles from SIGMOD (Special Interest Group on Management of Data) and TODS (ACM Transactions on Database Systems), to see what all the hot database topics of today are! Do you recognize the guy standing up on the right at this 2003 SIGMOD conference?

[edit] Interviews

  • Donald Chamberlin
    An interesting historical interview with Donald Chamberlin, one of the creators of SQL.
  • Chris Date
    Another interesting historical interview with Chris Date, who worked with Dr. Codd in the 70's at IBM. Chris Date is also the author of many books on the relational data model and databases in general.

[edit] ACM and IEEE Membership

  • As students in computer science, you should all know, and know early in your young academic careers, that computer science is a research-oriented field. You should also know about the two largest publishers of computer science literature and research, the ACM (Association for Computing Machinery) and the IEEE (Institute of Electrical and Electronics Engineers). Both organizations provide yearly student membership at discount prices; not to mention that being a member for several years also looks good on your resume -- especially if you become a member of multiple IEEE computer-related societies (the IEEE is not just for engineers).
  • I would like to encourage you guys to become members of the ACM and IEEE, and subscribe to their digital libraries and look around to get interested in something as early as possible. There is just so much interesting stuff in computer science and our school can only teach a very small portion of it! To truly appreciate all the wonders of computer science, you really do have to branch out on your own and explore the entire world for yourself!
  • There are also ACM and IEEE CSULA student chapters (clubs) that you may also join. Sometimes, these and other clubs such as NSBE (National Society of Black Engineers) get together to have bowling and gaming nights, and, in general, have a lot of fun. When wandering around the halls of the A building, once in a while just look out for any ACM or IEEE flyers posted on the bulletin boards to see when and where the next meetings are and join in, make some new friends, and contribute!
Retrieved from "http://cs.calstatela.edu/wiki/index.php/Courses/CS_122/Summer_2009"