¶ … eCities composes of the annual research that assists local communities to measure and benchmark their performances in order to foster economic development, entrepreneurship and job growth. The eCities also aims to create environment that will enhance expansion of business organizations within the communities. More importantly, the eCities allow the local governments to implement their projects using the online interface that connects 32 items, six factors, township, empirical index and village level data. The benefits that the eCities deliver to the stakeholders make the policy makers to decide expanding the eCities information systems to assist the organization to deliver benefits that are more meaningful to all the stakeholders.
Objective of this project is to design information systems for eCities. The project develops a data flow diagram that provides the goals of the information systems and the computer programs that will be required for the systems.
Data Flow Diagrams
A DFD (Data Flow Diagram) is a graphical representation that reveals the flow of data within the information systems.
Fig 1: Data Flow Diagrams
As being revealed in the data flow diagram, the system will perform the following functions:
1. Adding, deleting and editing student and administration researchers
2. Adding, deleting and editing communities
3. Change of the current year for the data analysis and entry
4. Editing community data
5. Changing the email templates
6. Change of text on various reports and pages
7. Importing historical data
8. Factors and Index export
9. Database Access and Webhost
However, the eCities organizational functions are too complex to be captured only by the data flow diagram. The project decomposes all the functional processes with more explicit level 1 diagram (level 1 DFD).
eCities Level 1 Diagram
Level 1 DFD 0 Process 1.0: Administration
eCities Update Demographic Export Community Data
Administration
Update Current Year E Update Help Screen
Administration
Import Historical Data Export Index
Administration
Level 1 DFD of Process: 2.0 Editing Community Data
Updated Status Community Data
Demographic Data
Community Changing current year data eCities Public Research Data
Update Community Data
Level 1 Diagram Process 3.0: Setting Up Help
Update Help Screen Help Text
Help Update
Update Current Year Update Help Screen
1 DFD of Process 4.0: Changing email templates
Update Email Template Data Submission Template
Email Subject
Email Template Update Email
Email Update
Level 1 DFD of Process 5.0: Changing text on Report and Pages
Online Application Editing Texts
Editing Texts
Login in screen Community Log in Level 1 DFD of Process 6.0: Creating Final Project Report
Export Community Summary / Data
Export Community Summary
Update Current Year Website Data
The table below reveals the software program that will be used to develop the information systems
Table 1: Software Program for the eCities
Software category
Open Source Software
Purpose
Operating system
Window XP, Window Vista Window 7 and Window 8
Desktop and server operating system
Office productivity
Microsoft office
Spreadsheets, Word processing, and Presentations
Web development
Apache web server, PHP, page tool
Hosting, Web development, and Content Management
Database management systems
Mysql
Database management and development
Internet access
Mozilla
Web Browsing
Image processing
GIMP
Image processing
Anti-virus
Avast
Protection the systems against worms, Virus, worms and trojans horse.
The diagram below reveals the data flow diagram for the software program
Conceptual Data Models
The diagram below reveals the conceptual model that consists of Entities Administration, City, Demographic and Community. The model also reveals the relationships between these Entities.
Logical Data Models
The logical data model reveals the relationships and attributes of each of the Entity.
The diagram below provides the eCities context diagram.
3. The paper provides Structured English statements for the systems
Process 1
INPUT the DATA Username, Password, First name, Last name, Email Address in the ADMINISTRATION
If Username and Password is correct
Then allow to log in Else
Display Error message end if
Process 2
INPUT the DATA Tax, Building, Development, Assessing, Financial, Census in the COMMUNITY
INPUT the DATA, Demographic Data, Tax Data, Building Data, Development Data, Accessing Data, Financial Data, Census Data in the CITY
If data are found
Display the Data
Else
Display data are not found end if
b. Decision Table
General Decision Table
Condition for Course of Action
Rules
Conditions
Administration Can have specific Data
Y
Y
Y
Input Username
Y
Y
Y
Input Password
Y
Y
Y
Action
Access Data
Y
Y
Y
Access...
All the personal and traffic data will only be accessed by authorized employees of our organization, who are to access the data to fulfill their duties. Our policy will be to protect all the data in the database from unauthorized access. Our data retention policy is to keep all data and metadata properly to prevent unauthorized access. In line with our data retention policy, our organization will protect the privacy
Database Data Warehousing Design Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and
Database Data Warehouse Design Our company, Data Analytic Limited, specializes in collecting and analyzing data for various organizations. Over the years, we have assisted various companies to turn raw data into valuable information that assists the companies in making effective decision profitable in the short and long run. Our research and data analytics are geared towards giving extra edge to various companies. Our services include processing and analyzing terabytes of data
In the contemporary business environment, the accounting profession has undergone a fundamental change, and the traditional accounting systems are no longer adequate to satisfy a recent accounting domain. Thus, a call has been made to expand the scope of accounting information systems. In response to the call, the REA data model was launched to support the accounting information systems. The REA data model is identified as the conceptual modeling tool
Pedagogic Model for Teaching of Technology to Special Education Students Almost thirty years ago, the American federal government passed an act mandating the availability of a free and appropriate public education for all handicapped children. In 1990, this act was updated and reformed as the Individuals with Disabilities Education Act, which itself was reformed in 1997. At each step, the goal was to make education more equitable and more accessible to
(Braunschweig; Day, 150) Most of the current generation of project managers expects the project management tools to furnish them with almost real-time knowledge in order to facilitate their decision-making. Some of these tools like DOFF, "Field of the Future," "Smart Fields," Microsoft's "Oilfield Connectivity" and i-Fields are currently being examined by exploration and production oil companies. Some of these tools have the capability of generating information from apparently incongruent data
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now