Python Forum

Full Version: Database structure (no code?)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello geniuses!

I am a Python amateur so before I even start my coding project I would appreciate some direction.
I have a (VBA exercise) Excel application that I know could be greatly improved using Python.
The meat and potatoes of my "coding start" dilemma - My XLM_APP basics-

I have 5 databases - matbase, partsdb, compdb, assemdb, modeldb
index(a2) m-001 p-001 c-001 a-001 m-001

Matbase is straight forward, raw material from suppliers
partsdb is the first, end result of processing a material ie. a part.
compdb is a collection of parts that make a component.
Assemdb is a collection of components and parts.
modeldb is a collection of assemblies components and parts

Given the relationships described above how should I relate these database's?
Lists, Tuples, dictionary?
I'm in Google overload.
TX
steve