Stock Listing Company Management System

TABLE OF CONTENTS

CHAPTER 1 – INTRODUCTION 5

1.1 SCENARIO 5

1.2 BACKGROUND 6

1.3 EXISTING SYSTEM AND SLIMS 7

1.3.1 Current System 7

1.3.2 SLIMS 8

1.4 PROJECT SCOPE 9

CHAPTER 2 - DEVELOPING TOOLS 11

2.1 MODELING LANGUAGE 11

2.1.1 Unified Modeling Language (UML) 11

2.1.2 Rational Rose 11

2.2 DATABASE MANAGEMENT SYSTEMS (DBMS) 12

2.2.1 Introduction to DBMS 12

2.2.2 Kinds of DBMSs 13

2.2.4Choose DBMS and Explain Reasons 14

2.3 PROGRAMMING LAGUAGES 17

2.3.1 Introduction to Programming Language 17

2.3.3 Choose Programming language and explain reasons 20

2.4 OTHER TOOLS 21

2.4.1 Platform 21

2.4.2 Developing Tool 21

2.4.3 System design tool 26

2.4.4 Report designing tool 26

CHAPTER 3 - SYSTEM ANALYSIS 27

3.1 DETERMINING REQUIREMENTS OF THE SYSTEM 27

3.1.1 Managing Account 29

3.1.2 Managing Initial Information 30

3.1.3 Managing Periodic Information 31

3.1.4 Managing Extraordinary Information 32

3.1.5 Managing Report 33

3.1.6 Managing Daily Transaction 34

3.2 ANALYSE SAMPLE FORMS 35

3.2.1 Analyze Input Form 35

3.2.2 Analyze Output Form 39

3.3 SEQUENCE DIAGRAMS 42

3.3.1 Sequence Diagram for Accessing To the System 42

3.3.2 Sequence Diagram for Setting Account 43

3.3.3Sequence Diagram for Updating Account 44

3.3.4 Sequence Diagram for Disable User 45

3.3.5 Sequence Diagram for Creating Stock Information 46

3.3.6 Sequence Diagram for Updating Company Information 47

3.3.7 Sequence Diagram for Searching Profit Plan 48

3.3.8 Sequence Diagram for Deleting Shareholders 49

3.3.9 Sequence Diagram Report 50

3.3.10 Sequence Diagram Daily Transaction 51

3.4 STATECHART DIAGRAMS 52

3.4.1 Statechart Diagram of “Accessing to system” Function 52

3.4.2 Statechart Diagram of “Account Management” Function 53

3.4.3 Statechart Diagram of “Granting role” Task 54

3.4.4 Statechart Diagram of “Term Management 55

3.4.5 Statechart Diagram of “Balance Sheet 56

3.4.6 Statechart Diagram of “Extraordinary Information 57

3.4.7 Statechart Diagram of “Daily Transaction 58

3.4.8 Statechart Diagram of “Report Management 59

3.4.9 Statechart Diagram of “Financial Report Explanation Management 60

3.5 CLASS DIAGRAM Error! Bookmark not defined.

3.5.1 Access To System Function 62

3.5.2 Account Management Function 63

3.5.3 Role Management Function 64

3.5.4 User_Role Management Function 65

3.5.5 User_Company Management Function 66

3.5.6 Company Management Function 67

3.5.7 Bad Debt Management Function 68

3.5.8 Business Result Management Function 69

3.5.9 Financial Report Explanation Management Function 70

3.5.10 Balance Sheet Management Function 71

3.5.11 Extraordinary Information Management Function 72

3.5.12 Transaction Cancellation Management Function 73

3.5.13 Split/Attach Management Function 74

3.5.14 Addition Stock Management Function 75

3.5.15 Report Management Function 76

3.5.16 Daily Transaction Management Function 77

3.5.18 Management Function 79

3.5.19 Management Function 80

3.5.21 Management Function 82

3.6 SYSTEM DESIGN 83

3.6.1 DATABASE DESIGN 83

3.6.2 The Process of Normalization 83

3.6.3 Defining Relationships 84

3.6.4 Result of Database Normalization and Design Process 85

3.7 SYSTEM DESIGN 93

3.7.1 System Menu 93

3.7.2 Input Design 97

3.7.3 Output Design Error! Bookmark not defined.

CHAPTER 4 - CONCLUSION AND DEVELOPMENT TENDENCY 100

4.1 ADVANTAGES 100

4.2 LIMITATION AND SOLUTION 100

4.3 CONCLUSION AND DEVELOPMENT TENDENCY 101

 

 

doc102 trang | Chia sẻ: lynhelie | Lượt xem: 1091 | Lượt tải: 0download
Bạn đang xem trước 20 trang tài liệu Stock Listing Company Management System, để xem tài liệu hoàn chỉnh bạn click vào nút DOWNLOAD ở trên
to correspond to real aspects of the problem and thereby to model the real world. Indeed, object-oriented programming often begins from a written statement of the problem situation. Then by a process of inserting objects or variables for nouns, methods for verbs and attributes for adjectives, a good start is made on a framework for a program that models, and deals with, that situation. This allows one to learn how to program in object-oriented languages. The majority of the computer programmers agree that OOP is a major advance on the previous complexities of procedure based methods, as its popularity attests to the fact, and OOP can be a major advantage in large projects where procedural methods tended to develop very complicated conditional loops and branches, difficult to understand and to maintain. 2.3.2.2 Definition of Object-Oriented Programming (OOP) Object-oriented programming (OOP) is a computer programming paradigm that emphasizes the following aspects: Objects - packaging data and functionality together into units within a running computer program; objects are the basis of modularity and structure in an object-oriented computer program. Abstraction - The ability for a program to ignore some aspects of the information it's manipulating, i.e. the ability to focus on the essential. Encapsulation - The ability for the program to hide information about the implementation of a module from its users, i.e. the ability to prevent users from breaking the invariants of the program. Polymorphism - The ability of an entity to stand for different things based on its context of use. Inheritance - Defining classes as extensions of existing classes. The definitions of OOP are disputed. In the most general sense, object-oriented programming refers to the practice of viewing software primarily in terms of the "things" (objects) it manipulates, rather than the actions it performs. Other paradigms such as functional and procedural programming focus primarily on the actions, with the objects being secondary considerations; in OOP, the situation is reversed. OOP itself has been used to market many products and services and the actual definitions and benefits attributed to OOP have often been colored by commercial marketing goals. Similarly, many programming languages have a specific view to OOP that is less general in certain aspects from the more general definition. Widely-used terminology distinguishes object-oriented programming from object-based. The former is held to include inheritance (described below), while the latter does not. 2.3.2.3 Benefits of Object-Oriented Programming (OOP) Have you wondered why modern programming languages tend to be object-oriented? C++ was created as an extension of C to support OOP. And Java, one of the most popular languages on the planet, is also an OOP language. Then, of course, Visual Basic has evolved into VB.NET, a fully OOP language. There is a good reason for this transformation. OOP offers several benefits, such as easy code maintenance, extensibility, and code reuse, not found in procedural programming languages. Some of the benefits are outlined below. Easy Maintenance. Modularity is inherent in OOP. Entities are represented by classes and classes with the same functionality are located in the same namespace (package). You can add a class into a namespace without affecting other members of the namespace. Extensibility. OOP naturally supports extensibility. Having a class with certain functionality, you can quickly extend that class to create a different class with extended functionality. Code Reuse. Since functionality is encapsulated into a class and each class is an independent entity, providing a library is very easy. In fact, programmers of any .NET Framework language can and should use the .NET Framework class library, an extensive library that provides rich functionality. Better still, you can extend the functionality of the class library to provide classes that suit your needs. 2.3.3 Choose Programming language and explain reasons In order to develop Stock Listing companies Management System, we use programming language C# (pronounced C sharp). C# is one of programming languages in toolbox Visual Studio.Net, one strategic product of Microsoft. It is one advanced object-oriented programming language which assists effectively programmers in constructing applications above Microsoft.Net platform in a convenient and fast way. An evolution of C and C++, C# is simple, modern, type-safe, and object-oriented. It was designed for building a wide range of enterprise compiled as managed code, which means it benefits from the services of the Common Language Runtime. These services include language interoperability, garbage bolection, enhanced security, and improved versioning support. C# is fully supported within Visual Studio .NET by project templates, designers, property pages, code assistants, an object model, and other features of the development environment. The library for C# programming is the .NET Framework. C# includes following salient properties: - Productivity and safety: It supports all existing standards about programming It minimizes serious faults It minimizes expenses for developing software with integrative supporting tool in deciding version. - Robustness, convenience and activeness: It is easy to constructing all functions of application software from professional skill process. High interactive property, it provides internal supporting mechanism for COM and Windows based API. It supports Unicode wholly. Hence we choose C# programming language as developing tool for this project. 2.4 OTHER TOOLS 2.4.1 Platform Windows 2000 Server SP (service pack) or later Windows Server 2003 is the most productive infrastructure platform for powering connected applications, networks, and Web services from the workgroup to the data center. Easy to deploy, manage, and use, Windows Server 2003 helps you build a secure IT infrastructure that provides a powerful application platform for quickly building connected solutions and an information worker infrastructure for enhanced communication and collaboration anytime and anywhere. The Windows Server 2003 operating systems build on the proven reliability, scalability, and manageability of Windows 2000 Server while improving essential services. Now with enhanced security and better performance, Windows Server 2003 offers the best server infrastructure for increasing IT efficiency, developing applications quickly, and enhancing productivity. As of March, 2005, the Windows Server 2003 operating systems ship with Service Pack 1 (SP1). Your organization can reap the cost-saving and productivity-enhancing benefits of the highest quality Windows Server ever. And a worldwide network of partners can help you build the solutions you need. 2.4.2 Developing Tool Microsoft .Net Framework The .NET Framework is a new computing platform that simplifies application development in the highly distributed environment of the Internet. The .NET Framework is designed to fulfill the following objectives: To provide a consistent object-oriented programming environment whether object code is stored and executed locally, executed locally but Internet-distributed, or executed remotely. To provide a code-execution environment that minimizes software deployment and versioning conflicts. To provide a code-execution environment that guarantees safe execution of code, including code created by an unknown or semi-trusted third party. To provide a code-execution environment that eliminates the performance problems of scripted or interpreted environments. To make the developer experience consistent across widely varying types of applications, such as Windows-based applications and Web-based applications. To build all communication on industry standards to ensure that code based on the .NET Framework can integrate with any other code. The .NET Framework has two main components: the common language runtime and the .NET Framework class library. The common language runtime is the foundation of the .NET Framework. You can think of the runtime as an agent that manages code at execution time, providing core services such as memory management, thread management, and remote, while also enforcing strict type safety and other forms of code accuracy that ensure security and robustness. In fact, the concept of code management is a fundamental principle of the runtime. Code that targets the runtime is known as managed code, while code that does not target the runtime is known as unmanaged code. The class library, the other main component of the .NET Framework, is a comprehensive, object-oriented collection of reusable types that you can use to develop applications ranging from traditional command-line or graphical user interface (GUI) applications to applications based on the latest innovations. The following sections describe the main components and features of the .NET Framework in greater detail. Features of the Common Language Runtime The common language runtime manages memory, thread execution, code execution, code safety verification, compilation, and other system services. These features are intrinsic to the managed code that runs on the common language runtime. With regards to security, managed components are awarded varying degrees of trust, depending on a number of factors that include their origin (such as the Internet, enterprise network, or local computer). This means that a managed component might or might not be able to perform file-access operations, registry-access operations, or other sensitive functions, even if it is being used in the same active application. The runtime enforces code access security. For example, users can trust that an executable embedded in a Web page can play an animation on screen or sing a song, but cannot access their personal data, file system, or network. The security features of the runtime thus enable legitimate Internet-deployed software to be exceptionally featuring rich. The runtime also enforces code robustness by implementing a strict type-and-code-verification infrastructure called the common type system (CTS). The CTS ensures that all managed code is self-describing. The various Microsoft and third-party language compilers generate managed code that conforms to the CTS. This means that managed code can consume other managed types and instances, while strictly enforcing type fidelity and type safety. In addition, the managed environment of the runtime eliminates many common software issues. For example, the runtime automatically handles object layout and manages references to objects, releasing them when they are no longer being used. This automatic memory management resolves the two most common application errors, memory leaks and invalid memory references. The runtime also accelerates developer productivity. For example, programmers can write applications in their development language of choice, yet take full advantage of the runtime, the class library, and components written in other languages by other developers. Any compiler vendor who chooses to target the runtime can do so. Language compilers that target the .NET Framework make the features of the .NET Framework available to existing code written in that language, greatly easing the migration process for existing applications. While the runtime is designed for the software of the future, it also supports software of today and yesterday. Interoperability between managed and unmanaged code enables developers to continue to use necessary COM components and DLLs. The runtime is designed to enhance performance. Although the common language runtime provides many standard runtime services, managed code is never interpreted. A feature called just-in-time (JIT) compiling enables all managed code to run in the native machine language of the system on which it is executing Finally, the runtime can be hosted by high-performance, server-side applications, such as Microsoft® SQL Server™. This infrastructure enables you to use managed code to write your business logic, while still enjoying the superior performance of the industry's best enterprise servers that support runtime hosting. .NET Framework Class Library The .NET Framework class library is a collection of reusable types that tightly integrate with the common language runtime. The class library is object oriented, providing types from which your own managed code can derive functionality. This not only makes the .NET Framework types easy to use, but also reduces the time associated with learning new features of the .NET Framework. In addition, third-party components can integrate seamlessly with classes in the .NET Framework. For example, the .NET Framework collection classes implement a set of interfaces that you can use to develop your own collection classes. Your collection classes will blend seamlessly with the classes in the .NET Framework. As you would expect from an object-oriented class library, the .NET Framework types enable you to accomplish a range of common programming tasks, including tasks such as string management, data collection, database connectivity, and file access. In addition to these common tasks, the class library includes types that support a variety of specialized development scenarios. For example, you can use the .NET Framework to develop the following types of applications and services: Console applications. Windows GUI applications (Windows Forms). Windows services. For example, the Windows Forms classes are a comprehensive set of reusable types that vastly simplify Windows GUI development. Visual Studio .NET 2003 Today Microsoft Visual Studio.Net is one of the most actively and commonly used programming toolbox based on Windows operating system platform. Microsoft Visual Studio.Net brings out new programming method, enhances speed of programming compare to traditional method, at the same time supports programming tools easy to use. On the other hand, Microsoft Visual Studio.Net helps to create interface for application fast, beautifully and friendly with users. An approach to Microsoft Visual Studio.Net follows visual way. The results of each work stage as well as whole system can be verified through step by step and supported much in programming process. Visual Studio .NET comes in any of three levels of capability and price: Professional, Enterprise Developer (which includes Microsoft's SQL Server), and Enterprise Architect (which includes the Visio product for modeling an application program). Existing users of Microsoft's Visual line and related languages may upgrade to Visual Studio .NET for a discount from the full price. Visual Studio .NET is generally comparable to Sun Microsystems' J2EE. 2.4.3 System design tool Rational Rose Rational Rose is a powerful tool that supports for object-oriented analyzing and designing developed by Rational. Rational Rose helps us modeling system before starting programming; therefore we can image system concretely from beginning to end the project. All models constructed by Rose are a panoramic picture of system. It can set up all diagrams follow visual modeling language UML such as Usecase, Sequence, State, Class diagram.It helps us modeling detailed components and operations of system. Therefore programmer can use it as a design through the process of carrying out constructing system. System modeling gives us a working process that follows approach: Request Object Model Resource Code Table 2.4.3 Working process follows system modeling approach Following this method, all members that take part in project can together discuss about system design before beginning programming, therefore all members in system can avoid misunderstanding requirements of the math. 2.4.4 Report designing tool Crystal Report for Visual Studio.Net Crystal Report for Visual Studio.Net is a tool for making standard reports of Visual Studio.Net. It brings about for programmer ability of making complex reports which has high professional degree. Instead of programming, programmer can use Crystal Report Designer to making and formatting reports. Crystal Report has powerful report processing mechanism that automatically processes all declaration about formatting, group of information or charts which programmer gives out. In Visual Studio.Net, We can make a new report or insert an available report into application. CHAPTER 3 - SYSTEM ANALYSIS 3.1 DETERMINING REQUIREMENTS OF THE SYSTEM Stock listing company management system program is developed to increase the quality and effect of management at Department for Transaction Management of HASTC. Therefore, the system not only satisfies all requirements of management such as: giving information to employee, storing information of listing companies with high security, assessing ability of employee, calculating daily transaction and so on but it is also better than the traditional exam model in managing information, security, assessing the ability of employee, etc The system consists of 7 main functions: Managing account Managing Initial Information Managing Periodic Information Managing Extraordinary Information Managing Daily Transaction Managing reports Backup and Restore Each administrator and employee is responsible for several functions and they are represented by the overview Use case diagram below: Figure 3.1 Overview Use Case of SLIMS Program Each function has tasks as follow: 3.1.1 Managing Account Account is delivered to each employee at different roles, enable to log on the system and do their specific tasks. Managing account is to ensure that each employee operates in the scope of their granted roles. Administrator is able to disable user account, change the Active Status of employee to DeActive. This means employee is not permitted to access the system but their information is still stored in the system. Figure 3.1.1 Account Usecase Diagram 3.1.2 Managing Initial Information This function is used to manage initial information. Firstly Admin create Company Name. It can be also updated or deleted. Then Employee will create general information for each company such as: Profit Plan, Stock, Shareholder, Business Area Figure 3.1.2 Initial Information Usecase Diagram 3.1.3 Managing Periodic Information This function is used to manage periodic information. Employee creates information for each company such as: Balance Sheet, Business Result, Financial Report Explanation and Bad Debt. It is also updated or deleted. Figure 3.1.3 Periodic Information Usecase Diagram 3.1.4 Managing Extraordinary Information This function is used to manage extraordinary information. Employee creates information for each company such as: Split/Attach Stock, Additional Stock and Cancel Transaction. It is also updated or deleted. Figure 3.1.4 Extraordinary Information Usecase Diagram 3.1.5 Managing Report Reports are created to give information to users. They are generated by Employee and Administrator. Figure 3.1.5 Report Usecase Diagram 3.1.6 Managing Daily Transaction This function is used to manage daily transaction. Employee imports data then checking it before calculating. Figure 3.1.5 Daily Transaction Usecase Diagram 3.2 ANALYSE SAMPLE FORMS 3.2.1 Analyze Input Form Account Add New Form: This form is used when Administrator want to register new user to become member of system. There are some information is required such as: User_ID, First Name, Last Name, Date of Birth, Address, Position, Gender and Telephone are optional. Account AddNew Form User _ID*. First Name*. Last Name:*.. Date of Birth (dd/mm/yyyy)* .. Gender (Male/Female).. Address* Telephone.. Position* Figure 3.2.1.1 Account AddNew Form Cancellation Add New Form: This form is used when Employee want to add new cancellation information. In which all fields are required. Cancellation AddNew Form Company Name* Date of Issuing Extraordinary Report*. Date of Cancellation*. Form of Cancelled Transaction* Reason of Cancellation*.. Decision of State Securities Commission (Reject/Accept)* Decision Number of State Securities Commission* Decision Date of State Securities Commission* Figure 3.2.1.2 Cancellation AddNew Form Bad Debt Add New Form: This function is used when employee want to create Bad Debt after a period. In which all fields are required. Bad Debt AddNew Form Company Name* Year*.. Period* .. Bad Debt*. Overdue Account* Figure 3.2.1.2 Bad Debt AddNew Form Balance Sheet Add New Form: This form is used to when employee want to create Balance Sheet after finishing a period. In which all fields are required. Balance Sheet AddNew Form Company Name*. Year*....... Quarter*...... Period* ...... Current Asset and Short-term Financing Cash* Short-term Financing*. Net Receivable* Inventory* Other Current Assets* Fixed Asset and Long-term Financing Tangible Fixed Asset Value* Tangible Fixed Asset Accumulated Depreciation* Intangible Fixed Asset Value* Intangible Fixed Asset Accumulated Depreciation* Long-term Financing* Long-term Deposit* Long-term Prepaid Expense* Other Expense* Liabilities Short-term Liabilities* Long-term Liabilities*... Owner's Capital Trading Capital* Fund Stock* Funds* Revenue Not Sharing*.... Figure 3.2.1.3 Balance Sheet AddNew Form Business Result Add New Form: This function is used to create Business Result after finishing a period. In which all fields are required. Business Result AddNew Form Company Name* Year*.. Quarter*.. Report Period/Accumulation* Sales and Service*.. Deducting Items* Net Sales and Service* Prime Cost* Accumulation of Sales and Service* Financing Revenue* Financing Expense* Financing Return* Sale Expense* Overhead Expense* Other Revenue* Other Expense*. Profit before Tax* Income Tax* Profit after Tax* Return from Share* Dividend Per Share* Figure 3.2.1.4Business Result AddNew Form 3.2.2 Analyze Output Form Cancellation View Form This form is used when user wants to view Cancellation information Cancellation View Form Company Name Date of Issuing Extraordinary Report. Date of Cancellation. Form of Cancelled Transaction Reason of Cancellation.. Decision of State Securities Commission.. Decision Number of State Securities Commission Decision Date of State Securities Commission Figure 3.2.2.1Cancellation View Form Bad Debt View Form This form is used when user wants to view Bad Debt information. Bad Debt View Form Company Name Year Index Opening Closing Bad Debt Overdue Account Figure 3.2.2.2 Bad Debt View Form Balance Sheet View Form This form is used when user wants to view Balance Sheet information. Balance Sheet View Form Company Name.. Year Quarter Content Opening Closing Current Asset and Short-term Financing Cash Short-term Financing Net Receivable Inventory Other Current Assets Fixed Asset and Long-term Financing Tangible Fixed Asset Value Tangible Fixed Asset Accumulated Depreciation Intangible Fixed Asset Value Intangible Fixed Asset Accumulated Depreciation Long-term Financing Long-term Deposit Long-term Prepaid Expense Other Expense Liabilities Short-term Liabilities Long-term Liabilities Other Liabilities Owner's Capital Trading Capital Fund Stock Capital Surplus Funds Revenue Not Sharing Total Capital Figure 3.2.2.3 Balance Sheet View Form Business Result View Form This form is used when user wants to view Business Result information. Business Result View Form Company Name Year Quarter. Index Report Period Accumulation Sales and Service Deducting Items Net Sales and Service Prime Cost Accumulation of Sales and Service Financing Revenue Financing Expense Financing Return Sale Expense Overhead Expense Other Revenue Other Expense Other Profit Profit before Tax Income Tax Profit after Tax Return from Share Dividend Per Share Figure 3.2.2.3 Business Result View Form 3.3 SEQUENCE DIAGRAMS 3.3.1 Sequence Diagram for Accessing To the System When user access to system, the system will automatically redirect them to their predefined task. Figure 3.3.2 Sequence Diagram for accessing to system 3.3.2 Sequence Diagram for Setting Account Figure 3.3.2 Sequence Diagram for setting account 3.3.3 Sequence Diagram for Updating Account Figure 3.3.3 Sequence Diagram for updating account 3.3.4 Sequence Diagram for Disable User Figure 3.3.4 Sequence Diagram for disable User 3.3.5 Sequence Diagram for Creating Stock Information When employee creates new stock information, system checks whether information is valid or not. If it is valid then it is saved to database. If it is invalid, employee must reinput data. Figure 3.3.5 Sequence Diagram for Creating Stock Information 3.3.6 Sequence Diagram

Các file đính kèm theo tài liệu này:

  • docV0105.doc