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.