+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Database structure (no code?) (/thread-25851.html)
Database structure (no code?) - BlackmoreSteve620721 - Apr-13-2020
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
RE: Database structure (no code?) - Larz60+ - Apr-13-2020
perhaps something like: https://pypi.org/project/cheesefactory/