Internet Technology
Content
Institute of Management and Technology
A230CT: Internet Technology
Assignment
Name: Nguyen Xuan Phong Student ID: 07091041
Lecturer name: Mr. Raj
Date of submission: 22th September 2009
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
TABLE OF CONTENT
Content Table of content Introduction BREADTALK Proposed system Business Rules
1) Market Segmentation and Market Analysis 2) Target Audience 3) Details of the IT infrastructure and the online system plan
Design Specification Costing and Budgeting Conclusion Reference
Page number 2 3 4 5 5 6 7 10 24 25 26
Page 2
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
INTRODUCTION BREADTALK
BreadTalk Group was incorporated in Singapore in April 2000 as BreadTalk Pte Ltd and has since become a distinctive brand in Singapore that has gained international appeal. It was founded by the current Managing Director, George Quek and his wife, Executive Director, Katherine Lee. The first BreadTalk retail outlet opened on 1st July 2000 at Parco Bugis Junction. A second outlet opened within 5 months, in December 2000, at Novena Square, followed by the first HDB heartlands outlet in Bishan. In September 2001, BreadTalk invested $3 million to set up a central kitchen at KA FoodLink, Kampong Ampat to prepare for growth and franchise operations. Initially, BreadTalk outlets offered about 50 varieties of breads, buns, cakes and pastries, but this has grown to over 150 varieties today. In addition, during 2001, another five retail outlets were opened. As of April 2003, BreadTalk had 22 retail outlets in Singapore with staff strength at 434. In the same month, it opened its first franchise outlet in Jakarta. In June, BreadTalk underwent an initial public offering (IPO), constituting of 32 million shares (28.8 million by placement and 3.2 million by public offer) at an offer price of S$0.24 per share. In September, the Group diversified into the restaurant business by operating a franchise of the world-renowned Din Tai Fung brand of restaurants in Singapore. In 2005, BreadTalk penetrated further into the China market by acquiring Topwin Investment Holding Pte Ltd which owns and operates 13 food courts under the award-winning brand Megabite in China. In the same year, the Group entered a joint venture with Ristoranti Group to open 2 Food Republic food courts in Suntec City and VivoCity in Singapore1, both featuring retrospective style and décor, as well as one in Hong Kong‟s Cityplaza in Tai Koo Shing. In addition, Toast Box, a traditional kopitiam-styled coffee house serving coffee and toast to customers in an atmosphere of pop culture in fashion and music reminiscent of the 1950‟s-60s
1
Food Republic Singapore -- http://en.wikipedia.org/wiki/Food_Republic
Page 3
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
colonial era in Singapore2, was opened as a food stall unit of Food Republic in Wisma Atria Singapore. As of December 2006, the Group owned and operated 57 bakery outlets in Singapore, Shanghai, Beijing and Thailand. The BreadTalk brand has also rapidly infiltrated the region with 73 franchised outlets in Indonesia, the Philippines, United Arab Emirates, Kuwait, Malaysia, Taiwan, Hong Kong, India and China.3 BreadTalk Group now operates 5 Din Tai Fung restaurants in Singapore located in shopping centers which enjoy high human traffic. On 17 Dec 2007, BreadTalk Group Limited entered into a franchise agreement to acquire and manage the J. Co Donuts & Coffee, an Indonesian brand.
PROPOSED SYSTEM
As the business is going well, we need to redesign the IT infrastructure and the online system to be more efficient. The reason is also because the business has expanded across several geographical locations, not only in Singapore and also over sea. In order to increase sales in next year, 2010, we need to improve our system to help customer order online easily and conveniently. Thus, we need to make E-Commerce transactions on our website to provide new services for customer. Extensive communication is provided among the staff and customers. The customers can have their feedback online, fast and easy to reach the staff.
2 3
JobStreet.com: Toast Box -- http://siva-sg.jobstreet.com/_profile/previewProfile.asp?advertiser_id=33315 BreadTalk Annual Report 2006, downloaded from www.BreadTalk.com
Page 4
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
BUSINESS RULES
1) Market segmentation and market analysis:
BreadTalk‟s direct competitors in its bakery business include large and diverse groups of bakery chains and individual operators. Competitors include Bengawan Solo, Delifrance, Four Leaves, Prima Deli Bakery, Crystal Jade Bakery as well as bakeries at various shopping malls, hotels and neighborhoods. Competitors provide similar product offerings at highly competitive prices. It is observed that neighborhood bakeries sell its pastries at a significantly cheaper price compared to other types of bakeries. Six bakeries, which are selected to be most similar to BreadTalk in terms of product offerings, price ranges and locations were documented in detail.
Peer Bengawan Solo Business Analysis This cake and „kueh‟ (traditional pastry) retail chain targets the premium market segment based on nearly everything from the sophisticated décor of its shops to the pricing of its products. It is generally perceived as having an authentic and traditional recipe. The quality of Bengawan Solo‟s cakes and pastries are generally regarded as high and very consistent despite its long presence in the industry. It could threaten BreadTalk‟s premium-priced products although Bengawan Solo generally has lesser varieties while BreadTalk keeps innovating new products.
Cyrstal Jade Kitchen
This bakery is unique because it actually takes up a small section of its other business which is the Crystal Jade Kitchen restaurant. It uses a complementary strategy of attracting customers who are already dining in the restaurant to savor treats from the bakery as a form of appetizer or dessert. Its products are generally quite similar in variety and price as BreadTalk, based on common Chinese delicacies hence making it a close competitor. Both companies also have restaurants as corporate strategies. A very close competitor of BreadTalk because it constantly innovates with new products and customers has a large variety to choose from. It sells popular local delicacies such as floss buns, it also has a comprehensive range of other products such as cakes, Swiss pastries and French bread. Its retail strategy is very similar to BreadTalk, having stores at high volume areas with attractive décor.
Four Leaves
Prima Deli
It offers products very similar to traditional bakeries in the heartlands. Like BreadTalk, its products are priced at a premium. Most, if not all of its retail activities are concentrated in upscale places such as shopping centers. Its cakes and pastries could pose both as a close competitor and as a mainstay substitute to BreadTalk‟s products which are primarily innovative concoctions.
Page 5
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Q-Bread
Like Four Leaves and BreadTalk, Q-Bread‟s strategy is to locate in strategic upscale areas with a high volume of traffic. Retail space is generally small and many varieties of buns and pastries litter its shelves. Bread is a close competitor with BreadTalk because of similar prices and introduction of similar products which are reincarnations of previous ones. Sweet Secrets is synonymous with innovation and creative products. That is why it is probably BreadTalk‟s greatest threat. Without resorting to hype-generating media coverage, Sweet Secrets competes from a different perspective. It incorporates technological processes such as its latest invention “Photo cakes” where food colorings are used to replicate prints on cake surfaces. It also has licenses with Disney to use images of characters such as Winnie the Pooh in its products.
Sweet Secrets
2) Target Audience:
In today‟s world people are too busy in their daily routines that they hardly find time to sit down and enjoy on meal this is the main reason for the tremendous increase in the number of fast food retails like BreadTalk. The customer‟s current needs are a quick but delicious meal at a reasonable price. BreadTalk outlets are characterized by a white minimalist, space-age décor, coupled with the extensive use of see-through glass panels, the glass fittings are clean cut look punctuated also with detailing of contrasting colors with artworks, unique to each locale. When peoples look at BreadTalk signature they allowed to see through the glass in the kitchens their chefs creating a bright-looking fluorescent lit-boutique-like feel that allows people from outside the shop to look in also can watch the chefs making the delectable bread and pastry concoctions from start to finish. Customers also enjoy a breezy and trendy ambience in these boutique bakeries. Customers can sharing the preparation of the freshly browned breads, each piece will be looks creative and the bread and pastries are displayed on sleek white plastic and glass shelves like clothes on display in a showrooms by their expertise staffs to keep and safely. In the bakery creating a wonderful potpourri of colors and smells that attract long queues of people to buy, Stylish plastic carriers used for purchases are trendy looking and carries over the minimalist concept of pure white packaging. it will show that how do they keep public relationship to increase profit margin and brand name. To attract peoples Breadtalk made some of the hot favorite ideas is that the numerous varieties of bread it has in their recipes .Boutique concept has been popularized by the Breadtalk in Singapore with glass shelf and racks for display is the main attraction for the consumers. In the modern and busiest world some people may not spent more time in all food service industries also peoples are willing to eat fast food or bakery products and they expecting new trends of products because of this criteria bakery and fast food industries
Page 6
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
has to follow some of new and attractive trends to keep, maintain their regular and new consumers. Also there are much more competitors introducing in the bakery industry it should be affect on sales and earnings of the benefits as for this bakery industries has to to a survey or research about current trends.
3) Details of the IT infrastructure and the online system plan:
i) Server roles and their configuration: Roles Roles, a new feature of SQL Server 7.0 which was not with earlier versions, perform like Windows NT local group. Server roles is one of the several roles supported by MS SQL Server, the others being database and application roles. Server Roles At the server level is defined the server roles which lie outside users databases. Server roles are fixed and cannot be added, deleted or modified. Users can only be added as server roles member. Types Fixed server roles are of seven types-sys admin, server admin, setup admin, security admin, process admin, db creator and disk admin. All activities in SQL Server can be performed by sys admin server role members and overall database functions are completely controlled by them. The function of the members of the server admin server role is to change server configuration parameters and shutting down of the server. Setup admin server role members can add or remove linked servers, manage replication and extended stored procedures. Some system stored procedures like sp server option can be executed by this role. Creation and management of server logins and auditing and reading error logs are done by security admin server role members. Management of the processes that run in SQL Server is done by process admin server role members. Database creation, alteration and resizing are the functions of db creator server role members. Disk files are managed by disk admin server role members. ( Reference : mssqlguide.n.d ) Secure connections: Secure Sockets Layer (SSL) technology protects our Web site and makes it easy for our Web site visitors to trust us in three essential ways: An SSL Certificate enables encryption of sensitive information during online transactions. Each SSL Certificate contains unique, authenticated information about the certificate owner. A Certificate Authority verifies the identity of the certificate owner when it is issued.
ii)
-
Page 7
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
iii)
Internet Connectivity and Network Connectivity Devices:
Internet connectivity among the company iv) DNS configuration: Domain Name System (DNS) servers host records of a distributed DNS database and use the records they host to resolve DNS name queries sent by DNS client computers, such as queries for the names of Web sites or computers in your network or on the Internet. If you plan to use this computer to answer DNS queries for computers in your network, then add the DNS server role. We choose the DNS is: www.breadtalk.org This process involves using the Configure Your Server Wizard, the Configure a New DNS Server Wizard, and Manage Your Server to configure the server as a DNS server. When you have finished setting up a DNS server, you can complete additional configuration tasks, depending on how you want to use the DNS server. ( Reference : technet.microsoft.n.d )
Page 8
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
v)
Telecomputing purpose and significance: As the business is going well, we need to redesign the IT infrastructure and the online system to be more efficient. The reason is also because the business has expanded across several geographical locations, not only in Singapore and also over sea. In order to increase sales in next year, 2010, we need to improve our system to help customer order online easily and conveniently. Thus, we need to make E-Commerce transactions on our website to provide new services for customer. Extensive communication is provided among the staff and customers. The customers can have their feedback online, fast and easy to reach the staff.
Page 9
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
DESIGN SPECIFICATION
Online system ( web development ):
This is the Home Page of Breadtalk. It includes some introductions about the company and our business.
Page 10
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the About Us Page of Breadtalk. It provides the Mission, Vision and also the List of awards of the company.
Page 11
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Contact us Page provides all the outlets address of Breadtalk. It also has the contact details such as Address, Telephone number, Fax, Email…
Page 12
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Product List Page Provides all the products Breadtalk wants to sell online. It contains the Image, Name, Price and summary of the products. Each product can be seen in More details.
Page 13
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
These are the product details:
Page 14
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Page 15
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Page 16
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the Service List Page of Breadtalk. It provides Delivery Service and Bakermaking Training Service. Each has the email to contact.
Page 17
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Calendar Page contains the Calendar of the present time. It also listed upcoming important events of the Business.
Page 18
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the Employee List of the company. It provides the information about Breadtalk‟s Board of Directors.
Page 19
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
In the Feedback Page, we provide the form for the customer to write feedback about the company. As you can see, customer can type what they want and it will be emailed to the staff member to analysis.
Page 20
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Order Form Page provides the secure payment for customers. It contains the form for the customer to fill in and it will send to the order database to process.
Page 21
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Respond Form Page helps the customer evaluate the business of Breadtalk. It contains the some evaluation questions and multiple choices answer for customers.
Page 22
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The last page is FAQ (Frequently Asked Questions) Page. It contains some questions that customers may need to know about the company.
Page 23
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
COSTING AND BUDGETING
1) Costing:
To develop and maintain the websites and also the online service, we have to spend S$3000. For each month of maintenance after launching the website, it costs $500.
2) Budgeting:
The Budget of the company for Project Development is S$5000. So we have enough of money and the profit gaining from online service will be divided to maintain the website.
3) Expected revenue gained:
If the project is successful, we expect to gain more S$3.000.000 in revenue for next year.
Page 24
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
CONCLUSION
Global marketplace - Your web site can be accessed from anywhere in the world, which now means you could sell to anyone ANYWHERE. No middleman - By selling directly to the customers you can now cut out the middleman. 24 Hour business - If your web site can process payment information you can now be open 24 hours a day! Increased customer information - Instead of posting your latest brochure or clients account statement, why not allow them to access it via your web site?
The Internet can open up new avenues for your business to buy and sell products or services online, with such activities generically referred to as ecommerce. The business relationships provided by ecommerce can be broadly split into two main areas: 1. Business to consumer (B2C) - where you sell products or services directly to individual consumers 2. Business to business (B2B) - where you sell goods or services to other businesses Reference: seyeneco.n.d
Page 25
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
REFERENCE
http://en.wikipedia.org/wiki/Business_rule http://en.wikipedia.org/wiki/Target_audience http://en.wikipedia.org/wiki/Business_rule_management_system http://www.breadtalk.com/breadtalk/
Page 26
A230CT: Internet Technology
Assignment
Name: Nguyen Xuan Phong Student ID: 07091041
Lecturer name: Mr. Raj
Date of submission: 22th September 2009
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
TABLE OF CONTENT
Content Table of content Introduction BREADTALK Proposed system Business Rules
1) Market Segmentation and Market Analysis 2) Target Audience 3) Details of the IT infrastructure and the online system plan
Design Specification Costing and Budgeting Conclusion Reference
Page number 2 3 4 5 5 6 7 10 24 25 26
Page 2
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
INTRODUCTION BREADTALK
BreadTalk Group was incorporated in Singapore in April 2000 as BreadTalk Pte Ltd and has since become a distinctive brand in Singapore that has gained international appeal. It was founded by the current Managing Director, George Quek and his wife, Executive Director, Katherine Lee. The first BreadTalk retail outlet opened on 1st July 2000 at Parco Bugis Junction. A second outlet opened within 5 months, in December 2000, at Novena Square, followed by the first HDB heartlands outlet in Bishan. In September 2001, BreadTalk invested $3 million to set up a central kitchen at KA FoodLink, Kampong Ampat to prepare for growth and franchise operations. Initially, BreadTalk outlets offered about 50 varieties of breads, buns, cakes and pastries, but this has grown to over 150 varieties today. In addition, during 2001, another five retail outlets were opened. As of April 2003, BreadTalk had 22 retail outlets in Singapore with staff strength at 434. In the same month, it opened its first franchise outlet in Jakarta. In June, BreadTalk underwent an initial public offering (IPO), constituting of 32 million shares (28.8 million by placement and 3.2 million by public offer) at an offer price of S$0.24 per share. In September, the Group diversified into the restaurant business by operating a franchise of the world-renowned Din Tai Fung brand of restaurants in Singapore. In 2005, BreadTalk penetrated further into the China market by acquiring Topwin Investment Holding Pte Ltd which owns and operates 13 food courts under the award-winning brand Megabite in China. In the same year, the Group entered a joint venture with Ristoranti Group to open 2 Food Republic food courts in Suntec City and VivoCity in Singapore1, both featuring retrospective style and décor, as well as one in Hong Kong‟s Cityplaza in Tai Koo Shing. In addition, Toast Box, a traditional kopitiam-styled coffee house serving coffee and toast to customers in an atmosphere of pop culture in fashion and music reminiscent of the 1950‟s-60s
1
Food Republic Singapore -- http://en.wikipedia.org/wiki/Food_Republic
Page 3
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
colonial era in Singapore2, was opened as a food stall unit of Food Republic in Wisma Atria Singapore. As of December 2006, the Group owned and operated 57 bakery outlets in Singapore, Shanghai, Beijing and Thailand. The BreadTalk brand has also rapidly infiltrated the region with 73 franchised outlets in Indonesia, the Philippines, United Arab Emirates, Kuwait, Malaysia, Taiwan, Hong Kong, India and China.3 BreadTalk Group now operates 5 Din Tai Fung restaurants in Singapore located in shopping centers which enjoy high human traffic. On 17 Dec 2007, BreadTalk Group Limited entered into a franchise agreement to acquire and manage the J. Co Donuts & Coffee, an Indonesian brand.
PROPOSED SYSTEM
As the business is going well, we need to redesign the IT infrastructure and the online system to be more efficient. The reason is also because the business has expanded across several geographical locations, not only in Singapore and also over sea. In order to increase sales in next year, 2010, we need to improve our system to help customer order online easily and conveniently. Thus, we need to make E-Commerce transactions on our website to provide new services for customer. Extensive communication is provided among the staff and customers. The customers can have their feedback online, fast and easy to reach the staff.
2 3
JobStreet.com: Toast Box -- http://siva-sg.jobstreet.com/_profile/previewProfile.asp?advertiser_id=33315 BreadTalk Annual Report 2006, downloaded from www.BreadTalk.com
Page 4
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
BUSINESS RULES
1) Market segmentation and market analysis:
BreadTalk‟s direct competitors in its bakery business include large and diverse groups of bakery chains and individual operators. Competitors include Bengawan Solo, Delifrance, Four Leaves, Prima Deli Bakery, Crystal Jade Bakery as well as bakeries at various shopping malls, hotels and neighborhoods. Competitors provide similar product offerings at highly competitive prices. It is observed that neighborhood bakeries sell its pastries at a significantly cheaper price compared to other types of bakeries. Six bakeries, which are selected to be most similar to BreadTalk in terms of product offerings, price ranges and locations were documented in detail.
Peer Bengawan Solo Business Analysis This cake and „kueh‟ (traditional pastry) retail chain targets the premium market segment based on nearly everything from the sophisticated décor of its shops to the pricing of its products. It is generally perceived as having an authentic and traditional recipe. The quality of Bengawan Solo‟s cakes and pastries are generally regarded as high and very consistent despite its long presence in the industry. It could threaten BreadTalk‟s premium-priced products although Bengawan Solo generally has lesser varieties while BreadTalk keeps innovating new products.
Cyrstal Jade Kitchen
This bakery is unique because it actually takes up a small section of its other business which is the Crystal Jade Kitchen restaurant. It uses a complementary strategy of attracting customers who are already dining in the restaurant to savor treats from the bakery as a form of appetizer or dessert. Its products are generally quite similar in variety and price as BreadTalk, based on common Chinese delicacies hence making it a close competitor. Both companies also have restaurants as corporate strategies. A very close competitor of BreadTalk because it constantly innovates with new products and customers has a large variety to choose from. It sells popular local delicacies such as floss buns, it also has a comprehensive range of other products such as cakes, Swiss pastries and French bread. Its retail strategy is very similar to BreadTalk, having stores at high volume areas with attractive décor.
Four Leaves
Prima Deli
It offers products very similar to traditional bakeries in the heartlands. Like BreadTalk, its products are priced at a premium. Most, if not all of its retail activities are concentrated in upscale places such as shopping centers. Its cakes and pastries could pose both as a close competitor and as a mainstay substitute to BreadTalk‟s products which are primarily innovative concoctions.
Page 5
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Q-Bread
Like Four Leaves and BreadTalk, Q-Bread‟s strategy is to locate in strategic upscale areas with a high volume of traffic. Retail space is generally small and many varieties of buns and pastries litter its shelves. Bread is a close competitor with BreadTalk because of similar prices and introduction of similar products which are reincarnations of previous ones. Sweet Secrets is synonymous with innovation and creative products. That is why it is probably BreadTalk‟s greatest threat. Without resorting to hype-generating media coverage, Sweet Secrets competes from a different perspective. It incorporates technological processes such as its latest invention “Photo cakes” where food colorings are used to replicate prints on cake surfaces. It also has licenses with Disney to use images of characters such as Winnie the Pooh in its products.
Sweet Secrets
2) Target Audience:
In today‟s world people are too busy in their daily routines that they hardly find time to sit down and enjoy on meal this is the main reason for the tremendous increase in the number of fast food retails like BreadTalk. The customer‟s current needs are a quick but delicious meal at a reasonable price. BreadTalk outlets are characterized by a white minimalist, space-age décor, coupled with the extensive use of see-through glass panels, the glass fittings are clean cut look punctuated also with detailing of contrasting colors with artworks, unique to each locale. When peoples look at BreadTalk signature they allowed to see through the glass in the kitchens their chefs creating a bright-looking fluorescent lit-boutique-like feel that allows people from outside the shop to look in also can watch the chefs making the delectable bread and pastry concoctions from start to finish. Customers also enjoy a breezy and trendy ambience in these boutique bakeries. Customers can sharing the preparation of the freshly browned breads, each piece will be looks creative and the bread and pastries are displayed on sleek white plastic and glass shelves like clothes on display in a showrooms by their expertise staffs to keep and safely. In the bakery creating a wonderful potpourri of colors and smells that attract long queues of people to buy, Stylish plastic carriers used for purchases are trendy looking and carries over the minimalist concept of pure white packaging. it will show that how do they keep public relationship to increase profit margin and brand name. To attract peoples Breadtalk made some of the hot favorite ideas is that the numerous varieties of bread it has in their recipes .Boutique concept has been popularized by the Breadtalk in Singapore with glass shelf and racks for display is the main attraction for the consumers. In the modern and busiest world some people may not spent more time in all food service industries also peoples are willing to eat fast food or bakery products and they expecting new trends of products because of this criteria bakery and fast food industries
Page 6
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
has to follow some of new and attractive trends to keep, maintain their regular and new consumers. Also there are much more competitors introducing in the bakery industry it should be affect on sales and earnings of the benefits as for this bakery industries has to to a survey or research about current trends.
3) Details of the IT infrastructure and the online system plan:
i) Server roles and their configuration: Roles Roles, a new feature of SQL Server 7.0 which was not with earlier versions, perform like Windows NT local group. Server roles is one of the several roles supported by MS SQL Server, the others being database and application roles. Server Roles At the server level is defined the server roles which lie outside users databases. Server roles are fixed and cannot be added, deleted or modified. Users can only be added as server roles member. Types Fixed server roles are of seven types-sys admin, server admin, setup admin, security admin, process admin, db creator and disk admin. All activities in SQL Server can be performed by sys admin server role members and overall database functions are completely controlled by them. The function of the members of the server admin server role is to change server configuration parameters and shutting down of the server. Setup admin server role members can add or remove linked servers, manage replication and extended stored procedures. Some system stored procedures like sp server option can be executed by this role. Creation and management of server logins and auditing and reading error logs are done by security admin server role members. Management of the processes that run in SQL Server is done by process admin server role members. Database creation, alteration and resizing are the functions of db creator server role members. Disk files are managed by disk admin server role members. ( Reference : mssqlguide.n.d ) Secure connections: Secure Sockets Layer (SSL) technology protects our Web site and makes it easy for our Web site visitors to trust us in three essential ways: An SSL Certificate enables encryption of sensitive information during online transactions. Each SSL Certificate contains unique, authenticated information about the certificate owner. A Certificate Authority verifies the identity of the certificate owner when it is issued.
ii)
-
Page 7
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
iii)
Internet Connectivity and Network Connectivity Devices:
Internet connectivity among the company iv) DNS configuration: Domain Name System (DNS) servers host records of a distributed DNS database and use the records they host to resolve DNS name queries sent by DNS client computers, such as queries for the names of Web sites or computers in your network or on the Internet. If you plan to use this computer to answer DNS queries for computers in your network, then add the DNS server role. We choose the DNS is: www.breadtalk.org This process involves using the Configure Your Server Wizard, the Configure a New DNS Server Wizard, and Manage Your Server to configure the server as a DNS server. When you have finished setting up a DNS server, you can complete additional configuration tasks, depending on how you want to use the DNS server. ( Reference : technet.microsoft.n.d )
Page 8
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
v)
Telecomputing purpose and significance: As the business is going well, we need to redesign the IT infrastructure and the online system to be more efficient. The reason is also because the business has expanded across several geographical locations, not only in Singapore and also over sea. In order to increase sales in next year, 2010, we need to improve our system to help customer order online easily and conveniently. Thus, we need to make E-Commerce transactions on our website to provide new services for customer. Extensive communication is provided among the staff and customers. The customers can have their feedback online, fast and easy to reach the staff.
Page 9
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
DESIGN SPECIFICATION
Online system ( web development ):
This is the Home Page of Breadtalk. It includes some introductions about the company and our business.
Page 10
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the About Us Page of Breadtalk. It provides the Mission, Vision and also the List of awards of the company.
Page 11
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Contact us Page provides all the outlets address of Breadtalk. It also has the contact details such as Address, Telephone number, Fax, Email…
Page 12
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Product List Page Provides all the products Breadtalk wants to sell online. It contains the Image, Name, Price and summary of the products. Each product can be seen in More details.
Page 13
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
These are the product details:
Page 14
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Page 15
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
Page 16
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the Service List Page of Breadtalk. It provides Delivery Service and Bakermaking Training Service. Each has the email to contact.
Page 17
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Calendar Page contains the Calendar of the present time. It also listed upcoming important events of the Business.
Page 18
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
This is the Employee List of the company. It provides the information about Breadtalk‟s Board of Directors.
Page 19
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
In the Feedback Page, we provide the form for the customer to write feedback about the company. As you can see, customer can type what they want and it will be emailed to the staff member to analysis.
Page 20
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Order Form Page provides the secure payment for customers. It contains the form for the customer to fill in and it will send to the order database to process.
Page 21
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The Respond Form Page helps the customer evaluate the business of Breadtalk. It contains the some evaluation questions and multiple choices answer for customers.
Page 22
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
The last page is FAQ (Frequently Asked Questions) Page. It contains some questions that customers may need to know about the company.
Page 23
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
COSTING AND BUDGETING
1) Costing:
To develop and maintain the websites and also the online service, we have to spend S$3000. For each month of maintenance after launching the website, it costs $500.
2) Budgeting:
The Budget of the company for Project Development is S$5000. So we have enough of money and the profit gaining from online service will be divided to maintain the website.
3) Expected revenue gained:
If the project is successful, we expect to gain more S$3.000.000 in revenue for next year.
Page 24
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
CONCLUSION
Global marketplace - Your web site can be accessed from anywhere in the world, which now means you could sell to anyone ANYWHERE. No middleman - By selling directly to the customers you can now cut out the middleman. 24 Hour business - If your web site can process payment information you can now be open 24 hours a day! Increased customer information - Instead of posting your latest brochure or clients account statement, why not allow them to access it via your web site?
The Internet can open up new avenues for your business to buy and sell products or services online, with such activities generically referred to as ecommerce. The business relationships provided by ecommerce can be broadly split into two main areas: 1. Business to consumer (B2C) - where you sell products or services directly to individual consumers 2. Business to business (B2B) - where you sell goods or services to other businesses Reference: seyeneco.n.d
Page 25
A230CT Internet Technology
Prepared by Nguyen Xuan Phong
REFERENCE
http://en.wikipedia.org/wiki/Business_rule http://en.wikipedia.org/wiki/Target_audience http://en.wikipedia.org/wiki/Business_rule_management_system http://www.breadtalk.com/breadtalk/
Page 26
