Business Requirements

The “Homes for Garden Gnomes” provide Gnomes to customers. At presently all the operation of order receiving, dispatching to customer and replacement are done by means of Tiny’s in-tray and stock cards for each types of Gnomes. The stock cards are also used for the order that is sent to the supplier for Gnomes and when once they arrive updated accordingly. The present system is totally paper based; therefore, it is very difficult to manage all the orders from customers and also the stock level of each Gnome received from suppliers.

Now seeing this, an information system require for the “Homes for Garden Gnomes” that can handle all the daily operation of “Homes for Garden Gnomes”. This information system for the “Homes for Garden Gnomes” should provide all the details about: • The daily order received from the customer, • Order dispatched to customer, • Gnomes order to supplier and received from supplier, • Any replacement from customer and hence therefore got replaced from supplier.

• Stock level for each types of Gnomes • Knowing the most popular Gnomes ordered by the customer • Report, queries etc. Hardware Requirement: Workstation (Dell Precision Workstation 450 XEON 2. 66GHZ 1GB 250GB, $720), Printer Software

Requirements: Microsoft Windows XP Professional (with Service Pack 2), Microsoft Office 2003, Norton Antivirus Security 2007. Data Modelling The business requirements identified are discussed in the previous section for the “Homes for Garden Gnomes”.

From these requirements , it is identified that new information system should record various types of details , such as customer details, supplier details, Gnomes orders from customer , Gnomes orders to supplier, Gnomes orders dispatched to customer, Gnomes orders received from the supplier, Gnomes replacement to customer , Gnomes replacement from customer, re-order level for Gnomes, etc.

Now all this requirements for the “Homes for Garden Gnomes” can be taken care, if there is an information system, such as database system is available for the “Homes for Garden Gnomes” that can stores all the details and provide information based on the query, views and reports. As it has been identified that there are several customers and supplier for the “Homes for Garden Gnomes”, therefore, there will be one table for customer and one table for supplier for storing their details.

There will be also one table that will store the details of Gnomes that are kept in the “Homes for Garden Gnomes”. As order is received from customer for Gnomes and order is sent to suppliers for Gnomes, therefore, there will be two separate tables for the Gnomes order from customer and the Gnomes order to supplier. As any customer can order different types of Gnomes with different quantity, therefore, there will be separate table for Gnomes ordered from customer that will be associated with the Gnomes order from customer table.

Similarly there will be also a separate table for the Gnomes order to supplier. As sometimes the Gnomes dispatched to customer may be faulty or damaged, therefore, there will be separate table for replacement to customer and replacement received from suppliers for the Gnomes that will be associated with another tables containing details about the Gnomes and reason for replacement. After designing the database tables, there will be several query, views, forms and reports will be made so that required information for Gnomes and orders can be stored and viewed easily.

The various new entries for customer, supplier, gnomes and order will be stored in database with the use of graphical interface provided by the forms of database system (Microsoft Access). The daily order received from the customer can be checked from this information system and will be dispatched to them. In addition, the stock level for each type of Gnomes can be also managed by seeing the report of Gnomes details so that new order to supplier can be ordered.

If any query regarding any order from customer received than it will be dealt immediately by seeing that particular order with the help of query in the database system and necessary actions or information will be provided to customer. This procedure will be also available for the Gnome orders that are made to supplier. Similarly the replacement for gnomes to customer and from supplier will be dealt. The system will also produce report for the most number of sales for Gnomes.

It will be useful for making stock for the Gnomes that are liked by the most of the customers, therefore, reducing the other non-important Gnomes order stocks in inventory. ERD Figure 1: ERD of the “Homes for Garden Gnomes” Information (Database) System ? CustomerDetails: Each instance of the CustomerDetails is a person who purchases or purchased Gnomes from the “Homes for Garden Gnomes”. Customer details will be stored in this entity (table). ? SupplierDetails: Each instance of the SupplierDetails is a person/supplier who supplies or supplied Gnomes to the “Homes for Garden Gnomes”.

Supplier details will be stored in this entity (table). ? GnomeDetails: Each instance of GnomeDetails is the Gnomes that the “Homes for Garden Gnomes” offers to its customers. Gnomes’ details will be stored in this table. ? CustomerOrder: Each instance of CustomerOrder is the order that the “Homes for Garden Gnomes” customers makes. Customer order details will be stored in this entity. ? CustomerOrderGnomeDetails: Its each instance contains the details of Gnomes (order) made in CustomerOrder. This entity is made so that different Gnomes for a single customer order can be recorded.

SupplierOrder: Each instance of SupplierOrder is the order that the “Homes for Garden Gnomes” makes with supplier. Supplier order details will be stored in this entity. ? SupplierOrderGnomeDetails: Its each instance contains the details of Gnomes (order) made in SupplierOrder. This entity is made so that different Gnomes for a single supplier order can be recorded. ? CustomerReplacementOrder: Each instance of CustomerReplacementOrder is the replacement for the faulty or damaged Gnomes order that the “Homes for Garden Gnomes” provides to its customers.

CustomerRepOrderGnome: Its each instance contains the details of Gnomes (replacement) made in CustomerReplacementOrder. This entity is made so that different Gnomes for a single customer replacement order can be recorded. ? SupplierReplacementOrder: Each instance of SupplierReplacementOrder is the replacement for the faulty or damaged Gnomes order that the “Homes for Garden Gnomes” receives from its suppliers. ? SupplierRepOrderGnome: Its each instance contains the details of Gnomes (replacement) made in SupplierReplacementOrder. This entity is made so that different Gnomes for a single supplier replacement order can be recorded.

IT System The IT System will simple for this information (database) system. It will be consists of a workstation (desktop computer) and printer. The Microsoft Windows XP professional (SP2) will be installed on workstation and Norton internet security 2007 will be installed for virus and worms, which is latest antivirus from Symantec, Inc.. For database application Microsoft Office 2003 will be installed as it is tested application for office applications as compared to new released Microsoft Office 2007. The database system will be made on Microsoft Office Access, which will be used easily on this workstation by Tiny and assistants.