1 / 5

C20.0046: Database Management Systems Lecture #14

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

lynette
Download Presentation

C20.0046: Database Management Systems Lecture #14

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. C20.0046: Database Management SystemsLecture #14 Matthew P. Johnson Stern School of Business, NYU Spring, 2004 M.P. Johnson, DBMS, Stern/NYU, Sp2004

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

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

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

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

More Related