Assignment One Statistics

The highest mark is 77.85 and the average mark is 64.0. The marking criteria used is as follows: Completeness (20%), Design (5%) and Content (75%).

I truly enjoyed interacting with you thru this online medium. Thanks for sharing your thoughts, opinions and examples ! I learned a lot from you all.

In the left-hand menu, I have placed two asterisks (**) next to some of the most well-written blogs by your classmates. For Question 5, here are my model answers:

How does our sample MS ACCESS database observe the following design principles ?

* Divides your information into subject-based tables to reduce redundant data.

Our information is divided into two tables - Product and Supplier. Each table is strictly about one subject only. For example, information about the supplier is not mixed or combined with a product record. The product record only contains the "Company ID" which can be used to look up further information about the supplier in the Supplier table. In this way, redundant (or repeated) data is reduced because the supplier's name, address, phone no. and so on are stored only in one location. This data is also easy to maintain as it only needs to be updated in one place.

* Provides the database management system (e.g. ACCESS) with the information it requires to join the information in the tables together as needed.

The product record contains the "Company ID" field which can be used to look up further information about the supplier in the Supplier table. This field allows related information from both tables to be easily joined and combined.

* Helps support and ensure the accuracy and integrity of your information.

The primary key field ensures that no two customers have the same ID; no two suppliers have the same ID. Each field is also restricted to a single data type, so it's impossible to enter a non-numeric value in a numeric field, and it's impossible to enter a non-date value in a date field, etc. This helps maintain the accuracy and integrity of information.

* Accommodates your data processing and reporting needs.

The Report Wizard offers a user-friendly interface for designing customized reports. Users can select the source of data, the fields to include, the grouping levels, the sort sequence, layout and so on.

Session Six Announcements

The due date for Assignment One has been moved to 25-June instead of 18-June.

The due date for Assignment Two will be moved to 21-July instead of 14-July.

Here's the marking scheme for Assignment Two:

• E-Commerce Plan - 40%
• Sample Web Site (site map and sample pages) - 15%
• Proposing New Information Systems - 40%
• Formatting, Organization and References - 5%

A site map provides an overview of the major sections and pages in each section of the finished web site. A good reference you can use would be Apple's site map.

You only need to develop at least 5 prototype or sample Web pages, these could be the home page plus the starting page in each of the major sections. For the rest of the site, it would be enough to indicate the titles of these sections or pages in your site map.

Here are some existing businesses whose e-commerce strategy you may use as a model for your e-commerce plan. These are suggestions only, feel free to be inspired and learn from what they're doing right now, and also offer improvements on their strategy. You are also free to find and share your examples with us on this blog !

• Business 1: Invest in Hong Kong, Discover Hong Kong, Welcome to Taiwan
• Business 2: Spotlight, Ikea, B&Q
• Business 3: Stonyfield Farm Yogurt, Yoplait