1 / 17

Term Project Rental Shop

Term Project Rental Shop. 2009.6.10 Hoon Lee Department of Logistics Information Technology. 목차. 0. Overview DFD ERD GUI Procedure Reference. 0. Overview. Rental Shop Rental shop handles DVDs. This system supports rental policy and delay policy to decide a fee/charge. Tools Oracle

marinel
Download Presentation

Term Project Rental Shop

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. Term ProjectRental Shop 2009.6.10 Hoon Lee Department of Logistics Information Technology

  2. 목차 0. Overview • DFD • ERD • GUI • Procedure • Reference

  3. 0. Overview • Rental Shop • Rental shop handles DVDs. • This system supports rental policy and delay policy to decide a fee/charge. • Tools • Oracle • Ruby on Rails • MS Office

  4. 1. DFD • Object and Function CUSTOMER PRODUCT LENT_PRODUCT LEND_POLICY DELAY_POLICY WATCH_GRADE Operator System C/R/U/D 1.1

  5. 1. DFD • Context diagram List lends List cstm/prod Create a cstm/prod Lend a prod Read a cstm/prod Read a lend Rental Shop System Operator Operator Update a cstm/prod Return a prod Delete a cstm/prod Update a lend

  6. 1. DFD • Level 1, Product maintenance service List prod PRODUCT prod Read Operator Create prod Update prod prod Delete Delete an item Create an item Make a details 1.1 Make a list Update an item 1.5 1.4 1.3 1.2

  7. 1. DFD • Level 1, Customer maintenance service List cust CUSTOMER cust Read Operator Create cust Update cust cust Delete Delete an item Create an item Make a details 2.1 Make a list Update an item 2.5 2.4 2.3 2.2

  8. 1. DFD • Level 1, Product lend service List lends lend LENT_PRODUCT lend Read a lend Operator Update a lend lend Lend a prod lend lend Return a lend Return a prod Update a lend Make a details 3.1 Make lends Lend a prod 3.5 3.3 3.4 3.2

  9. 1. DFD Lend a prod 3.3 • Level 2, Function to lend a product cust prod Lend a prod Check LEND_POLICY PRODUCT WATCH_GRADE LENT_PRODUCT CUSTOMER prod Operator Reject grade policy Create lend Create an item 3.3.2 3.3.1 Read cust & prod 3.3.3 Check & Calculate lend

  10. 1. DFD Return a prod 3.5 • Level 2, Function to return a product cust prod Return a lend Calculate CUSTOMER PRODUCT LENT_PRODUCT DELAY_POLICY prod Operator policy Update lend Calculate a price Update an item 3.5.2 3.5.1 Read cust & prod... 3.5.3 lend

  11. 2. ERD • ERD

  12. 3. Procedure • Stored procedure • Is lend? • IF (CURRENT_DATE - PUBLISH_DATE + 1) <= UNDER_DAYS THEN … ENDIF • IF RETURN_DATE IS NOT NULL OR RECORD IS NOT EXIST THEN … ENDIF • Lend charge • LEND_CHARGE = (CURRENT_DATE - PUBLISH_DATE + 1) * LEND_RATE • Extra charge for late return • EXTRA_CHAGE = (CURRENT_DATE - LEND_DATE + 1 - OVER_DAYS) * LEND_PRICE * EXTRA_RATE

  13. 4. GUI • Web Browser – List (sample)

  14. 4. GUI • Web Browser – Create a new record (sample)

  15. 4. GUI • Web Browser – Edit a record (sample)

  16. 5. Reference • Ruby Programming Language • http://www.ruby-lang.org/en/ • Ruby on Rails • http://rubyonrails.org/ • RubyForge – Project Library • http://rubyforge.org/ • Ruby Central • http://www.rubycentral.com/ • Ruby on Rails on Oracle: A Simple Tutorial • http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html • Oracle Database Software Downloads • http://www.oracle.com/technology/software/products/database/index.html

  17. Thank You!

More Related