Use the following schemas for the exercises in the Book
Midterm Exam - Wednesday October 14 in class.
Final Exam - Probably Friday December 11 from 7:00 - 10:00 in the classroom.
Dr. Philip Cannata, firstname.lastname@example.org, office hours: MW 3:00 - 3:45 in GDC 5.402.
TA: Chia-Chen Hsu, email@example.com, office hours: None
Proctor: Chris Timaeus, firstname.lastname@example.org, office hours: T-TH 3:30-5, flexible. 4th floor GDC atrium, for now..
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 4.1 EA2. You need the Java 8 JDK to run this.
Also, see the emp/dept Databases tab on this web page.
Download and install Oracle SQLDeveloper Data Modeler 4.1.1 before today's class.
You are strongly encouraged to attend and understand the Stanford UML Data Modeling and UML to Relations courses online before attending today's class. 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
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 teh unix used in these instructions, take this tutorial.
Click here to see the full report. This image comes from page 16 of the report.