1 / 10

Self Checkout Shopping Cart

Self Checkout Shopping Cart. CSC 335: Database System Concepts Term Project. Aaron Klor and Dan Matz Missouri State University. Functionality Recap. Transacting Administrating Product add/edit/remove User add/edit/remove Transaction view/delete/output. Database. Object database

nantai
Télécharger la présentation

Self Checkout Shopping Cart

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. Self Checkout Shopping Cart CSC 335: Database System Concepts Term Project Aaron Klor and Dan Matz Missouri State University

  2. Functionality Recap • Transacting • Administrating • Product add/edit/remove • User add/edit/remove • Transaction view/delete/output

  3. Database • Object database • NOT Relational database • NO SQL • Entirely object based • Just “store” objects • Well suited for high-order, object-oriented languages

  4. DB4O • Database 4 Objects • Single-file database • Similar to SQLite • Can be configured for client/server • Available for Java and .NET languages • GPL license model

  5. DB4O Usage • Import library • Database access methods/classes

  6. Objects • Product, Transaction, User • All extend DatabaseObject • Database Object • Provided by us • Abstract class • Provides super type • ID • ImageLocation

  7. Not Relational, But • Some terms still apply: • ER Diagramming still useful • Specialization important – “IS A” • Schema diagrams still useful • Constraints • Foreign keys • Functional dependencies • Others do not • Normal forms • Used for column normalization – No columns!

  8. ER Diagram

  9. Technologies • Java – Language • http://java.sun.com/ • Eclipse – IDE • http://www.eclipse.org/ • Eclipse SWT - Cross-Platform Frontend Library • http://www.eclipse.org/swt/ • DB4O – Database • http://www.db4o.com/ • Google Project Hosting • http://code.google.com/p/databaseprojectcsc335fa09/ • Mercurial

  10. Questions

More Related