Evidence A                                                                

Design

Statement of Purpose

The purpose of the database is to guide the intended user to resources that will assist them in completing a project or task. In this case the intended user or user group is interior designers and the collection is candle holders. The database will assist the user group in researching the various styles, colors, and types of candleholders that are available in order to provide examples to clients.

The intended user group for this database would be the purchaser (designer) and the sales person. It is intended to assist the sales person helping the designer to find items they may need on the basis of style, color, type, height, and the dimension of the candle they would like to use. Also they are able to see if the candle stick holder is available in a set and the number within that set. This database is intended to help with common questions such as: “I am designing a room that is entirely in the modern style, can I see everything you have that fits under that category?” As well as:”I need a tall holder that can hold a one inch tapered candle, do you have anything that comes in blue?”

The set of rules we developed for the purposes of describing each item in the candlestick holder collection were style, color, height, type, and dimension. Interior designers can select candlestick holders based on the records provided, with the assistance of the sales person. We decided on these because they are straight-forward but expressive enough for our user group, both beginning designers and advanced designers. All the fields are required but are easily attained by looking at the physical attributes of the candlestick holder.

https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcTMAn5DClY8HhT7NzAKSHI2zZDXU_BoBso8PxV7ZETwtF1hTL8_

Textbase Structure

Textbase Information

Field Summary:

  1. Record Number: Automatic Number(next avail=2, increm=1), Term
  2. Style: Text, Word
  3. Color: Text, Word
  4. Size: Number, Word
  5. Type: Text, Word

Validation: valid-list

  1. Dimension: Number, Word
  2. Note: Text, Word

Log file enabled, showing ‘Record Number’

Leading articles: a an the

Stop words: a an and by for from in of the to

XML Match Fields:

  1. Record Number

Textbase Defaults:

Default indexing mode: SHARED IMMEDIATE

Default sort order: <none>

Textbase passwords:

Master password = ”

0 Access passwords:

No Silent password

Validation List – Type

Brass

Ceramic

Crystal

Glass

Porcelain

Stoneware

Wooden

Validation List – Style

Art Deco

Modern

Traditional

Vintage

Sample Records

Record Number1

StyleArt Deco

ColorBlack

Height4in

TypeMetal

Dimension1inch

NoteDoes not have a pair.

Record Number2

StyleTraditional

ColorBlue

Height9 in

TypeWooden

Dimension.5 in

NoteSet of 2

Record Number3

StyleVintage

ColorRed

Height5in

TypeCeramic

Dimension3in

Record Number4

StyleModern

ColorBrass

Height22 in

TypeBrass

Dimension5 in

Record Number5

StyleArt Deco

ColorRed

Height3 in

TypeStoneware

Dimension1 in

Record Structure

Fields

Record Number: Each record you create will automatically # 1,2,3 etc.

Field Name Field Type Indexing
Style Text Word
Color Text Word
Size Number Word
Type Text Word
Dimension Number Word
Note Text Word

We created a validation list for Type:

Crystal

Glass

Wooden

Ceramic

Brass

Porcelain

Stoneware

Metal

2nd list:

The second list is: traditional, art deco, modern and vintage

Advertisements