CHAPTER 1 – SYSTEM SPECIFICATION



TABLE OF CONTENTS

CHAPTER 1 – SYSTEM SPECIFICATION 3

1.1 SCENARIO AND QUESTION PAPER 3

1.2 BACKGROUND 6

1.3 BATCH RUN CHART 9

1.4 INFRASTRUCTURE 10

1.5 FUNCTIONAL DIAGRAM 10

1.6 DATA FLOW DIAGRAM 11

1.6.1 DFD level 0 for Knowledge Base System 11

1.6.2 DFD level 1 for User Management function 12

1.6.3 DFD level 1 for Content Management function 14

1.6.4 DFD level 1 for Category Management function 15

1.6.5 DFD level 1 for Search function 16

1.6.6 DFD level 1 for Statistics function 17

1.7 PROJECT SCHEDULE 18

1.8 DATABASE DESIGN 19

1.8.1. Normalized Forms 19

1.8.2. Entity Relationship Diagram 22

CHAPTER 2 – PROGRAM SPECIFICATION 24

2.1 PROGRAM IDENTIFICATION 24

2.2 PROGRAM DESCRIPTION 25

2.3 PROGRAM OUTLINE 26

2.4 PROGRAM SCHEDULE 27

2.5 PROGRAM ESTIMATION 27

CHAPTER 3 – INPUT SPECIFICATION 28

3.1 FILE SPECIFICATION 28

3.2 RECORD SPECIFICATION 31

CHAPTER 4 – OUTPUT SPECIFICATION 34

4.1 FILE SPECIFICATION 34

4.2 RECORD SPECIFICATION 37

4.3 PRINT LAYOUT CHART 40

CHAPTER 5 – PROGRAM DESIGN 45

5.1 FLOW CHART 45

CHAPTER 6 – PROGRAM LISTING 54

6.1 PROGRAM LISTING 54

6.2 REPORT LISTING 58

CHAPTER 7 – PROGRAM TESTING 61

7.1 TEST PLAN 61

7.2 TEST DATA 61

7.3 TEST LOG SHEET 64

7.4 PROGRAM TRACE 65

7.5 GRID CHART 67

CHAPTER 8 – OPERATING INSTRUCTIONS 68

8.1 OPERATING INSTRUCTIONS 68

8.1.1 Installation for SQL Server 2000 68

8.1.2 Installation for IIS 76

8.1.3 How to run total program 76

8.2 HARDWARE REQUIREMENT 77

8.3 SOFTWARE REQUIREMENT 77

CHAPTER 9 – LIMITATIONS 78

9.1 SCOPE AND LIMITATIONS 78

CHAPTER 1 – SYSTEM SPECIFICATION

1 SCENARIO AND QUESTION PAPER

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 students to participate fully in an advanced information society in which they live (a social rationale). Environments equipped with computers and network access are extremely useful for providing a foundation for learning, promoting independent learning, and creating better environment. To create universities that disclose information using the Internet (web sites) 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 aware of that, we failed to apply it successfully. So what are the reasons? Inadequate facilities, lack of human resource, 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.

2. Question Paper

1. What objects does the new program apply?

2. What about student/lecturer ideas?

3. How do forms represented?

4. The Web Site needs to provide?

5. How do students and lecturers solve this problem before the program is brought out?

6. Which kind of device do you take data from?

a.Magnetical tape pact Disk c.Magnetic Compact Disk

d.Hard disk port

7. How often is data exchanged?

a. Daily b. Weekly c. Fortnight d. Each month e. Each year

8. Who require to program?

9. How many peoples will access to the Web Site?

(This question helps programmer building password or security mode part in your program).

10. What level do you allow to modify input data?

11. How do you usually input data for system?

12. What information of student must you input?

13. How does program store information in order to retrieve, quickly?

14. What professional level of student and lecturer?

15. How many kinds of information services are there nowadays?

16. Are the existing information services running well?

17. Are they cost-effective and does they satisfy the student’s needs?

18. Are there any troubles for the customer when using those services?

19. Does the information provided much depends on the human knowledge?

20. Are the information provided fully and precisely?

21. Are the information services professional?

22. Does there exist any Knowledge Base System-like in Vietnam?

23. Can student get the information they desire?

24. Is the Vietnam IT infrastructure good enough for high-quality Internet services?

25. How economic benefits are for the faculty when using Knowledge Base System compared to other types of information service?

26. Does using a Knowledge Base System require professional knowledge as compared to using Internet?

27. Complaints and suggestion for the system?

28. Does it cost much to develop a Knowledge Base System?

29. Does the administration of a Knowledge Base System require very professional knowledge base for the administrator?

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 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 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.

3 BATCH RUN CHART

[pic]

As you see, there are there types oF users interact with Knowledge Base System. Depending on each of management levels, user can use functions of the system (Update information user, add article, edit category, statistic and so on)

4 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.

5 FUNCTIONAL DIAGRAM

[pic]

6 DATA FLOW DIAGRAM

1. DFD level 0 for Knowledge Base System

[pic]

The students can Register and manage their own user profile. More important, they can browse through the Knowledge Base System for information, post an article (or question), edit their own article (or questions), rate and comment to articles, they can also perform Quick Search or Advanced Search and view the system Statistic.

The Lectures can do the same things like Student, except, they’ve got the administrator handle them their username and password for the first time. They can edit and/or delete others’ article depends on the Category permission settings.

The Administrators have the privilege to access all area of the system, manage user profile including registering or escalating a username as a lecturer. They can delete all article, manage article types, category and get the Statistic of the system.

2. DFD level 1 for User Management function

[pic]

The students can Register and manage their own user profile. The Lectures have got the administrator handle them their username and password for the first time.

The Administrators have the privilege to manage user profile including registering or escalating a username as a lecturer.

3. DFD level 1 for Content Management function

[pic]

The Student can browse through the Knowledge Base System for information, post an article (or question) and edit their own articles (or questions). They can also rate or add comments to an article.

The Lectures can do the same things like the Student. Additionally, they can edit and/or delete others’ article depends on the Category permission settings.

The Administrators have the privilege to edit and/or delete all articles, manage article types and delete Comments.

4. DFD level 1 for Category Management function

[pic]

This function is reserved for system administrators only. They can add, edit (change Category name or permission), and delete a Category.

5. DFD level 1 for Search function

[pic]

All members can do a Quick Search (based on Article keywords and Article titles) or Advanced Search based on various criteria.

6. DFD level 1 for Statistics function

[pic]

All members can get a statistic on User and Content

7 PROJECT SCHEDULE

| | |Estimate |Actual | |

|ID |Task Name |

|1 |All members |

|2 |Thu Trang, Thu Hien |

|3 |Minh Hien |

|4 |Minh Hien, Anh Quy |

|5 |All members |

|6 |All members |

|7 |Minh Hien, Anh Quy |

8 DATABASE DESIGN

1. Normalized Forms

Normalized database of the Knowledge Base System has six tables in 3NF: User Table, Category Table, ArticleType Table, Article Table, Attachment Table and Comment Table

User Table in 3NF

|No |Data Items |

| |UserID* |

| |MCode |

| |FullName |

| |Gender |

| |DateOfBirth |

| |Address |

| |Telephone |

| |Email |

| |Website |

| |Occupation |

| |PersonalInfo |

| |Username |

| |RegDate |

| |Password |

| |Role |

Category Table in 3NF

|No |Data items |

| |CatID* |

| |CatName |

| |CatDescription |

| |ReadPermission |

| |WritePermission |

| |EditPermission |

| |DeletePermission |

ArticleType Table in 3NF

|No |Data Items |

| |ArticleTypeID* |

| |ArticleTypeName |

| |ArticleTypeDesc |

| |ReplyPermission |

Article Table in 3NF

|No |Data items |

| |ArticleID* |

| |ArticleName |

| |CatID |

| |ArticleTypeID |

| |ArticleKeyword |

| |AuthorID |

| |PostDate |

| |OriginalPostID |

| |ArticleRatePoint |

| |ArticleRateCount |

| |ArticleViews |

| |ArticleLastUpdated |

| |ArticleContent |

Comment Table in 3NF

|No |Data items |

| |CommentID* |

| |ArticleID* |

| |CommentUserID |

| |CommentText |

Attachment Table in 3NF

|No |Data items |

| |AtttachmentID* |

| |ArticleID* |

| |AttachmentName |

| |AttachmentDesc |

| |AttachmentPath |

| |AttachmentDownload |

2. Entity Relationship Diagram

The following diagram shows the relationship between entities in the Knowledge Base System

[pic]

CHAPTER 2 – PROGRAM SPECIFICATION

1. PROGRAM IDENTIFICATION

Project Name: KNOWLEDGE BASE SYSTEM

Programming Languages: Active Server Pages (ASP)

Database: Microsoft SQL Server 2000

Web server: Microsoft Internet Information Services (IIS)

Platform: Window 2000 Server

Design tool: Photoshop 7.0, Macromedia Dreamwaver MX

Project Supervisor: Prof. Dr. NGUYEN VIET HUONG

Hanoi University of Technology

Developers:

Project Group 5, Batch 4 of Genetic Computer School, Singapore

|DO MINH HIEN |Reg. No. 0701-023-0035 |

|PHAM THU HIEN |Reg. No. 0701-022-0025 |

|DAO ANH QUY |Reg. No. 0701-024-0052 |

|NGUYEN THI THU TRANG |Reg. No. 0701-022-0067 |

Program Size: 2.5 MB

Start Date: January 2004

End Date: 14th May 2004

2. PROGRAM DESCRIPTION

Overviews

The Knowledge Base System is created to run on Web, its objective is to delete communication gap between students and lecturers and support information exchanging effectively. Because the system uses Internet environment so it has several security modes. To access the system, user must input username and password or register new username and password. If user provides wrong username and password, his/her accessing requirement will be denied, vice versa, main page will be displayed. You can use functions of the system based on the permissions that assigned by administrators.

If you are an administrator, you can access all functions of the system such as managing contents, updating information users, adding and deleting users or categories etc.

If you are a normal user that means you are a student, you can edit personal information, post articles, ask questions, browse contents, search information or require statistics.

If you are a lecturer, you have all rights of a normal user. In addition, you have moderator’s permissions, can give instructions, material, reply information for students or delete articles with bad contents.

How the program works

The Knowledge Base System includes five main functions: User Management, Content Management, Category Management, Search and Statistics. These functions include several sub-functions. In general, all three objects (administrators, lecturers and students) joining in the system can interact with these functions but in different levels. In more details, let us consider in turn how each of functions of the system interacts with user.

First, in order to become a member of the system, user need register new username and password. User Management will verify if this username exists or not, if it is a new username, it will saved information of this user into the system’s database, on the contrary there is a announcement “this username existed” on the screen. To log in the system each of students must provide his/her username and password. If it is invalid user name and password, there is an announcement “this username does not exist or invalid password”.

After becoming a member of the system you can use functions based on your role. Content Management allows all users to post articles, rate articles, give comments, and require instructions and statistics. But you only can edit contents of an article unless you have right of an administrator, moderator or article’s author. In addition, administrators and moderators can delete articles if necessary.

Category Management is reserved for administrator, they will determine user’s rights (read, write, edit and delete) for each of types of contents. The system leans on this assignment to control accessing level of users.

Search functions allows user search information according to different criterions (search by author name, postdate, keywords, attachment and etc.)

The last function is Statistics; user can require the system return statistics such as number of users, number of articles and so on. Users also can require other information statistics about top favorite articles, articles that have highest rate points or something like that.

3. PROGRAM OUTLINE

|Input |Tab |Process |

|MCode, FullName, Gender, DateOfBirth, Address, Telephone, Email, |User Table |Insert, Update, Edit, Delete |

|Website, Occupation, PersonalInfo, Username, Password, Role | | |

|CatName, CatDescription, ReadPermission, WritePermission, |Category Table |Insert, Update, Edit, Delete |

|EditPermission, DeletePermission | | |

|ArticleName, ArticleTypeDesc, ReplyPermission |ArticleType Table |Insert, Update, Edit, Delete |

|ArticleName, ArticleKeyword, ArticleContent, ArticleRatePoint, |Article Table |Insert, Update, Edit, Delete |

|ArticleRateCount | | |

|AttachmentName, AttachmentDesc, AttachmentPath, |Attachment Table |Insert, Update, Edit, Delete |

|CommentText |Comment |Insert, Update, Edit, Delete |

|Output |FileName |

|Article List, Recent Articles, Top Favorite Articles, Unanswered |KBS .mdf |

|Questions | |

4. PROGRAM SCHEDULE

This project is start in January 2004 and ended at 14th May 2004, the implementing process is divided into 5 periods as the following figure:

5. PROGRAM ESTIMATION

In order to accomplish this project, the cost is estimated as following as:

Hardware $15,000

Software $1,000

Material $300

Manpower $1,500

Total $17,800

CHAPTER 3 – INPUT SPECIFICATION

1. FILE SPECIFICATION

User File

User file or User Table stores information about users registered to join the system.

|No |Field Name |Description |

| |UserID |The unique number defines a member |

| |MCode |The unique string defines a student or lecturer |

| |FullName |FullName of user |

| |Gender |Female, Male |

| |DateOfBirth |Date Of Birth of user |

| |Address |Contact address |

| |Telephone |Telephone number |

| |Email |Email address |

| |Website |Website address |

| |Occupation |Current occupation |

| |PersonalInfo |All concise information about one’s own self |

| |Username |Name used to access the system |

| |Password |Password is used to access the system |

| |RegDate |Date that user registered to join the system |

| |Role |Role in the system (administrator, moderator, normal user |

Category File

Category file or Category table stores information about categories of the system including name of categories, description of categories and defined permissions for each types of member.

|No |Field Name |Description |

| |CatID |The unique number defines a category |

| |CatName |Name of a category |

| |CatDescription |General description of a category |

| |ReadPermission |Permission to read articles |

| |WritePermission |Permission to write articles |

| |EditPermission |Permission to edit articles |

| |DeletePermission |Permission to delete articles |

ArticleType File

ArticleType file or ArticleType table stores information about the types of article such as types of articles, description of each type and permission to reply a certain type.

|No |Field Name |Description |

| |ArticleTypeID |The unique number defines an article type |

| |ArticleTypeName |Name of an article type |

| |ArticleTypeDesc |General description of an article type |

| |ReplyPermission |Permission that identifies which article type can be |

| | |replied |

Attachment File

Attachment file or Attachment provides information about attachments including name, description, path of attachments and download numbers of an attachment

|No |Field Name |Description |

| |AttachmentID |The unique number defines an attachment |

| |ArticleID |Number defines the article of the attachment |

| |AttachmentName |Name of an attachment |

| |AttachmentDesc |General description of an attachment |

| |AttatchmentPath |Path of an attachment |

| |AttachmentDownload |Download numbers of an attachment |

Comment File

Comment file or Comment table stores information about comments for each article.

|No |Field Name |Description |

| |CommentID |The unique number defines a comment |

| |ArticleID |Number defines the article that concerns with the |

| | |comment |

| |CommentUserID |Name of user who commented the article |

| |CommentText |Comments about an article |

Article File

Article file or Article table plays a central role in interacting with all remaining tables. This table stores all information about an article such as name of an article, type of article, author name, etc.

|No |Field Name |Description |

| |ArticleID |The unique number defines an article |

| |ArticleName |Name of an article |

| |CatID |Name of category contains the article |

| |ArticleTypeID |Types of articles (article, material, question...) |

| |ArticleKeyword |Words are often present at an article, using for search system |

| |AuthorID |Author name of an article |

| |PostDate |Date that author posts an article |

| |OriginalPostID |The number to distinguish between an original article and a |

| | |reply article |

| |ArticleRatePoint |Points a user rates for an article (based on 10 scale) |

| |ArticleRateCount |Times that an article to be rated |

| |ArticleViews |Times that an article to be viewed |

| |ArticleLastUpdated |Date, time that an article is updated lastly |

| |ArticleContent |Content of an article |

2. RECORD SPECIFICATION

User Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|MCode |nvarchar |15 |Includes characters, | | |The unique string defines a student |

| | | |number and without space | | | |

|FullName |nvarchar |50 |All | | |FullName of user |

|Gender |bit |1 |0,1 | | |Female, Male |

|DateOfBirth |datetime |8 | | | |Date Of Birth of user |

|Address |nvarchar |100 |All |Yes | |Contact address |

|Telephone |nvarchar |20 |All |Yes | |Telephone number |

|Email |nvarchar |50 |Requiring format | | |Email address |

| | | |name@domain.root | | | |

|Website |nvarchar |100 |Requiring format |Yes | |Website address |

| | | |domainname.root | | | |

|Occupation |nvarchar |50 |All |Yes | |Current occupation |

|PersonalInfo |ntext |16 |All |Yes | |All concise information about one’s own self |

|Username |nvarchar |50 |without space charracter | | |Name used to access the system |

|Password |nvarchar |30 |All | | |Password is used to access the system |

|RegDate |datetime |8 | | |getdate() |Date that user registered to join the system |

|Role |tinyint |1 |1...3 | | |Role in the system (administrator, moderator, |

| | | | | | |normal user |

Category Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|CatName |nvarchar |100 |All | | |Name of a category |

|CatDescription |nvarchar |200 |All | | |General description of a category |

|ReadPermission |tinyint |1 |4...7 | | |Permission to read articles |

|WritePermission |tinyint |1 |4...7 | | |Permission to write articles |

|EditPermission |tinyint |1 |4...7 | | |Permission to edit articles |

|DeletePermission |tinyint |1 |4...7 | | |Permission to delete articles |

ArticleType Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleTypeName |nvarchar |50 |All | | |Name of an article type |

|ArticleTypeDesc |nvarchar |200 |All | | |General description of an article type |

|ReplyPermission |bit |1 |0,1 | |1 |Permission that identifies which article |

| | | | | | |type can be replied |

Attachment Record

|Field name |Data Type |Length |Scope |Null |Default Value|Description |

|ArticleID |int |4 |1...2^31 | | |Number defines the article of the |

| | | | | | |attachment |

|AttachmentName |nvarchar |100 |All | | |Name of an attachment |

|AttachmentDesc |nvarchar |200 |All | | |General description of an attachment |

|AttatchmentPath |nvarchar |256 |without “ , / | | |Path of an attachment |

|AttatchmentDownload |smallint |2 |1...32767 | | |Download numbers of an attachment |

Article Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleName |nvarchar |150 |All | | |Name of an article |

|CatID |smallint |2 |1...32767 | | |Name of category contains the article |

|ArticleTypeID |smallint |2 |1...32767 | | |Types of articles (article, material, |

| | | | | | |question...) |

|ArticleKeyword |nvarchr |50 |All | | |Words are often present at an article, |

| | | | | | |using for search system |

|AuthorID |int |4 |1...2^31 | | |Author name of an article |

|PostDate |datetime |8 | | |getdate() |Date that author posts an article |

|OriginalPostID |int |4 |1...2^31 | |-1 |The number to distinguish between an |

| | | | | | |original article and a reply article |

|ArticleRatePoint |decimal |5(4,2) |>1 | |0 |Points a user rates for an article (based |

| | | | | | |on 10 scale) |

|ArticleRateCount |smallint |2 |1...32767 | |0 |Times that an article to be rated |

|ArticleViews |smallint |2 |1...32767 | |0 |Times that an article to be viewed |

|ArticleLastUpdated |datetime |8 | | |getdate() |Date, time that an article is updated |

| | | | | | |lastly |

|ArticleContent |ntext |16 |All | | |Content of an article |

Comment Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleID |int |4 |1...2^31 | | |Number defines the article that concerns with |

| | | | | | |the comment |

|CommentUserID |int |4 |1...2^31 | | |Name of user who commented the article |

|CommentText |ntext |16 |All | | |Comments about an article |

CHAPTER 4 – OUTPUT SPECIFICATION

1. FILE SPECIFICATION

User File

User file or User Table information is used to displayed information of members

|No |Field Name |Description |

| |UserID |The unique number defines a member |

| |MCode |The unique string defines a student or lecturer |

| |FullName |FullName of user |

| |Gender |Female, Male |

| |DateOfBirth |Date Of Birth of user |

| |Address |Contact address |

| |Telephone |Telephone number |

| |Email |Email address |

| |Website |Website address |

| |Occupation |Current occupation |

| |PersonalInfo |All concise information about one’s own self |

| |Username |Name used to access the system |

| |Password |Password is used to access the system |

| |RegDate |Date that user registered to join the system |

| |Role |Role in the system (administrator, moderator, normal user |

Category File

Category file or Category information is used to displayed information about categories.

|No |Field Name |Description |

| |CatID |The unique number defines a category |

| |CatName |Name of a category |

| |CatDescription |General description of a category |

| |ReadPermission |Permission to read articles |

| |WritePermission |Permission to write articles |

| |EditPermission |Permission to edit articles |

| |DeletePermission |Permission to delete articles |

ArticleType File

ArticleType file or ArticleType information is used to display the information about article types and is used to organize system contents.

|No |Field Name |Description |

| |ArticleTypeID |The unique number defines an article type |

| |ArticleTypeName |Name of an article type |

| |ArticleTypeDesc |General description of an article type |

| |ReplyPermission |Permission that identifies which article type can be |

| | |replied |

Attachment File

Attachment file or Attachment provides information about attachments including name, description, path of attachments and download numbers of an attachment

|No |Field Name |Description |

| |AttachmentID |The unique number defines an attachment |

| |ArticleID |Number defines the article of the attachment |

| |AttachmentName |Name of an attachment |

| |AttachmentDesc |General description of an attachment |

| |AttatchmentPath |Path of an attachment |

| |AttachmentDownload |Download numbers of an attachment |

Comment File

Comment file or Comment table stores information about comments on each article.

|No |Field Name |Description |

| |CommentID |The unique number defines a comment |

| |ArticleID |Number defines the article that concerns with the |

| | |comment |

| |CommentUserID |Name of user who commented the article |

| |CommentText |Comments about an article |

Article File

Article file or Article table plays an important role in the systems. Article file records are used for displaying information of articles.

|No |Field Name |Description |

| |ArticleID |The unique number defines an article |

| |ArticleName |Name of an article |

| |CatID |Name of category contains the article |

| |ArticleTypeID |Types of articles (article, material, question...) |

| |ArticleKeyword |Words are often present at an article, using for search system |

| |AuthorID |Author name of an article |

| |PostDate |Date that author posts an article |

| |OriginalPostID |The number to distinguish between an original article and a |

| | |reply article |

| |ArticleRatePoint |Points a user rates for an article (based on 10 scale) |

| |ArticleRateCount |Times that an article to be rated |

| |ArticleViews |Times that an article to be viewed |

| |ArticleLastUpdated |Date, time that an article is updated lastly |

| |ArticleContent |Content of an article |

2. RECORD SPECIFICATION

User Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|MCode |nvarchar |15 |Includes characters, | | |The unique string defines a student |

| | | |number and without space| | | |

|FullName |nvarchar |50 |All | | |FullName of user |

|Gender |bit |1 |0,1 | | |Female, Male |

|DateOfBirth |datetime |8 | | | |Date Of Birth of user |

|Address |nvarchar |100 |All |Yes | |Contact address |

|Telephone |nvarchar |20 |All |Yes | |Telephone number |

|Email |nvarchar |50 |Requiring format | | |Email address |

| | | |name@domain.root | | | |

|Website |nvarchar |100 |Requiring format |Yes | |Website address |

| | | |domainname.root | | | |

|Occupation |nvarchar |50 |All |Yes | |Current occupation |

|PersonalInfo |ntext |16 |All |Yes | |All concise information about one’s |

| | | | | | |own self |

|Username |nvarchar |50 |without space charracter| | |Name used to access the system |

|Password |nvarchar |30 |All | | |Password is used to access the system|

|RegDate |datetime |8 | | |getdate() |Date that user registered to join the|

| | | | | | |system |

|Role |tinyint |1 |1...3 | | |Role in the system (administrator, |

| | | | | | |moderator, normal user |

Category Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|CatName |nvarchar |100 |All | | |Name of a category |

|CatDescription |nvarchar |200 |All | | |General description of a category |

|ReadPermission |tinyint |1 |4...7 | | |Permission to read articles |

|WritePermission |tinyint |1 |4...7 | | |Permission to write articles |

|EditPermission |tinyint |1 |4...7 | | |Permission to edit articles |

|DeletePermission |tinyint |1 |4...7 | | |Permission to delete articles |

ArticleType Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleTypeName |nvarchar |50 |All | | |Name of an article type |

|ArticleTypeDesc |nvarchar |200 |All | | |General description of an article type |

|ReplyPermission |bit |1 |0,1 | |1 |Permission that identifies which article |

| | | | | | |type can be replied |

Attachment Record

|Field name |Data Type |Length |Scope |Null |Default Value|Description |

|ArticleID |int |4 |1...2^31 | | |Number defines the article of the |

| | | | | | |attachment |

|AttachmentName |nvarchar |100 |All | | |Name of an attachment |

|AttachmentDesc |nvarchar |200 |All | | |General description of an attachment |

|AttatchmentPath |nvarchar |256 |without “ , / | | |Path of an attachment |

|AttatchmentDownload |smallint |2 |1...32767 | | |Download numbers of an attachment |

Comment Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleID |int |4 |1...2^31 | | |Number defines the article that concerns with |

| | | | | | |the comment |

|CommentUserID |int |4 |1...2^31 | | |Name of user who commented the article |

|CommentText |ntext |16 |All | | |Comments about an article |

Article Record

|Field name |Data Type |Length |Scope |Null |Default Value |Description |

|ArticleName |nvarchar |150 |All | | |Name of an article |

|CatID |smallint |2 |1...32767 | | |Name of category contains the article |

|ArticleTypeID |smallint |2 |1...32767 | | |Types of articles (article, material, |

| | | | | | |question...) |

|ArticleKeyword |nvarchr |50 |All | | |Words are often present at an article, |

| | | | | | |using for search system |

|AuthorID |int |4 |1...2^31 | | |Author name of an article |

|PostDate |datetime |8 | | |getdate() |Date that author posts an article |

|OriginalPostID |int |4 |1...2^31 | |-1 |The number to distinguish between an |

| | | | | | |original article and a reply article |

|ArticleRatePoint |decimal |5(4,2) |>1 | |0 |Points a user rates for an article |

| | | | | | |(based on 10 scale) |

|ArticleRateCount |smallint |2 |1...32767 | |0 |Times that an article to be rated |

|ArticleViews |smallint |2 |1...32767 | |0 |Times that an article to be viewed |

|ArticleLastUpdated |datetime |8 | | |getdate() |Date, time that an article is updated |

| | | | | | |lastly |

|ArticleContent |ntext |16 |All | | |Content of an article |

3. PRINT LAYOUT CHART

It is very difficult to show all layouts of the program so we will introduce some of them

Home Page

[pic]

Registration Form

[pic]

Post an article

[pic]

Add new article type

[pic]

Add new category

[pic]

Advanced Search

[pic]

CHAPTER 5 – PROGRAM DESIGN

1. FLOW CHART

Register User

[pic]

Logon

[pic]

Post Article

[pic]

Delete Article

[pic]

Add Category

[pic]

Delete Category

[pic]

Add ArticleType

[pic]

Comment

[pic]

Advanced Search

[pic]

CHAPTER 6 – PROGRAM LISTING

1. PROGRAM LISTING

'----------------------------------------------------------------------------------------------------------

'connect.inc

'Connect to database

'----------------------------------------------------------------------------------------------------------

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download