1 / 11

Warehouse DB Management System Database Management & Analysis Term Project Proposal

2009.6. 10. Warehouse DB Management System Database Management & Analysis Term Project Proposal. IKE Lab. Yunho Song. Warehouse DB Management System. contents. Project Scope Application Design Implementation. 1. Project Scope. Warehouse DB Management System. 1. Project Scope.

upton
Download Presentation

Warehouse DB Management System Database Management & Analysis Term Project Proposal

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. 2009.6. 10 Warehouse DB Management System Database Management & Analysis Term Project Proposal IKE Lab. Yunho Song

  2. Warehouse DB Management System contents Project Scope Application Design Implementation

  3. 1. Project Scope

  4. Warehouse DB Management System 1. Project Scope Project Object • To implement simple warehouse DB management system • User input based DB management • Inquiry necessary data freely • Compute charge Main Idea Assumption One kind of cargo can be handled at once All cargoes are kept by unit load Daily charge per 1unit is known Carry-in/carry-out date is known Extra charge is adapted to cold-storage or poisonous cargo

  5. 2. Application Design

  6. Warehouse DB Management System 2. Application Design Dataflow Diagram Customer Request to keep, transaction information customer Transaction occurrence customer information customer data transaction information cargo information Employee cargo Transaction transaction data cargo data Compute payment payment information

  7. Warehouse DB Management System 2. Application Design User Interface Design • Graphic User Interface WarMS Inquiry part Customer, cargo, transaction, employee • Text User Interface • Example • Inquiry • Add • Del • exit charge part Start, end, period, charge

  8. Warehouse DB Management System 2. Application Design Database Design • CUSTOMER • EMPLOYEE • CARGO • KEEP • WORKS_ON USER_ID NAME ADDRESS SSN TEL E-MAIL TRANSAC_No. EMPL_ID ENAME EADDRESS ESSN ETEL SALARY CARG_ID CNAME CHARGE TYPE CARG_ID AMOUNT TRANSAC_No. CARRY IN CARRY OUT PERIOD EMPL_ID TTYPE HOURS

  9. 3. Implementation

  10. Warehouse DB Management System 3. Implementation Implementation • Two Possible method • Program language : Python 2.5 • DBMS : MYSQL • Program language : VB.NET • DBMS : MS ACESS

  11. Thank You!!

More Related