?
Solved

What Data Types To Use?

Posted on 2006-10-19
4
Medium Priority
?
208 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 2000 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month13 days, 9 hours left to enroll

801 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