Knowledge Base System Basic Knowledge
TABLE OF CONTENTS
CHAPTER 1 – OVERVIEWS............................................................................................4
CHAPTER 1 – OVERVIEWS............................................................................................4
1.1 SCENARIO ..........................................................................................................4
1.1 SCENARIO ..........................................................................................................4
1.2 BACKGROUND...................................................................................................5
1.2 BACKGROUND...................................................................................................5
1.3 INFRASTRUCTURE............................................................................................7
1.3 INFRASTRUCTURE............................................................................................7
1.4 ORGANISATION CHART..................................................................................7
1.4 ORGANISATION CHART..................................................................................7
1.5 SCOPE................................................................................................................10
1.5 SCOPE................................................................................................................10
1.5.1 Scope of application....................................................................................10
1.5.2 Target user...................................................................................................10
1.5.3 Software Requirement.................................................................................12
1.5.4 Hardware Requirement...............................................................................12
CHAPTER 2 – DEVELOPING TOOLS.........................................................................13
CHAPTER 2 – DEVELOPING TOOLS.........................................................................13
2.1 DATABASE MANAGEMENT SYSTEM (DBMS)..........................................13
2.1 DATABASE MANAGEMENT SYSTEM (DBMS)..........................................13
2.1.1 Kinds of DBMS...........................................................................................13
2.1.2 Choose DBMS and explain reasons............................................................15
2.2 PROGRAMMING LANGUAGE (PL)...............................................................17
2.2 PROGRAMMING LANGUAGE (PL)...............................................................17
2.2.1 Kinds of Programming Languages..............................................................17
2.2.2 Choose PL and explain reasons...................................................................20
CHAPTER 3 – DETERMINING REQUIREMENTS OF CURRENT SYSTEM........22
HUT – Genetic Computer School Page 1
Knowledge Base System Basic Knowledge

CHAPTER 3 – DETERMINING REQUIREMENTS OF CURRENT SYSTEM........22
3.1 ANALYZE SAMPLE FORMS...........................................................................22
3.1 ANALYZE SAMPLE FORMS...........................................................................22
3.1.1 Personnel Profile Form................................................................................22
3.1.2 Student Profile Form...................................................................................24
3.1.3 User Information Form................................................................................25
3.1.4 Category Information Form........................................................................28
3.1.5 ArticleType Information Form....................................................................30
3.1.6 Article Information Form............................................................................32
3.2 FUNCTIONAL DIAGRAM...............................................................................36
3.2 FUNCTIONAL DIAGRAM...............................................................................36
3.3 DATA FLOW DIAGRAMS...............................................................................37
3.3 DATA FLOW DIAGRAMS...............................................................................37
3.3.1 Level 0 DFD for Knowledge Base System ................................................37
3.3.2 DFD level 1 for User Management function...............................................38
3.3.3 DFD level 1 for Content Management function..........................................40
3.3.4 DFD level 1 for Category Management function........................................41
3.3.5 DFD level 1 for Search function.................................................................42
3.3.6 DFD level 1 for Statistics function..............................................................43
3.4 DATA DICTIONARY........................................................................................44
3.4 DATA DICTIONARY........................................................................................44
3.5 NEW SYSTEM IDENTIFICATION..................................................................49
3.5 NEW SYSTEM IDENTIFICATION..................................................................49
CHAPTER 4 – SYSTEM DESIGN..................................................................................50
CHAPTER 4 – SYSTEM DESIGN..................................................................................50
4.1 DATABASE DESIGN........................................................................................50
4.1 DATABASE DESIGN........................................................................................50
4.1.1 Database Normalization..............................................................................50
4.1.2 Normalize User Information Form..............................................................53
4.1.3 Normalize Category Information Form.......................................................57

HUT – Genetic Computer School Page 2
Knowledge Base System Basic Knowledge
4.1.4 Normalize ArticleType Information Form..................................................59
4.1.5 Normalize Article Information Form..........................................................61
4.1.6 Entity - Relationship Diagram ....................................................................66
4.2 PROGRAM DESIGN..........................................................................................67
4.2 PROGRAM DESIGN..........................................................................................67
4.2.1 System menu design....................................................................................67
4.2.2 Flow chart....................................................................................................70
CHAPTER 5 – OPERATING INSTRUCTIONS............................................................88
CHAPTER 5 – OPERATING INSTRUCTIONS............................................................88
5.1 OPERATING INSTRUCTIONS.........................................................................88
5.1 OPERATING INSTRUCTIONS.........................................................................88
5.1.1 Installation of SQL Server 2000..................................................................88
5.1.2 Installation for IIS.......................................................................................96
5.1.3 How to run total program............................................................................96
5.2 HARDWARE REQUIREMENT........................................................................97
5.2 HARDWARE REQUIREMENT........................................................................97
5.3 SOFTWARE REQUIREMENT..........................................................................98
5.3 SOFTWARE REQUIREMENT..........................................................................98
HUT – Genetic Computer School Page 3
Knowledge Base System Basic Knowledge
CHAPTER 1 – OVERVIEWS
1.1 SCENARIO
Information technology is becoming increasingly clear that the growth of computing and
communications technology is exceeding our understanding of its economic and social
impacts. Information technology is being used by organizations in a wide variety of settings
and ways and that information technology is critical for the smooth operation of many
organizations. Further, its usage is positively correlated with organizational productivity and
efficiency.

Change driven by information technology is having a significant impact on every aspect of
life and is an increasingly critical issue for education. Information technology is able to
improve the delivery of education and enhance student achievement. They are not only make
teaching, learning, study more convenient and easy but also ensure desired efficiency and
scientific methods. Because of the following rationales that government attempts encouraging
the use of information technology in education. The education system can prepare for students
to participate fully in an advanced information society in which they live (a social rationale).
Environments equipped with computers and network accessing are extremely useful for
providing a foundation for learning, promoting independent learning, and creating better
environment. In order to help universities that disclose information using the Internet
(websites) is an extremely useful tool for sharing information on what goes on in universities
and classrooms and for establishing a new level of exchange with caregivers and the
community. It also provides the potential to deepen and expand the understanding on students
across the entire student curriculum (a learning effectiveness rationale). And it helps them to
overcome problems of distance and isolation (an efficiency rationale). Each of these there
rationales supports each other.
The Internet has penetrated rapidly and extensively into U.S. public universities. A U.S.
Department of Education survey found that as of fall 1996, 65 percent of universities had
access to the Internet; penetration had increased by 15 percentage points in each of the prior 2
years. The Office of Technology Assessment (OTA) estimated that in 2000, U.S. universities
had 7.4 million computers for use in instruction. But in Viet Nam, instead of being fully
HUT – Genetic Computer School Page 4
Knowledge Base System Basic Knowledge
aware of that, we failed to apply it successfully. So what are the reasons? Inadequate facilities,
lack of qualified manpower, limitation on development of technology and the deficiency of
infrastructure when referring to this problem. In fact, the impact on the bulk of teaching and
learning has been minimal. Developments in paper/printing technologies have had far more
influence, with the consequence that face-to-face discussion and paper resources still
dominate public education. As the matter of fact, there is a communication gap between
lectures and students only in classrooms because of the passive way of learning. In an attempt

to handle the knowledge, students have no choice except for the traditional means such as
coming to libraries to read printed materials.
Needless to say, the application of information technology is an access road to mine of
knowledge. Therefore, applying the information technology in the field of education becomes
more and more important and pressing. And it gives us the reason to hope that the quality of
education and training in Viet Nam will be so much improved.
1.2 BACKGROUND
What is a Web-based Knowledge Base System?
A web-based Knowledge Base System is an online Knowledge resource on the net.
Knowledge Base System creates a huge archive of information on a website that help people
gain knowledge. Knowledge Base System also is a communication tool that helps people
share knowledge quickly and easily.
Objectives of Web-based Knowledge Base System
Web-based Knowledge Base System changes significantly the roles of traditional lecturer and
student. Students assume increasing responsibility for their learning while lecturers become
resources, facilitators and evaluators, guiding students in their problem-solving efforts. For
you as a learner, the ability to concentrate and to use your time well is the key to succeed.
Since the dawn of the Internet age, the online Knowledge Base System was supposed to let
great lecturers reach any student, any subject, any time, and anywhere. Online
teaching/learning are not fixed in time or space. Many students find the flexibility of online
learning a practical alternative to sitting in a campus classroom for hours on end. Students can
interact with the lecturer and their classmates at any time from anywhere to seek clarification
HUT – Genetic Computer School Page 5
Knowledge Base System Basic Knowledge
for issues they encounter in their homework assignment, to discuss topics in the course
contents, or to initiate new discussions on related topics. A successful online discussion has
the same synergistic effect as group or in-class discussion, in which students build on one
another's perspectives to gain a deeper understanding of the materials form different
perspectives.
Online Knowledge Base System engages and empowers students, increase their enjoyment

and encourage them to share and participate in their learning process. In an effective
collaborative learning environment a group of students comes together to share and learn from
one another. You are held together by a common interest in a body of knowledge and are
driven by desire and need to share problems, experiences, insights, templates, tools, and best
practices. Active participation in collaborative learning deepens your knowledge by
interacting on a daily basis. It is a channel for knowledge to flow and is a means to strengthen
the social fabric in online learning environment.
Facilitating creative dialogues between lecturers and students is the Internet's greatest
contribution to enhancing education, much more important than just putting lecture notes
online. Most face-to-face courses involve a low-level of collaboration among students and
lecturers. A Web-based environment is where the students can think and experience a
sequential flow of learning allowing "teach-yourself" by way of thinking for yourself.
Subsequently, it must allow the students interacting freely with the lecturer whenever they
need to.
Unlike face-to-face setting, where the responsibilities are ranked with emphasis on teaching
then learning, for the online learning the emphasis is on learning then teaching. From the
experience in both settings, we have realized that for online Knowledge Base System students
and lecturers are partners in the learning process. Partnership makes the success faster, less
expensive, and easier to achieve. There is great opportunity in putting this concept into the
hands of lecturers and supporting their change in thinking with exposure to excellent
mentoring. Therefore web-based system is for both students and lecturers as a team without
any separation.
Students today no longer spend all their time in a noisy lecture room or the deadly silence in
the huge reading room of a university library. These components of learning environment still
HUT – Genetic Computer School Page 6
Knowledge Base System Basic Knowledge
exist but their functionality has changed. Web-based system delivery is the beginning of a
new wave of technology development in higher education. Freeing student work from paper
and making it organized and transportable opens enormous possibilities for re-thinking whole
curricula: the evaluation of faculty, assessment of programs. Besides the required textbook a

collection of online resources replacing the traditional printed materials in the libraries must
be provided.
The impact of class size is of concern to all parties involved on Web-based learning/teaching.
It takes 2 or 3 times as much time to teach an on-line course as a face-to-face course for both
students and the Lecturers. A subject that works for 15 or 20 students now may be possible
with 100 students.
Online Knowledge Base System allows knowledge to spread near-instantly, and makes it
accessible to everyone, i.e., breaking down the walls of education. Given the ease and speed at
which information travels. Strategy using online Knowledge Base System could prove
successful not only economically, but could exploit also human resources that would foster
innovation and strengthen the democratic foundation of a knowledge-based society.
1.3 INFRASTRUCTURE
The faculty has an Information Center with more than 300 networked PCs that connect
directly to the Internet. A broadband will be implemented in a near future. The faculty also
has a server running MS Windows 2000 Server, IIS Web server and MS SQL Server 2000.
1.4 ORGANISATION CHART
The faculty of Informatics and Economic - National Economic University
National Economic University (NEU) is known to be the top Universities in Vietnam. NEU
has approximately 700 personnel including 2 People’s teachers, 29 meritorious teachers, 13
Processors, 32 Prof. Doctors, 149 Doctors, 120 Masters, 145 official lecturers, 260 lecturers.
NEU is not only famous of its qualified staffs but also the quality of training. NEU is
rewarded many medals and certificate of merit from the government. NEU’s training scale is
about 27,000 students.
HUT – Genetic Computer School Page 7
Knowledge Base System Basic Knowledge
Figure 1.4.1 - Organization chart of National Economic University
The Faculty of Informatics and Economic equips the students with knowledge of business
management and administration. On top of it, students have chance to know more about
computing and software technology which help them be able to apply the latest achievements
in information technology.

The Faculty of Informatics and Economic includes two subjects and one information
technology center:
Figure 1.4.2 –The organization chart of The Faculty of Informatics and
Economic
The faculty trains 16 subjects:
• Informatics Foundation
• Applied Informatics
• Computer Architecture
• Operating Systems
• Programming Technique 1
• Programming Technique 2
• Object Oriented Programming
HUT – Genetic Computer School Page 8
Knowledge Base System Basic Knowledge
• Data Structure and Algorithm
• Database 1
• Database 2
• MIS
• Computer Aided- Accounting
• Software Engineering
• Computer Networking
• Internet and E-Commercial
• Applied Information in Human Resource Management
Besides learning in the classroom, the students of faculty always have to depend on
traditional approach such as reference from libraries, direct exchange of ideas among
students, along with lectures’ help to search for books and support materials. And this
approach is not be efficient and still has a lot of limitation in space and time. Meanwhile,
an infrastructure with 300 personal computers connected to Internet – a support tool to
apply in information technology is not used efficiently in knowledge supporting and
sharing. By using MS Internet Information Service (MS IIS) combined with MS SQL

Server 2000 on the platform of Windows 2000 Server, National Economics University
created a website with the address of www.neu.edu.vn. However, the information
available in system is general problems such as organization of NEU, history and activities
instead of supporting lecturers and students. That is why, at right time, the Online
Knowledge Base System becomes more pressing and necessary. And it is not overstated to
say that this system is a necessary addition to the improvement of teaching quality. System
can categorize and manage huge information resources. Its function is as knowledge link
between student and lecture. It is also a mine of knowledge to both lectures and students.
Lectures can exchange experience as well as provide the information, knowledge and
material for students. Through efficient ways of research, students can avail themselves of
opportunity to be in contact with the ocean of knowledge classified. As a matter of course,
HUT – Genetic Computer School Page 9
Knowledge Base System Basic Knowledge
students are also received swiftly and efficient support from lectures and easily share
knowledge and experience together.
1.5 SCOPE
1.5.1 Scope of application
Knowledge Base System can be applied for many fields like education: in universities,
institutes; to create supporting system for communities in exchanging knowledge and
information, so on. In other words, the system helps narrowing spatial gap, searching
information conveniently and becoming an efficient supporting tool for studying and teaching.
In addition, the system can be used for customer support services.
1.5.2 Target user
Typical objects of the system are described in the following figure:
Figure 1.5.2 – Mechanism of Knowledge Base System
HUT – Genetic Computer School Page 10
Knowledge Base System Basic Knowledge
The Knowledge Base System supports three main user classes: Lectures, Students and
Administrators. The system also will provide three basic blocks of functions, which are
 Categorized information browsing

 Information searching
 Online Supporting
In the new system, information will be categorized into specific categories. Information also
will be divided into specific types of information (e.g. articles, materials, e-books).
Lectures will play an important role in the system that provide useful information for the
community and also control the information flow. Lectures will have many tools such as
 Post articles, materials or resources
 Answer questions asked by students
 Edit, Update and Delete existing information
 Search information from the system
Students are information seeking users can browse through categorized information and have
the support from lectures. Some facilities that students will have are
 Browse through categorized information
 Post comments or suggestions on articles
 Edit or Delete their own articles
 Ask questions that will be answered by lectures
 Search information from the system
Administrators can benefit from easy-to-use system utilities to maintain the system in an
efficient fashion. Some utilities are
 User management, which provide tools for managing user information
HUT – Genetic Computer School Page 11
Knowledge Base System Basic Knowledge
 Content management, which provide tools for categorize information and control the
information resource structure.
 System utilities, which provide many tools for managing the system, such as system
statistics, traffic counter, system backup and restore. All the information can be
exported to pre-designed reports that can be printed.
1.5.3 Software Requirement
 Windows 2000 Server (Server Packet 3 or higher)
 SQL 2000 Server Enterprise Edition (Server Packet 1)

 Internet Explorer 5X (optional)
1.5.4 Hardware Requirement
The optimal hardware configuration is designed to meet the demands of maintenance in the
next 3 years.
HUT – Genetic Computer School Page 12
Components Minimum +MS SQL Server Optimum
CPU Pentium 133Mhz Pentium 166Mhz Xeon 2.4Ghz
Disk Capacity 671MB 270MB 32GB SCSI/RAID5
RAM 128MB 256MB 1 GB
Monitor 640x480 800x600 800x600
CD-ROM 12x 52x
Optional Mouse/Compatible pointing device
Knowledge Base System Basic Knowledge
CHAPTER 2 – DEVELOPING TOOLS
2.1 DATABASE MANAGEMENT SYSTEM (DBMS)
2.1.1 Kinds of DBMS
There are many different types of DBMS, ranging from small systems that run on personal
computers to huge systems that run on mainframes. Now we will introduce some types of
DBMS before choose one: Oracle, SQL, Access, MySql etc.
Oracle
Oracle is a relational database system from Oracle corporation extensively used in product
and internet-based applications in different platforms. Oracle is a powerful relational database
management system that offers a large feature set. Along with Microsoft SQL Server, Oracle
is widely regarded as one of the two most popular full-featured database systems today.
Oracle is only used for databases with huge size, from millions to tens of millions records.
This DBMS runs based on Client/Server model, can adopt different operating systems and
security level. Because of complexity of database so disadvantages of Oracle are high cost of
maintaining database and training IT staff.
Microsoft Access
Microsoft Access is a relational database running under Microsoft Windows. Access is the

desktop database included in Microsoft’s popular productivity suite Microsoft Office. The
product may connect with many different databases, but it is shipped with the Microsoft JET
Engine, and in this paper the two terms are synonymous, unless otherwise noted. The
inclusion of Access in the MS Office Suite enables MS Office users to create simple database
applications very inexpensively. The arguments for using MS Access are very strong because
of its low cost and its backward compatibility. Access also uses very few resources and is
easily distributed, since the application and data can be stored in a single file. However,
popularity does not always translate into successful applications. Access applications typically
start as a single-user application created by the user for his or her specific use. But, many
times another individual in the organization sees value in the application and the application is
HUT – Genetic Computer School Page 13
Knowledge Base System Basic Knowledge
then shared. This sharing can proliferate to the point where a single Access application,
designed for one user, is servicing multiple users, something normally handled by a full
server-based database management system. With more than one person using the application,
the data storage requirements also increase. These increases can quickly eclipse the limits
Access imposes. Growth in either the user count or data storage eventually leads to
degradation in performance and stability. Corruption also occurs at a much higher rate in
Access than in server-based database management systems. In a server-based system, only the
database server engine itself accesses the file, while in a file sharing system like Access, all
users have access to the file. This multiple and unmanaged access is the most common cause
of data corruption in an Access data file. Though all database systems face some risk of
corruption, the possibility is exponentially higher in Access, because the architecture is built
on file sharing.
Microsoft SQL Server
SQL Server 2000 is a relational database management system (RDBMS) using Transact_SQL
to exchange information between Client computer and SQL Server computer. A RDBMS
consists of databases, database engine and applications that use to manage data. SQL Server
2000 can integrate in harmony with other servers such as Internet Information Services (IIS),
E-Commerce Server, Proxy Server, etc.

Although SQL Server 2000 is designed to work as the data storage engine for thousands of
concurrent users who connect over a network, it is also capable of working as a stand-alone
database directly on the same computer as an application. The scalability and ease-of-use
features of SQL Server 2000 allow it to work efficiently on a single computer without
consuming too many resources or requiring administrative work by the stand-alone user. The
same features allow SQL Server 2000 to dynamically acquire the resources required to
support thousands of users, while minimizing database administration and tuning.
MYSQL
MySQL, the most popular Open Source SQL database management system, is developed,
distributed, and supported by MySQL AB company, it’s also a relational database
management system. MySQL software is Open Source means it is possible for anyone to use
and modify the software. Anybody can download the MySQL software from the Internet and
HUT – Genetic Computer School Page 14
Knowledge Base System Basic Knowledge
use it without paying anything. The MySQL Database Server is very fast, reliable, and easy to
use. MySQL Server also has a practical set of features developed in close cooperation with
our users. MySQL Server was originally developed to handle large databases much faster than
existing solutions and has been successfully used in highly demanding production
environments for several years. Though under constant development, MySQL Server today
offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL
Server highly suited for accessing databases on the Internet. The MySQL Database Software
is a client/server system that consists of a multi-threaded SQL server that supports different
backends, several different client programs and libraries, administrative tools, and a wide
range of application programming interfaces (APIs).
2.1.2 Choose DBMS and explain reasons
Choosing DBMS is a very important decision, it should base on different factors such as
infrastructure, human resource, volume of information etc. The Knowledge Base System is
designed for students and lecturers of the Faculty of Informatics and Economic in information
exchanging, thus size of database is not over large. With current infrastructure, MSSQL
Server is a suitable choice along with many benefits:

 Utilizing existing infrastructure
 MS SQL Server is easy-to-use and has user friendly interface
 Low overhead
 Integrated with Microsoft IIS
MS SQL Server is a perfect DBMS, provides a new generation of features and functions,
including many strong tools for managing and controlling database. Microsoft SQL Server
2000 features include:
 Internet Integration.
The SQL Server 2000 database engine includes integrated XML support. It also has the
scalability, availability, and security features required to operate as the data storage
component of the largest Web sites. The SQL Server 2000 programming model is integrated
with the Windows DNA architecture for developing Web applications, and SQL Server 2000
HUT – Genetic Computer School Page 15
Knowledge Base System Basic Knowledge
supports features such as English Query and the Microsoft Search Service to incorporate user-
friendly queries and powerful search capabilities in Web applications.
 Scalability and Availability.
The same database engine can be used across platforms ranging from laptop computers
running Microsoft Windows® 98 through large, multiprocessor servers running Microsoft
Windows 2000 Data Center Edition. SQL Server 2000 Enterprise Edition supports features
such as federated servers, indexed views, and large memory support that allow it to scale to
the performance levels required by the largest Web sites.
 Enterprise-Level Database Features.
The SQL Server 2000 relational database engine supports the features required to support
demanding data processing environments. The database engine protects data integrity while
minimizing the overhead of managing thousands of users concurrently modifying the
database. SQL Server 2000 distributed queries allow you to reference data from multiple
sources as if it were a part of a SQL Server 2000 database, while at the same time, the
distributed transaction support protects the integrity of any updates of the distributed data.
Replication allows you to also maintain multiple copies of data, while ensuring that the

separate copies remain synchronized. You can replicate a set of data to multiple, mobile,
disconnected users, have them work autonomously, and then merge their modifications back
to the publisher.
 Ease of installation, deployment, and use.
SQL Server 2000 includes a set of administrative and development tools that improve upon
the process of installing, deploying, managing, and using SQL Server across several sites.
SQL Server 2000 also supports a standards-based programming model integrated with the
Windows DNA, making the use of SQL Server databases and data warehouses a seamless part
of building powerful and scalable systems. These features allow you to rapidly deliver SQL
Server applications that customers can implement with a minimum of installation and
administrative overhead.
 Data warehousing.
HUT – Genetic Computer School Page 16
Knowledge Base System Basic Knowledge
SQL Server 2000 includes tools for extracting and analyzing summary data for online
analytical processing. SQL Server also includes tools for visually designing databases and
analyzing data using English-based questions.
In addition, Microsoft SQL Server 2000 extends the performance, reliability, quality, and
ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes
several new features that make it an excellent database platform for large-scale online
transactional processing (OLTP), data warehousing, and e-commerce applications.
The OLAP Services feature available in SQL Server version 7.0 is now called SQL Server
2000 Analysis Services. The term OLAP Services has been replaced with the term Analysis
Services. Analysis Services also includes a new data-mining component.
The Repository component available in SQL Server version 7.0 is now called Microsoft SQL
Server 2000 Meta Data Services. References to the component now use the term Meta Data
Services. The term repository is used only in reference to the repository engine within Meta
Data Services.
2.2 PROGRAMMING LANGUAGE (PL)
2.2.1 Kinds of Programming Languages

There are mainly 2 kinds of scripting on the Internet, client-side scripts that executes at the
users machine, and server-side. Server-side language is script/language, which runs on the
server and not the browser’s machine. Some of the more common languages are: PHP, ASP,
JSP and Perl. Each language is different - either slightly or completely, much like real
languages. Your choice of server-side language depends on what you want to do with the
script you are writing.
PHP
PHP (PHP Hypertext Preprocessor) is one of the most popular server-side scripting on web.
Server-side scripting is a web server technology in which a user's request is fulfilled by
running a script directly on the web server to generate dynamic HTML pages. It is usually
used to provide interactive web sites that interface to databases or other data stores. This is
different from client-side scripting where the viewing web browser, usually in JavaScript,
HUT – Genetic Computer School Page 17
Knowledge Base System Basic Knowledge
runs scripts. The primary advantage of server-side scripting is the ability to highly customize
the response based on the user's requirements, access rights, or queries into data store PHP is
a widely used scripting language that is especially suited for server-side applications to
develop dynamic web and can be embedded into HTML. One of the more attractive parts of
PHP is that it is more than just a scripting language, thanks to its modular design; PHP can
also be used to develop GUI applications and it can be used from the command line like Perl.
PHP allows easy interaction with a large number of relational databases (Oracle, DB2, MySql,
etc.) while maintaining a simple and straightforward syntax. PHP runs on every major
operating system, including Linux, Unix, Windows and Mac OSX and can interact with all
major web servers. PHP, unlike Perl and ASP, has some of the largest free and open-source
libraries include with the core built.
ASP
Active Server Page is Microsoft’s server-side technology for dynamically generated web
pages. Page can be generated by mixing server-side scripting code with HTML and client-side
code. Programming ASP websites is made easier by various built-in objects, such as cookie
based session object that maintains variables from page to page. ASP has some advantages

like
 Script Language-independent: ASP allows using VBScript, Jscript or Perl
("perlscript") and have it executed on the server without having to learn another
scripting language
 Utilize COM components from your web server - reuse any functionality built using
COM components for your company's software product can on your website through
ASP pages. ASP is the connection between the conventional software and the web
site.
 ODBC links to any data source
 You can use server-side Active components (DLLS)
ASP also several restrictions such as only run on Windows NT / IIS
JSP
Java Server Page is a Java technology that allows developers to dynamically generate HTML,
XML or some other type of web page. The technology allows Java code and certain pre-
HUT – Genetic Computer School Page 18
Knowledge Base System Basic Knowledge
defined actions to be embedded into static content. The JSP syntax adds additional XML tags;
call JSP actions, to be used to invoke built-in functionally. Additionally, the technology
allows for the creation of JSP tag libraries that act as extensions to the standard HTML and
XML tags. JSPs are compiled into Servlets by a JSP compiler. Using JSP gives some
advantages:
 Power of Java
 Familiar Language for the designers
 Persistent Sessions: One of the most important features of a server-side language is
tracking sessions so that data can be transferred from page to page. JSP and Servlets
provide a nice API for managing this called Http Session. JSP requires you to notify
the page that you wish for a session to start and then register all of the variables that
you wish to track with the session. Other pages can then access these variables and
their values. Unlike PHP though, JSP solely relies on cookies to perform this task. If
the user does not accept cookies, the programmer has to do some extra work to make

JSP perform Session tracking through the URL instead of through cookies.
Disadvantages are:
 Difficult Install of Necessary Components: because JSP relies on Servlet technology,
it requires the installation of a servlet engine in order to function. This engine is
responsible for transforming the JSP page into the corresponding Servlet page as well
as compiling the Servlets. The most popular engine currently available is Tomcat,
which is developed by the Jakarta Project and distributed freely under the Apache
Software License. Tomcat can act as a stand-alone web-server but in order to make it
communicate with Apache (a far superior web-server) an extra installation is
necessary, more specifically the Apache module mod_jk must be installed. Finally, in
order for any of these to work, Java itself must be installed on the machine. That is
three components that must be installed and maintained in order for JSP to work.
 Overly Complex: JSP implements several changes to help make Java a more "web-
friendly" language but there are still various nuances of the language, which make it
cumbersome to perform specific tasks. Accessing a database is a prime example of
where Java is overly complex.
HUT – Genetic Computer School Page 19
Knowledge Base System Basic Knowledge
Perl
Perl is a programming language that is used to create server-side web applications. Like Java
or Active Server Pages (ASP), two competitive technologies, Perl is an object-based,
interpreted language. As a result, it is easier to write, easier to maintain, and easier to extend
then other languages such as C or C++. Unlike Java and ASP however, Perl is not embedded
into web servers by default. In other words, Perl applications typically run stand alone, not
requiring the use of a specially designed, and often costly, application servers. The benefits of
Perl as a development tool lie in the fact that Perl applications require little infrastructure.
Thus entry costs are minimized and the simpler application architectures assure that
applications are less expensive to build, maintain and extend. On the other hand, Perl
applications may be slower and less scalable for certain types of applicatons. However, if
customers require more speed or scalability, they may install a Perl accelerator such as

ModPerl or Velocogen. Using a Perl accelerator, Perl may be embeded into any web server
just like Java or ASP.
2.2.2 Choose PL and explain reasons
We decide to choose ASP because of many factors like costs, easy-to-use, easy-to-debug,
existing infrastructure and one more important factor is this programming language need
integrate well with chose Database Management System.
Microsoft Active Server Pages (ASP) is a server-side scripting environment that you can use
to create and run dynamic, interactive Web server applications. With ASP, you can combine
HTML pages, script commands, and COM components to create interactive Web pages or
powerful Web-based applications, which are easy to develop and modify.
Organizations will use the Active Server Pages technology to put a Web front end on existing
business solutions, or to create entirely new Web-based applications. Since ASP provides a
very open development environment, with support for both Microsoft Visual Basic®,
Scripting Edition (_VBScript) and _JScript, organizations can leverage the investments they
already have in these scripting languages.
Active Server Pages also has the following considerable advantages:
HUT – Genetic Computer School Page 20
Knowledge Base System Basic Knowledge
 Active Server Pages is a component of IIS 3.0, which is a free, downloadable, and
integrated feature of Windows NT Server 4.0.
 Active Server Pages can work with any Web browser. The output of an ASP file is
plain HTML, the content of which can be customized for the capabilities of the client.
 Active Server Pages allows you to define application and session variables that can be
carried across multiple pages in a Web site. This can be as simple as remembering a
user's name, and it is necessary in applications such as online shopping to track
product selections
 Active Server Pages makes it easy to bring legacy database applications to the Web.
 It is quick and easy to interact with MS SQL using Active Server Pages.
HUT – Genetic Computer School Page 21
Knowledge Base System Basic Knowledge

CHAPTER 3 – DETERMINING REQUIREMENTS OF CURRENT
SYSTEM
3.1 ANALYZE SAMPLE FORMS
According to traditional management method, each of lecturers and students of the Faculty of
Informatics and Economic – NEU have to fill personal information in two separate forms:
Personnel Profile and Student Profile form. But these forms have not corresponded to the
objective of the new system yet, so we introduced a new form that meets requirements of the
system and can be used for both objects. This form is called User Profile and because of
requirements of the new system, we also designed some other new forms consist of Category
form, ArticleType form and Article form. In order to understand more clearly, you can see the
following forms
3.1.1 Personnel Profile Form
This form gives requirements to each of lecturer, staff working in the Faculty of Informatics
and Economic, consists of some personal information, qualifications and outline of process of
work
PERSONNEL PROFILE
Current Name ....................................................................................................................................
Birthname...........................................................................................................................................
Staff Code ..........................................................................................................................................
DateOfBirth.........................................................................................................................................
Birthplace...........................................................................................................................................
Place of origin.....................................................................................................................................
Residence:...........................................................................................................................................
Contact Address:.................................................................................................................................
HUT – Genetic Computer School Page 22
Photo
Knowledge Base System Basic Knowledge
Ethnic group: ...........................................................Religion.............................................................
Members of family:.............................................................................................................................
Your own class background:...............................................................................................................

Level of instruction:............................................................................................................................
Degree:................................................................................................................................................
University teacher’s rank....................................................................................................................
Foreign languages:..............................................................................................................................
Starting date:.......................................................................................................................................
Recruiting date:...................................................................................................................................
Staff date:............................................................................................................................................
Date joining the political group:.........................................................................................................
Admitting place:.................................................................................................................................
Date and place joining the Vietnam Communist Party:.....................................................................
Formal date:........................................................................................................................................
Referee adhering the Communist Party:.............................................................................................
Health:.................................................................................................................................................
Factors of major rate of pay:...............................................................................................................
Historical process of work:.................................................................................................................
Figure 3.1.1 – Personnel Profile Form
HUT – Genetic Computer School Page 23
Knowledge Base System Basic Knowledge
3.1.2 Student Profile Form
All students of the Faculty of Informatics and Economics must fill necessary information in
the following form. Managers will use this information to contact, monitor their students.
National Economic University
The Faculty of Informatics and
Economics
Socialist Republic of Vietnam
Independent - Freedom - Happiness
STUDENT PROFILE
FullName:.....................................................................................................................
DOB: ............................................................................................................................
Student Code: ...............................................................................................................

Class: ............................................................................................................................
Residence:......................................................................................................................
Contact Address:...........................................................................................................
Telephone: ....................................................................................................................
Figure 3.1.2 - Student Profile Form
Figure 3.1.1 and 3.1.2 include information of personnel who are teaching and working in the
Faculty of Informatics and Economics and information of students studying here. Some
information has not corresponded to the characteristics of new environment and requirements
of new system yet. Therefore, we added some new data items and simultaneously, delete
unnecessary fields.
It is very difficult to manage information members and operate the system if information
member is decomposed into individual items. Hence, information of members who join in the
HUT – Genetic Computer School Page 24
Photo
Knowledge Base System Basic Knowledge
system: administrators, lecturers and students will be gathered in unique form. This form
called “User Information Form”.
3.1.3 User Information Form
USER INFORMATION
UserID (*):.........................................................................................................................
MCode: ..............................................................................................................................
FullName: ..........................................................................................................................
Gender: ..............................................................................................................................
DateOfBirth........................................................................................................................
Address: .............................................................................................................................
Telephone: .........................................................................................................................
Email .................................................................................................................................
Website: .............................................................................................................................
Occupation: .......................................................................................................................
PersonalInfo: .....................................................................................................................

...............................................................................................................................................
.........................................................................................................................................
Username: ..........................................................................................................................
Password: ..........................................................................................................................
RegDate (*): ......................................................................................................................
Role: ...[ ] Administrator...[ ] Moderator...[ ] User
(Items with the symbol (*) is generated by the system automatically)

Figure 3.1.3 – User Information Form
HUT – Genetic Computer School Page 25