1 / 47

Emporium Online Registration & Management Information System (EORMIS)

Emporium Online Registration & Management Information System (EORMIS). Team 1, IADCS-37. 27 th September,2009. Myanma Computer Co., Ltd. Contents. Introduction Client Organization System to be Developed Description of the current system Currently functioning

mahon
Download Presentation

Emporium Online Registration & Management Information System (EORMIS)

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. Emporium Online Registration & Management Information System (EORMIS) Team 1, IADCS-37 27th September,2009 Myanma Computer Co., Ltd.

  2. Contents • Introduction • Client Organization • System to be Developed • Description of the current system • Currently functioning • Problems with the current system • Advantages of the proposed system • Initial Statement of Proposed System • Initial Diagram of Existing System • Logical DFD(Context diagram) of Proposed System • Data Flow Diagram (Level-1) of Proposed System • Optimization • Entity Relationship Diagram • ELH • File Specification • Report Sample • Aims of the Project • Software Development Environment • Development Specification • Methods and techniques • Project Schedule

  3. Introduction The following members are the team of Practical Project Module. • 1. KyawKyawOo Leader • 2. Zin Min Htike 2nd leader • 3. KayKhineSoe Member

  4. Client Organization • Name : Myanma Gems Enterprise (MGE) • Main Function : Visitor Registration of Myanma Jade, Gems and Pearl Emporium • Location : No. 66, Kaba Aye Pagoda Road, Myangone Township, Yangon, Myanmar.

  5. System to be developed • based on the processes of Visitors Registration of the emporium • will be automated the visitor registration and attendance processes into a web based system • can be accessed by the visitors, the receptionists and the management as well as the cashers for payment of registration fees.

  6. Description of the current system • Only invited guests can be registered as visitors of emporium • There are two main types of Visitors, Local Visitor and Foreign Visitor. • Foreign visitors come from many countries such as Republic of China, Hong Kong, Thailand, etc.. to attend the emporium. • Registered visitors are available and eligible to enter to the compound of the emporium.

  7. Currently functioning The registration processes include • verifying and checking for black list and invitation information • collect the registration fees • recording the visitor’s information • issuing the registration card

  8. Problem with the current system • The emporium information cannot be informed on time to the guests who interest to attend the emporium. • the new visitors, who haven’t received the invitation card, may not available to attend the emporiums. • MGE staffs prepared the invitation list manually and it takes times • hundreds of local and foreign visitors are queued and crowded long time at the registration counters for their registration processes inconveniently. • MGE staffs operate the registration processes with many difficulties and slowly. • Difficult to summarize and prepare the Daily Arrival Reports categorizing by Country and Company, and the Attendance of Visitors.

  9. Advantages of the proposed system • Visitors who want to attend the emporium can register through internet easily without waiting for the registration processes at the registration counter • Can rapidly issue registration card for the online registered person • Can access to the registration services 24-hour • Can organize a central database that can be accessed by the management and the staff of MGE • Can share data among the management and staff through authorization. • Can provide updated information to the Visitors and the authorized users • Can generate the required reports in time

  10. Initial statement of proposed system • To develop the online registration of visitor to attend the emporium • To manage the visitor information with central database • The major functions of the proposed system are: • Update the Emporium and Black list Information • Accept Request from new foreign and local visitors • Invite Old and New Local and Foreign Visitors • Record the Registration Fees Payment Information • Record Visitor Information • Issue Registration Card • Report Generation

  11. Initial Diagram of Existing System

  12. Logical DFD (Context Diagram) of Proposed System

  13. Data Flow Diagram (Level-1) of Proposed System

  14. Data Flow Diagram (Level-1) of Proposed System

  15. Data Flow Diagram (Level-1) of Proposed System

  16. Data Flow Diagram (Level-1) of Proposed System

  17. Data Flow Diagram (Level-1) of Proposed System

  18. Data Flow Diagram (Level-1) of Proposed System

  19. Data Flow Diagram (Level-1) of Proposed System

  20. Optimization

  21. Entity Relationship Diagram (ERD)

  22. Entity Life History (ELH)

  23. Entity Life History (ELH)

  24. Entity Life History (ELH)

  25. File Specification • Emporium • File Name : Emporium • File Description : To store Emporium Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : EmpID(g) Foreign Key : - (h) Record Length : 122(i) Maximum Record : 30 (j) File Size : 3.6 KB (k) Retention period : 10 years

  26. File Specification • Black List • File Name : BlackList • File Description : To store Black List Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : BlID(g) Foreign Key : EmpID, RegNo (h) Record Length : 224 (i) Maximum Record : 3000 (j) File Size : 656.6 KB (k) Retention period : 10 years

  27. File Specification • Request • File Name : Request • File Description : To store Request Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Transaction File (f) Primary Key : RqID(g) Foreign Key : EmpID, CompanyID, CountryID (h) Record Length : 129 (i) Maximum Record : 96000 (j) File Size : 11.81 MB (k) Retention period : 10 years

  28. File Specification • Invitee • File Name : Invitee • File Description : To store Invitee Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : InvID, EmpID (g) Foreign Key : CompanyID (h) Record Length : 123 (i) Maximum Record : 300000 (j) File Size : 35.2 MB (k) Retention period : 10 years

  29. File Specification • Company • File Name : Company • File Description : To store Company Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : CompanyID (g)Foreign Key : CountryID (h) Record Length : 340 (i) Maximum Record : 30000 (j) File Size : 97.2 MB (k) Retention period : 10 years

  30. File Specification • Country • File Name : Country • File Description : To store Country Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : CountryID (g) Foreign Key : - (h) Record Length : 55 (i) Maximum Record : 300 (j) File Size : 16.2 KB (k) Retention period : 10 years

  31. File Specification • Payment • File Name : Payment • File Description : To store Payment Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Master File (f) Primary Key : PaymentID(g) Foreign Key : InvID, EmpID , CompanyID (h) Record Length : 62 (i) Maximum Record : 300000 (j) File Size : 17.7 MB (k) Retention period : 10 years

  32. File Specification • Reg • File Name : Reg • File Description : To store Visitor Registration Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Transaction File (f) Primary Key : RegNo, EmpID (g)Foreign Key : InvID, PaymentID, CompanyID (h) Record Length : 138 (i) Maximum Record : 300000 (j) File Size : 39.5MB (k) Retention period : 10 years

  33. File Specification • CardIsssued • File Name : CardIssued • File Description : To store Registration Card Issued Information • File Structure : (d) File Organization : Index Sequential File (e) File Type : Transaction File (f) Primary Key : CISID (g) Foreign Key : RegNo, EmpID, CompanyID* (h) Record Length : 30 (i) Maximum Record : 300000 (j) File Size : 8.6 MB (k) Retention period : 10 years

  34. Report Sample (1) Registration Report (a) Visitor Registration Summary Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Visitor Registration Summary

  35. Report Sample (2) Daily Card Issued Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Daily Card Issued Report Date:2 Oct 2009

  36. Report Sample (3) Payment Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Payment Report

  37. Report Sample (4) BlackList Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium BlackList Report

  38. Report Sample (5) Invitation Report (a) Invitation Summary Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Invitation Summary Report (1-Oct-2009) to (7-Oct-2009)

  39. Report Sample (5) Invitation Report (a) Invitation Summary Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Invitation Summary Report (1-Oct-2009) to (7-Oct-2009)

  40. Report Sample (5) Invitation Report (b) Invitee Detail Report Myanma Gems Enterprise Mid Year-2009 Myanma Jade, Gems and Pearl Emporium Invitee Detail Report

  41. Aims of the Project • To inform the emporium information in advance and in time • To provide with the fresh and update information concerned with emporium • To get the chance for interested guests to attend the emporium • To enter payment information of visitor registration fees through the Myanmar Foreign Trade Bank • To provide the direct registration services instead of local agent • To substitute the traditional postal correspondence • To reduce time period of invitation and registration process from two months to one week ahead of emporium • To provide 24/7 services to the customers • To provide services and facilities effectively and efficiently • To deliver the services conveniently • To develop the central database for Management Information

  42. Software Development Environment • Platform that the proposed system will run • Server Operating System – Microsoft Platform • Client Operating System – Any Platform • Technology to be used • Microsoft Internet Information Server 6.0 • MYSQL Server 5.1 • Microsoft ASP .Net 2.0 • Microsoft .Net Framework 2.0 • Microsoft Visual Studio 2005 • Microsoft Visio 2007 • Microsoft Word 2007

  43. Development Specification • is used Structured Systems Analysis and Design Methodology (SSADM) • Stages in SSADM • Requirement analysis • Feasibility study • Design • Development • Testing • Implementation • Maintenance

  44. Methods and techniques • Fact Finding Methods • Data Flow Diagramming • Logical Data Modeling • Relational Data Analysis • Physical Data Design

  45. Project schedule

  46. Project schedule

  47. Emporium Online Registration & Management Information System(EORMIS) Thank You Team 1, IADCS-37

More Related