50 likes | 235 Views
C20.0046: Database Management Systems Lecture #14. Matthew P. Johnson Stern School of Business, NYU Spring, 2004. Agenda. Last time: Views , Constraints , Triggers This time: Begin programming for SQL Embedded SQL Pro*C, SQLJ PSMs CLI SQL/CLI in C JDBC in Java DBI/DBDs in Perl
E N D
C20.0046: Database Management SystemsLecture #14 Matthew P. Johnson Stern School of Business, NYU Spring, 2004 M.P. Johnson, DBMS, Stern/NYU, Sp2004
Agenda • Last time: Views, Constraints, Triggers • This time: • Begin programming for SQL • Embedded SQL • Pro*C, SQLJ • PSMs • CLI • SQL/CLI in C • JDBC in Java • DBI/DBDs in Perl • Future: • Midterm next Thursday M.P. Johnson, DBMS, Stern/NYU, Sp2004
Quick review • Attribute-based constraints checked when? • Foreign keys checked when? • Assertions checked when? • Examples from sqlzoo.net M.P. Johnson, DBMS, Stern/NYU, Sp2004
Slow review • Look at integrity violations in http://sqlzoo.net/howto/x04insertoracle.htm • Go over some R.A./SQL questions from hw… • SQL questions located at http://pages.stern.nyu.edu/~mjohnson/dbms/hw2sqlquestions.txt • Some “solutions” available at http://pages.stern.nyu.edu/~mjohnson/dbms/hw2solns.txt • Test by running at http://sqlzoo.net/1a.htm M.P. Johnson, DBMS, Stern/NYU, Sp2004
Future • Next: PSMs • (Re)read 8.2 • Next Thursday: Midterm • Practice SQL on sqlzoo • Responsible (in this order) for • all material from class, • all material assigned reading • Feedback is very important! • Please fill out midterm course evals before MT • Else lose 30 points on MT • Details TBA by email over week M.P. Johnson, DBMS, Stern/NYU, Sp2004