Use the following schemas for the exercises in the Book
Midterm Exam - Wed. March 9.
Final Exam - Friday May 13 from 7:00 - 10:00 pm in GDC 2.216
Dr. Philip Cannata, email@example.com, office hours: MW 3:00 - 3:45 in GDC 5.402.
TA: Chia-Chen Hsu, firstname.lastname@example.org; Office Hours: Tuesday/Thursday 9-10 am at TA station, Desk 4.
Proctor: Brandon Hollowell, email@example.com; Office Hours: Tuesday/Thursday from 3:30 to 4:30 on the lobby of the fifth floor of GDC
Make sure you are registered with piazza for this course and be sure to check and read your piazza email several times a day because this will be the primary means of communication outside of class time. Dr. Cannata will not alter his proceedure of always sending all of his messages to the entire class.
Students with disabilities may request appropriate academic accommodations from the Division of Diversity and Community Engagement, Services for Students with Disabilities, 512-471-6259, and the link above.
Types of Joins:
Inner Joins - the following 3 are essentially the same except for syntax:
See also http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins for more details.
Subqueries and Group By:
Hierarchical (Recursive) Queries:
SPARQL queries can be viewed here.
Download Oracle SQLDeveloper. You need the Java 8 JDK to run this.
./kvroot -store kvstore -host Phils-MacBook-Pro.local -port 5000 -admin 5001
Jython 2.7.1b2 (default:8fb35eab165e+5194b3d04dca+, Jan 24 2016, 16:52:10)
[Java HotSpot(TM) 64-Bit Server VM (Oracle Corporation)] on java1.8.0_51
Also, see the emp/dept Databases tab on this web page.
Download and install Oracle SQLDeveloper Data Modeler 4.1.3 before today's class.
You are strongly encouraged to attend and understand the Stanford UML Data Modeling and UML to Relations courses online. Here are links to each of thes videos in these courses, UML Data Modeling, UML to Relations - Part 1 UML to Relations - Part 2.
Relational Data Modeling Class Notes
We will be building this model in class:
Here's a link to the Data Models and ddl that we developed in class today.
parser1 used to produce the .ddl2 file
parser2 used to produce the .ddl3 file
If you don't understand the unix used in these instructions, take this tutorial.
In a nutshell, here's what I did in class today:
Click here to see the full report. This image comes from page 16 of the report.
Selected Project Presentations: