Thomaset2000’s Room

Hi All!

This is the fourth part for C2006 Project: System Development Module. Haven’t read the first part yet? you can find the first part by clicking here. I uploaded my old Analysis Documentation for this module in the previous post.

In this post I will upload my old project Design Documentation for this module. Feel free to see it for your reference. Basically this Design documentation documents your plan to design your system. It includes the Data Flow Diagram (DFD) from your Analysis Documentation and also structure design and user interface design concept.

My old Design Documentation is as follows:

C2006

System Development

DESIGN DOCUMENTATION

“Clover Company”

Event Organizer’s System

Team Member            : 1. David Irawan          / 018800004337

2. Keith Nishan F       / 018800004402

3. Thomas Setiabudi / 018800004137

Content

Page

Table of Contents_ 2

I. Description Of New System_ 3

I. a. Narrative_ 3

I. b. Illustration Supporting Narrative_ 5

I. b. 1. Company’s Organization Chart 5

I. c. Process Flows 6

I. c. 1. Proposed System Context Diagram_ 6

I. c.3. 2^nd level Data Flow Diagram (1.0 Receive Order) 8

I. c. 4. 2^nd level Data Flow Diagram (2.0 Sales Process) 9

I. c. 5. 2^nd level Data Flow Diagram (3.0 Update) 10

I. c. 6. 2^nd level Data Flow Diagram (4.0 Report) 11

II. Detailed Design_ 12

II. a. Entity Relationship Diagram_ 12

II. b. Data Structure_ 14

II. c. Architectural Design_ 16

II. d. Procedural Design_ 18

II. d. 1. System Flowchart 18

II. e. Interface Design_ 28

II. e. 1. Common interface elements 28

II. e. 2. Main Menu_ 30

Description Of New System

I. a. Narrative

Clover Company’s Online System

This online system will be able to facilitate the company’s customer to place their order online. So virtually the customer will be able to access the system anywhere as long as the customer has an internet access. Before a customer can place their order, he/she has to register first by filling the registration form. After the customer submits the registration form, the system will send an e-mail to the customer’s e-mail to verify the registration. After the registration is verified, now the customer can place their order. While filling the order form, the customer will get many options to customize his/her order specification, such as options for catering company, event documentation, event place, etc. The customer will also able to make online payment for their order.

All the data and information inputted in this system will be stored in a database. Data about the customer registration, order data, online payment data, company’s financial data, and also data about the affiliate companies is stored in the system’s database. Besides storing data, the database will also used to generate various reports according to the company’s need.

Another system’s features for the customer are order tracking feature and customer feedback feature. Firstly, the order tracking feature allows the customer to get up to date information about the progress of his/her order. The customer will also be able to make changes to his/her order specification or get informed by the company if the order’s specification must be changed. Secondly, the customer can give a feedback to the company through the system if the customer is not satisfied by the company’s service or system or if the customer sees a room for improvement. This customer feedback will be reviewed by the company and be considered as suggestion to improve the company’s system or service.

Besides providing services for the company’s customer, the online system will also helps the company’s relation with its affiliate companies such as food Supplier Company, logistic company, event documenter company, printing company, etc. The online system will provide feature for a representative of each affiliate company to login into the system. After the affiliate company’s representative has login to the system, now he/she can use the system’s features for the affiliate company. There are some system feature for the affiliate company, they are: User Profile Module, Update Availability Schedule, Booking Status Module, and Feedback Module. The User Profile Module is used to display the detail information about the affiliate company, the user can edit or update some of this information if there is any changes in the affiliate company’s profile like contact number or address. Update Availability Schedule is a module where the affiliate company can keep their schedule synchronized with the Clover Company’s schedule. For example, Company A that provide event documentation service enter that it is available on 20 August 2008, then when a customer that want to order for an event on that date, the customer will see company A is in the option and can be chosen. The third module is booking status module, this module will be a reminder for an affiliate company to remind it about what are the dates that it is booked. And then the affiliate company can confirm the booking if they can do it. A confirmed booking from an affiliate company will update the order status that can be checked by the customer via order status tracking module.

The last part of the system is the administrator area, this part is used by the staffs of the Clover Company and no unauthorized person can access this area as this area is secured using password and the login page is not appear in the website’s main page. So, the staff of the company will need to open the login page, enter the user id and password, and then login to the system. After the staff login in the system, then he/she can use the features of the system that are: order management module, customer management module, affiliate company management module, company schedule and reminder, report generator, and finance report module.

Using the order management module provides ability for the Clover Company’s staff to manage all the orders from the customers. The staff can see each order detail and update the order preparation progress when it’s necessary. The Clover Company can tell the customer if there is any change to the order specification through this module. Customer management module will help the company to manage its customer data. The availability schedule from each affiliate company can be checked using affiliate company management module. The Clover Company also can check which companies available are for a certain date. Additionally, the Clover Company can check the status of an affiliate company about how many order that request its service, whether all the request have been confirmed, etc. The Clover Company also can send e-mail to any affiliate company if there is something urgent to ask. Moreover, the company can see its schedule and get reminded for upcoming events by the system too. While, for report generation there are report generator module and finance report module. Report generator module is used generate many kind of reports from the system database. It can produce reports like customer data report, affiliate companies report, report about the orders received in a certain period, etc. These reports can be used for an onscreen viewing only or printed to be used as meeting materials. And finally, The Company’s finance department can use finance report module to generate the company’s financial report. It has many categories of what period of time should the report show and also report for general condition or report on per case basis (e.g. report for each order).

I. b. Illustration Supporting Narrative

I. b. 1. Company’s Organization Chart

I. c. Process Flows

I. c. 1. Proposed System Context Diagram

I. c. 2. Proposed System 1^st level Data Flow Diagram

I. c.3. 2^nd level Data Flow Diagram (1.0 Receive Order)

I. c. 4. 2^nd level Data Flow Diagram (2.0 Sales Process)

I. c. 5. 2^nd level Data Flow Diagram (3.0 Update)

I. c. 6. 2^nd level Data Flow Diagram (4.0 Report)

II. Detailed Design

II. a. Entity Relationship Diagram

Entities:

1. Customer
   1. customer_id
   2. name
   3. gender
   4. date_of_birth
   5. e-mail
   6. phone
   7. ic/passport number

viii.      password

1. Affiliate
   1. affiliate_id
   2. name
   3. phone
   4. e-mail
   5. password
   6. service

1. Order
   1. order_id
   2. date
   3. customer_id
   4. affiliate_id_1
   5. affiliate_id_2
   6. affiliate_id_3
   7. payment_id

1. Schedule
   1. schedule_id
   2. date
   3. available

1. Payment
   1. payment_id
   2. status
   3. amount
   4. duedate
   5. type
   6. customer_id

a. Customer

Detail information of the customer

Data Element	Data Type	Size	Description	Validation
customer_id	Autonumber	10	Primary Key	No duplicate
name	Text	50	Customer name	-
gender	Text	1	Customer gender	M/F
date_of_birth	Date/Time	-	Customer date of birth	dd/mm/yyyy
e-mail	Text	40	Customer e-mail	e-mail format
IC/Passport no.	Text	10	Customer IC/Passport	-
Password	Text	20	Customer Password	-
Phone	Text	15	Customer phone no.	Number

b. Affiliate

Data Element	Data Type	Size	Description	Validation
affiliate_id	Autonumber	10	Primary Key	No duplicate
name	Text	50	Affiliate name	-
Phone	Text	15	Affiliate phone no.	Number
e-mail	Text	40	Affiliate e-mail	e-mail format
Password	Text	20	Affiliate Password	-
Service	Text	30	Affiliate company’s service	-

c. Order

Data Element	Data Type	Size	Description	Validation
Order_id	Autonumber	10	Primary Key	No duplicate
Date	Date/Time	-	Order’s date	dd/mm/yyyy
customer_id	Integer	10	Customer’s id	Valid id
affiliate_id_1	Integer	10	1st Affiliate id	Valid id
affiliate_id_1	Integer	10	2nd Affiliate id	Valid id
affiliate_id_1	Integer	10	3rd Affiliate id	Valid id
payment_id	Integer	10	Order’s payment id	Valid id

d. Schedule

Data Element	Data Type	Size	Description	Validation
schedule_id	Autonumber	10	Primary Key	No duplicate
Date	Date/Time	-	Available date	dd/mm/yyyy
Available	Text	30	Affiliate company available on a date	-

e. Payment

Data Element	Data Type	Size	Description	Validation
payment_id	Autonumber	10	Primary Key	No duplicate
Type	Text	10	Payment type	-
Status	Text	50	Payment Status	-
due date	Date/time	-	Payment due date	dd/mm/yyyy
Amount	Number	10	Amount of payment	Numeric
customer_id	Integer	10	Customer’s id	Valid id

f. Admin

Data Element	Data Type	Size	Description	Validation
admin_id	Autonumber	10	Primary Key	No duplicate
e-mail	Text	40	Affiliate e-mail	e-mail format
Password	Text	20	Affiliate Password	-

g. News

Data Element	Data Type	Size	Description	Validation
news_id	Autonumber	10	Primary Key	No duplicate
news title	Text	100	News title	-
News content	Text	1000	News content	-
Picture	Text	100	News picture address	-
date	Date/time	-	Date of the news	dd/mm/yyyy

II.c. Architectural Design

II.d. Procedural Design

II.d.1. System Flowchart

II.e. Interface Design

In this part, we will show rough design of the system’s interface. The system will be displayed to the user as web pages, so it will more or less have the typical design of a web page such as header and left panel with buttons or hyperlinks. The buttons and text that will be shown here is just the essential buttons and text in the system. The actual system will have decorative elements such as pictures, texts, and features.

II.e.1. Common Interface Elements

Common interface elements are interface elements that will be shown in all the pages. There are three items fall on this category: header, left panel, and footer. Since these two items will be present in all the screens, so we will explain them separately here to reduce redundancy.

II. e. 1. i. header

No.	Item	Type	Description
1.	Header image	Picture	Picture and company logo
2.	Text 1	Date	Current date
3.	Text 2	Text	Login status of user
4.	Hyperlink	Hyperlink	Will show “login” or “logout”

II. e. 1. ii. left panel

No.	Item	Type	Description
1.	Hyperlink 1	Hyperlink	Home
2.	Hyperlink 2	Hyperlink	News
3.	Hyperlink 3	Hyperlink	Login
4.	Hyperlink 4	Hyperlink	Register
5.	Hyperlink 5	Hyperlink	About Us
6.	Hyperlink 6	Hyperlink	Contact us

II. e. 1. iii. footer

No.	Item	Type	Description
1.	Hyperlink 1	Hyperlink	Home
2.	Hyperlink 2	Hyperlink	News
3.	Hyperlink 3	Hyperlink	Login
4.	Hyperlink 4	Hyperlink	Register
5.	Hyperlink 5	Hyperlink	About Us
6.	Hyperlink 6	Hyperlink	Contact us
7.	Text 1	Text	Copyright

II.e.2. Main Menu

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Content	Text, pictures	The content of main page, newest news, promotion, services, etc.

II.e.3. News

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	News title and hyperlink
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator

II.e.4. Login

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1	Text	Customer login (default)
5.	Text 2	Text	User id
6.	Text 3	Text	Password
7.	Text box 1	Text input
8.	Text box 2	Password input
9.	Button	Button	Submit button
10.	Hyperlink 1	Hyperlink	Customer login page
11.	Hyperlink 2	Hyperlink	Affiliate login page
12.	Hyperlink 3	Hyperlink	Administrator login page

II.e.5. Customer

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Hyperlink 1	Hyperlink	Profile
5.	Hyperlink 2	Hyperlink	Make Order
6.	Hyperlink 3	Hyperlink	Payment
7.	Hyperlink 4	Hyperlink	Order status
8.	Hyperlink 5	Hyperlink	Logout

II.e.6. Profile

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Hyperlink 1	Hyperlink	Edit
5.	Hyperlink 2	Hyperlink	Back
6.	Profile	Text	Customer/affiliate company’s profile from database

II.e.7 Make Order

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Order Form	Text, text box, radio button, check box, combo box	Form that customer fill to make new order.
5.	Button	Button	Submit button for order form
6.	Hyperlink 1	Hyperlink	Back

II.e.8. Payment

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Payment Form	Text, text box, radio button, check box, combo box	Form that customer fill to make payment.
5.	Button	Button	Submit button for payment form
6.	Hyperlink 1	Hyperlink	Back

II.e.9. Order Status (Customer)

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	Order 1, 2, and 3 (if any)
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator
7.	Hyperlink 1	Hyperlink	Edit Order
8.	Hyperlink 2	Hyperlink	Back

II.e.10. Affiliate

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Hyperlink 1	Hyperlink	Profile
5.	Hyperlink 2	Hyperlink	Upload Schedule
6.	Hyperlink 3	Hyperlink	Order Status
7.	Hyperlink 4	Hyperlink	Logout

II.e.11. Upload Schedule

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Upload Schedule Form	Text, text box, radio button, check box, combo box	Form that an affiliate company fill to upload schedule order.
5.	Button	Button	Submit button for order form
6.	Hyperlink 1	Hyperlink	Back

II.e.12. Order Status (Affiliate)

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	Order 1, 2, and 3 (if any)
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator
7.	Hyperlink 1	Hyperlink	Approve
8.	Hyperlink 2	Hyperlink	Reject
9.	Hyperlink 3	Hyperlink	Back

II.e.13. Administrator

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Hyperlink 1	Hyperlink	Reports
5.	Hyperlink 2	Hyperlink	Order management
6.	Hyperlink 3	Hyperlink	Manage customer & Affiliate
7.	Hyperlink 4	Hyperlink	Manage News
8.	Hyperlink 5	Hyperlink	Logout

II.e.14. Report

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1	Text	Report Type
5.	Combo Box	Combo box	List of available report types
6.	Button	Button	Submit button to execute selected report type
7.	Hyperlink 1	Hyperlink	Back

II.e.15. Order Management

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	Order 1, 2, and 3 (if any)
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator
7.	Hyperlink 1	Hyperlink	Edit order
8.	Hyperlink 2	Hyperlink	Delete order
9.	Hyperlink 3	Hyperlink	Back

II.e.16. Manage Customer & Affiliate

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	Customer/affiliate 1, 2, and 3 (if any)
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator
7.	Hyperlink 1	Hyperlink	Customer list
8.	Hyperlink 2	Hyperlink	Affiliate list
9.	Hyperlink 3	Hyperlink	Add profile
10.	Hyperlink 4	Hyperlink	Edit profile
11.	Hyperlink 5	Hyperlink	Delete
12.	Hyperlink 6	Hyperlink	Back

II.e.17. Manage News

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Text 1, 2, and 3	Text and Hyperlink	News 1, 2, and 3 (if any)
5.	Text 4	Text	Page indicator
6.	Hyperlinks	Hyperlink	Page navigator
7.	Hyperlink 1	Hyperlink	Add News
8.	Hyperlink 2	Hyperlink	Edit News
9.	Hyperlink 3	Hyperlink	Delete News
10.	Hyperlink 4	Hyperlink	Back

II.e.18. Register

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Registration Form	Text, text box, radio button, check box, combo box	Form that customer fill to register.
5.	Button	Button	Submit button for order form
6.	Hyperlink 1	Hyperlink	Back

II.e.19. About us

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Content	Text, pictures	The content of about us – company’s profile

II.e.20. Contact Us

No.	Item	Type	Description
1.	Header		Refer to II. e. 1. i. header
2.	Left Panel		Refer to II. e. 1. ii. left panel
3.	Footer		Refer to II. e. 1. iii. footer
4.	Content	Text, pictures	The content of contact us page – company’s contact and address.

III. Hardware and Software Selection

III.a. Hardware Specification

The minimum hardware specification to operate this system is:

1.      Intel Pentium IV processor or better

2.      Minimum 512 Mb RAM

3.      Color Monitor

4.      Keyboard

5.      Mouse with scroll button

6.      160 GB hard disk

7.      DSL Internet connection

8.      Laser Printer or Dot Matrix Printer

For the web server itself, we will host the website on another commercial web server, so we don’t need to buy the expensive web server computer for the company.

III.b. Software Specification

Ø  Development Software

The software that is used to develop this new system:

1.      Notepad ++

2.      PHP editor

3.      PHP (Personal Home Page)

4.      phpMyAdmin

5.      FileZilla

6.      Apache HTTP server

7.      MySQL

8.      Adobe Dreamweaver

9.      Adobe Photoshop

10.  Core FTP

Ø  Operational Software

The minimum requirement of the software to operate the system:

1.      Windows XP or Windows Vista

2.      Internet Browser (Mozilla Firefox v.2 or Internet Explorer 7)

– End Of Design Documentation –

To Be Continued in the next post…

Coming next, I will post my old project Final documentation for this module.

Any Question?

Feel free to ask me about this module using the comment section below.

admin Education, IADIC C2006, C2006 Project, C2006 Project: System Development, Design, Design Documentation, flowchart, IADIC, Informatics, screen design, user interface design