SYSTEM DESIGN AND TESTING
4.1 UML Diagrams
4.1.1 Use-case Diagrams
1) Use case diagram for user Figure4.1 : Use case diagram for user
2) Use case diagram for police Figure 4.2 : Use case diagram for police
3) Use case diagram for admin Figure 4.3 : Use case diagram for admin
4.1.2 System Flow Diagrams
1) System flow diagram for user
Figure 4.4 : System flow diagram for user
2) System flow diagram for police
Figure 4.5 : System flow diagram for police
3) System flow diagram for admin
Figure 4.6 : System flow diagram for admin
4.1.3 Sequence Diagrams
1) Sequence Diagram for user Figure 4.7 : Sequence diagram for user
2) Sequence diagram for police Figure 4.8 :Sequence diagram for police
3) Sequence diagram for admin
…show more content…
As the name suggests, these elements are structured around data in a way to meet the use and the organization requirements. A Data Dictionary is a list of elements that composes all the Data flow process through the system .It stores detail and descriptions of the data flow, data store and processes.
• If analyst wants to know by what other means is a table or a data item referenced in the system or where it is being used the answers are properly developed in the data Dictionary.
• The Dictionary id developed during data flow analysis and assists the analysts involved in determining system requirements. However its content is used during system design as well.
Database Tables
• Table No : 1
• Table Name :tbl_reg
• PRIMARY KEY:Reg_id
• Description : This table contains all the Major details of user.
Table Name User_register
Description This table store the information of the user which are stored when the admin successfully registers user to our Electronic Reporting
A data array is defined as “data that have been sorted in ascending or descending order” (Shannon, Groebner, Fry, & Smith, 2002, 72). The following section presents the data presented in Table 1 as a data array.
problem and it will be used in this case to build the databases. The databases
These are covered briefly in appendices in the text. The relational model was first proposed by E.F. Codd in 1970 and the first such systems were developed in 1970s. The relational model is now the dominant model for commercial data processing applications. The relational model can be used in both conceptual and logical database design. The basic structure in the model is a table .Tables consists of rows and columns. Relationships in the relational model are represented implicitly through common attributes between different relations.
As defined by Kroenke Database is an integrated, self-describing collection of related data. Data is stored in a uniform way, typically all in one place- for example, a single physical computer. A database maintains a description of the data it contains and the data has some relationship to other data in the databa...
On the output side of the data warehouse, there must be interfaces that allow a user to ask for data from the devices (PCs or terminals) that he typically use. The information in the warehouse must be structured, so that users can easily obtain answers to their questions.
Ans: Data integration consist of three processes: data access( accessing and extracting data from various sources), data federation ( combining different views of data) and capturing change. All these three process when correctly implemented provides data to ETL tool, which in turn apply its three processes and makes data available to the analysis tool of the data warehouse.
meta data - data about the data itself, such as logical database design or data dictionary definitions
8.) Data - means facts or information. People use data as a basis for drawing conclusions about the topic or theme they are studying.
A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...
Turban et al., (2011, p. 52) describes a data warehouse as being ‘a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organisation’. Turban et al., (2011, p. 52) went on to state that ‘data are usually structured to be available in a form ready for analytical processing activities (i.e. data mining, querying, reporting and other support applications)’.
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
A datum - data unit - is a symbol or a set of symbols used to represent something. The relationship between symbols and what they represent is the essence of what we mean by information. Therefore, the information interpreted data - data supplied by semantics. Knowledge of data refers to the practical use of the information. Although information can be transported, stored or shared ...
Data Warehousing – This comprehensive database is used for reporting and data analysis. The information is uploaded from a separate operational system.
Determining the tables can be the trickiest step in the database – the reports you want to print, the forms you was to use, the questions you want answered – don’t necessarily provide clues about the structure of the tables that produce them.
In database system, main data structure used in relational tables with well define values for each row and column.