Frank Pytel

Frank Pytel

  • NA
  • 3
  • 0

Database Design Help

Dec 17 2008 9:01 PM
Hello;

Hoping someone can help with a design issue. I have to learn C# for work. 
Part of my work will be calling information from a database. Not sure of the 
type. I thought that it would be good practice to design an application and 
integrate it with a Jet database. I understand that much of the work will 
allow me to migrate to SQL or mySQL if needed.

So, I am building a grocery shopping list as an example. My question is 
regarding how to create the tables.

I have categories of FrozenFruit, FreshFruit and CannedFruit. I realize that 
I will be duplicating some of the input (Peaches) but I will need the lists 
within C# for auto populating or suggestive typing in form txtFields.

This is where it gets tricky for me. Should I go with a Brand 
table(Cambell's, Progresso) listing Soup (Clam Chowder, Chicken Noodle) with 
a size and price in columns 3 and 4? This will leave out an auto populating 
Soup list because size and price may differ by brand (10.25 oz Chicken Noodle 
vs. 10.75 oz Chicken Noodle)?

I am a bit perplexed and any advice you can provide would be greatly 
appreciated. My skill level with database design is below novice. Idiot would 
be a better descriptive term. I am basically typing my tables into Excel and 
importing them so that I can have the wizard automatically fill in the 
NoDuplicates and Key assignment.

Thank you in advance for any help. All responses and opinions will be 
greatly appreciated and helpful.

God Bless

Frank Pytel

Answers (3)