Solved

What Data Types To Use?

Posted on 2006-10-19
4
198 Views
Last Modified: 2010-03-31
During a meeting our group talked about the many various types of lists currently received from our customers. My design team decided that the following are commonly included: item UPC, item price, and quantity ordered. We also realize that we will need to determine and store information about the customer placing the order in order to print a mailing label. Among the information needed are customer company name, customer contact name, customer address, customer order number, and customer payment method. For this version, I am not worried about the payment method because this is well-established, and varying payment methods will be addressed at a future period. When our group meets later this week to continue design work, it is decided we will finalize the data needed. I need  to consider and document what data types should be used and how this data should be stored in the program before coming to the meeting so we can use the short amount of time we have wisely.

I need to prepare a list of the necessary pieces of information.The list needs to include what data types we would use and why. Are the data fields complete in the aforementioned (for example, do you think we need a product description for the final itemized data that will be provided to the shipping department)? Are they all necessary? Are any fields left out or ambiguous?  

This is a shipping application.


0
Comment
Question by:tristatefab
4 Comments
 

Author Comment

by:tristatefab
ID: 17769128
That sounds very fair, I have no problem with that at all. I appreciate the response:-]

Here are my thoughts and please correct me if you believe I am wrong:

Customer Company Name - String
Customer Contact Name: String
Customer Address: String
Customer Order Number: Integer if all #'s, but String if alphanumeric
Customer Payment Method: String

The data will have to be stored in some sort of database. I am most experienced with Access, however; I have heard it is not always the best option. Any other recommeneded ones you guys know of?

I would not think we would need a product description as it would be included in the UPC, correct?  The shipping department could scan it and tell what it is.

These are my thoughts so far!
0
 
LVL 5

Expert Comment

by:kannan_ekanath
ID: 17772794
I guess, determining the data type would not be a complex task in itself. I would advice you to stay *agile*, start writing a simple Customer, Payment class, give the appropriate attributes, and start writing JUnit (or any other similar framework) test cases.
0
 
LVL 20

Accepted Solution

by:
Venabili earned 500 total points
ID: 17774869
>>Customer Payment Method: String

I would make it a number and will keep a static list of which number is which method. ( in the database simply made a table with columns (number, type) which contain all types of paying.

>>Any other recommeneded ones you guys know of?
Mysql - it is free
Oracle or MSSQL if you want to pay.
But for your case MySQL seems just fine

>>I would not think we would need a product description as it would be included in the UPC, correct?
Depends. I would put it in the databse just to be complete and so you can make some stats later... But up to you
From the Programming side:
kannan_ekanath gave you godo advices. Although Payment class will be a bit too much  if you just have the payment method thereWhat I would do is to create a table containing all the data for one such item as columns and a class which contains the same for working with the data.

And I would add at least 2 more fields:
- date_of_delivery
- date_of_last_change_of_the_item
:)
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now