Logo courtesy Wordle.net

## CS 4250: Database Management Systems

### 3:00 - 3:50 pm, M W F, DBH 101, Dr. Megan Thomas

[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.

 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) 10/3/2016 Schema: 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): Find the names and dates of earthquakes whose magnitude was greater than 7.0. Find the average population of cities whose names start with "San". List the lives lost, quake names and city names for all quakes that occurred before 1960. Find the names of earthquakes that have occurred in cities with a bigger population than that of Vancouver, Canada. (Query should be written so can “swap in” name of a different city easily.) List the total cost, per city, of all quakes with magnitude greater than 7.0. Find the name of the quake that did the most damage (\$\$) in a city with a population less than 2 million (i.e., of all quakes that have damaged cities with populations less than 2 mill, find the one (or more) that did the most damage) List the average magnitude of quakes for each fault (grouped by fault). List all earthquakes and, where applicable, also list city names and lives lost in that city for quakes that affected cities. 9/23/2016 "Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment about jobs related to big data... 9/21/2016 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. 9/20/2016 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: Becoming a Scientist or Engineer: Your Pathway to the Future with LSAMP (approx. 5 min): https://www.youtube.com/watch?v=Li90yoX_dGA LSAMP: Aiming High and Making a Difference (approx. 30 min): https://www.youtube.com/watch?v=53y7QJoH7Co 8/25/2016 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!

 Points Project Part 1 20 Project Part 2 20 Homework 1 15 Project Part 3 15 Homework 2 40 Project Part 4 10 Mini-Homework 1 7 Project Part 5 25 Homework 3 20 Project Part 6 12 Project Part 7 70 Homework 4 20

At the CSU Stanislaus library:

• Database Systems: The Complete Book by Garcia-Molina, Ullman and Widom, three extremely well-respected database researchers and professors at Stanford University.
• Database Management Systems by Raghu Ramakrishnan and Johannes Gherke, excellent, systems-oriented introduction to the field of database management.
• Database Tuning by Dennis Sasha and Philippe Bonet. A clear presentation of how database design decisions impact database performance. Also discusses IBM, Oracle and Microsoft systems and how design choices can impact them.
• MySQL and mSQL by Randy Yarger.
• MySQL by Paul DuBois (electronic).
• Readings in Database Systems by M. Stonebraker. A collection of influential papers in DBMS research history.

The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both available at the university library.

On-line Resources

Topic Ideas for End of Semester

• Database security
• SQL vs NoSQL DBMS debate
• Troubleshooting DBMSs that are not performing well
• XML, XQuery, etc