Solved

What Data Types To Use?

Posted on 2006-10-19
4
202 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Maven Project: Hibernate Dependencies Conflict 10 50
how to install java on RHEL image on EC2 4 57
Problem to Alipay 10 71
Java Eclipse Loop 3 31
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

733 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