Description

This course covers concepts, approaches, tools, and methodology of database design. Topics include the relational data model; normal forms; commercial languages such as SQL (SQL constraints, SQL triggers, and update languages); query-by-example (QBE); XML data model, and XML query language (XQuery); as well as APIs to access databases from applications and advanced topics in big data and data integration (time permitting). This course involves a database-application development project through a series of lab assignments.

Prerequisite(s): course 12B.

General Information

Instructor
Wang-Chiew Tan
tan@cs.ucsc.edu
Lecture times
E2-192 TTH 12noon - 1:45pm or by appointment
Instructor office hours
E2-343B, Tuesdays 1:45pm-3:30pm
Teaching assistant
Daniel Lipovetsky
danl@soe.ucsc.edu
TA office hours
BE-312C/D,
Mondays 12noon - 1pm
Wednesdays 4pm - 5pm
Lab sections
Social Science I Mac (Room 135),
Mondays 10:00am-11:45am
Wednesdays 2:00am-3:45pm
Disability resource center
If you qualify for classroom accommodations because of a disability, please get an Accommodation Authorization from the Disability Resource Center (DRC) and submit it to me in person outside of class (e.g., office hours) within the first two weeks of the quarter. Contact DRC at 459-2089 (voice), 459-4806 (TTY), or http://drc.ucsc.edu for more information on the requirements and/or process.

Announcements

Midterm Solutions (PDF format)
6/09/14 10:25 PM

Midterm solutions were posted (@95) earlier today. I've converted them to PDF format: midsol.pdf

View on Piazza
My office hours for the next two weeks
5/26/14 8:45 AM
Here are my office hours for the next two weeks (i.e., the last two weeks of this course). I have two extra office hours. I hope you can make use of hours to clarify your questions, if any. If these hours do not work, we will have to find some other time separately.

Tuesday 05/27: 2-3:30pm
Wednesday 05/28: 4-5:00pm
Tuesday 06/03: 2-3:00pm
Monday 06/09: 10-11:00am

Please come prepared with the questions you have.
View More · View on Piazza
Lecture notes sets 11 and 12
5/26/14 8:39 AM
Fyi, the last two sets of lecture notes on XML, XPath, and XQuery are already posted.

Best,
Wang-Chiew
View on Piazza
Extra office hours next week
5/22/14 4:28 PM
I will have extra office hours next week.

Tuesday 05/27: 2-3:00pm
Wednesday 05/28: 4-5:00pm

Please come prepared with the questions you have.

Have a great memorial day weekend!

Wang-Chiew
View More · View on Piazza
Extra office hour tomorrow 5/21 at 4pm
5/20/14 4:50 PM
I will have an extra office hour tomorrow (5/21) at 4pm at my office. Please feel free to stop by if you have questions about the lectures or homeworks.

Best,
Wang-Chiew
View More · View on Piazza
Lab 4 Due Date Changed
5/20/14 11:30 AM

Memorial Day is next Monday, May 28th, so lab sections will not meet.

For that reason, the lab due date is extended to 7pm the following Monday, June 2nd.

View on Piazza
Lab 4 UPDATED - Please download updated lab4.pdf and lab4.zip
5/19/14 2:35 PM

I fixed a link in the PDF. I also dropped the dv and cb customer tables; use mg_customers for customer data. Finally, I added a sequence for the dv_film table, so that when you insert a new film, you do not need to specify the film id--the sequence will generate one for you.

View on Piazza
Lab 4 posted - DUE 7pm Wednesday, May 28
5/19/14 9:00 AM

Download it, along with lab4.zip from the resources page: https://piazza.com/ucsc/spring2014/cmps182/resources

View on Piazza
Staff Office Hours
NameOffice Hours
Vasileios Polychronopoulos
When?
Where?
Wang-Chiew Tan
When?
Where?
Daniel Lipovetsky
When?
Where?
Poornima Chozhiyath Raman
When?
Where?
Shel Finkelstein
When?
Where?