Logo courtesy Wordle.net
[Syllabus ] [Announcements] [Calendar/Lecture Notes] [Homeworks] [Fun News]
Welcome to CS4250, an introduction to database management systems. Topics include:
Modeling, development, and implementation of database systems using storage structures, data definition languages, and data manipulation languages for the relational approach to database management. Database integrity and security problems. Historical development of database systems.
Prerequisite: CS 3100.
Announcements and Upcoming Events
|12/14/2016||Here is a small chunk of the final exam you will take on Friday.|
|12/6/2016||"These Tech Jobs Are Set To Get a Major Pay Bump" (Fortune, Dec 2, 2016)|
|12/6/2016||CSU Stanislaus Dreamers: Resources for AB540 and undocumented students|
|10/19/2016||Here is a partial solution to Homework 2.|
|10/17/2016||Here is a small chunk of the midterm you will take on Friday.|
|10/7/2016||"Want a sure-fire well-paid job? Train to fight computer hackers" (Sacramento Bee, 7 Oct 2016)|
Earthquake (qname, date, latitude, longitude, magnitude, fault)
Damage(city, qname, cost, liveslost)
Cities(cname, latitude, longitude, population) [Assume cities have unique names.]
Questions (in SQL, and relational algebra where possible):
|9/23/2016||"Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment about jobs related to big data...|
Schema from class exercise: CREATE TABLE BookAwardWinners (lastname CHAR(20), firstname CHAR(20), title CHAR(30), year INTEGER, award CHAR(10), age INTEGER, PRIMARY KEY (lastname, title, award))
Goofy schema, and not normalized.
For student who are interested:
Psychological Counseling Services Workshops - workshops on coping with stress, and other issues that come up in college years.
Also, Fall 2016 Counseling Groups offered by our Psychological Counseling Services.
|9/13/2016||For the sports fans in CS 4250: "Tackle This: Football's Newest Most Valuable Player Is a Robot" (IEEE Spectrum, September 2016)|
|9/13/2016||"How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)|
|9/8/2016||Fall 2016 Tutoring Schedule for the Commons (1st floor, Naraghi Hall)|
|8/25/2016||The Louis Stokes Alliance for Minority Participation (LSAMP) program is looking to recruit students and Research Interns this Fall! (https://www.csustan.edu/AMP) Here are a couple of videos explaining more about LSAMP:|
The Commons is hiring Peer Mentors/Tutors for the 2016-2017 academic year. Applications are due by August 31. Upper division students majoring in Biology, Chemistry, Physics, Geology, Math, or Computer Science are needed. Interested students must have a minimum 3.0 GPA.
A copy of the complete job announcement with all requirements is available on the HR website at https://www.csustan.edu/hr/employment-opportunities/student-assistants
|8/25/2016||As I mentioned in class today, the Girls Who Code organization contacted our department recently, looking for volunteers, particularly those who might be interested in starting and facilitating a local club for middle / high school students.|
|8/24/2016||Welcome to CS 4250!|
|Project Part 1||20|
|Project Part 2||20|
|Project Part 3||15|
|Project Part 4||10|
|Project Part 5||25|
|Project Part 6||12|
|Project Part 7||70|
At the CSU Stanislaus library:
The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both available at the university library.
Fun News Items
Topic Ideas for End of Semester