1 / 14

DEPARTMENT STORE MIS

DEPARTMENT STORE MIS. Presented By: Abhay Raj Shakya Abhinaya Shrestha Hemanta Sagar Lama Nishant Bajracharya. Contents. Scope Used API Block Diagram Entity Diagram Interfaces. Scopes. T o automate the management of a department store.

karim
Download Presentation

DEPARTMENT STORE MIS

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. DEPARTMENT STORE MIS Presented By: Abhay Raj Shakya AbhinayaShrestha HemantaSagar Lama NishantBajracharya

  2. Contents Scope Used API Block Diagram Entity Diagram Interfaces

  3. Scopes • To automate the management of a department store. • To develop a billing system for points of sales(POS). • To develop an Inventory Management System. • To build an Executive and Decision Support Systems.

  4. API 1. JDBC API • Java database Connectivity (JDBC) is Java application programming interface that allows the Java programmers to access database management system from Java code. • Programming Activities • It helps us to connect to a data source, like a database. • It helps us in sending queries and updating statements to the database. • Retrieving and processing the results received from the database in terms of answering to your query.

  5. 2. PreparedStatement • An object that represents a precompiled SQL statement. • In PreparedStatement, the SQL statement is sent to the DBMS right away, where it is compiled. • To execute a Statement object many times, it usually reduces execution time.

  6. System Block Diagram Inventory manager Manager Cashier

  7. Class Entity Diagram

  8. Login Page

  9. Inventory Update

  10. Transaction Manager

  11. Completed Tasks • Proposal Submission • Made GUICompleted Coding for- • Inventory manager • Username and password Interface • Printing

  12. Challenges Faced • Problem in auto completion of jCombo box. • Printing jComponents via. Printer. • Use of PreparedStatement. • Unadequate resources.

  13. TO DO • Mid-term Report • Using Printing API sdk 1.2 for printing invoice • Using jCombobox for auto searching entries. • Completing MIS with executing support system and decision support system.

  14. THANK-YOU

More Related