3 Replies - 180 Views - Last Post: 20 November 2017 - 04:10 AM Rate Topic: -----

#1 M4CLAREN  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-November 17

Need smart person for difficult database structure

Posted 19 November 2017 - 03:54 PM

Hi,
for days now i have had diffuculties with a database structure for the following problem: see attachment (i tried to draw the relationship between the data entries to clarify the problem). Its for an archive and the numbers are topics, which combined create new topics.

Characteristics:
1. every single one of the blue boxes has to be in the database.
2. it has to be possible to read both from which boxes a blue box is composed of and in which other boxex it is icluded. (up and down relationships).
3. it has to be scaleble (the "etc."s). If possible not for every single degree (DEG) a new database.
4. if possible avoid creating a structure where the relationships are recorded multible times to avoid possible asymetry in the data.

I really cannot get my head around how to create a database structure for this problem. I am honestly rather inexperienced, is there a really obvious solution i just heavent heard of? I am happy about any help.

Thank you for your time,
Maclaren

wow the server didnt upload the picture-_-

Is This A Good Question/Topic? 0
  • +

Replies To: Need smart person for difficult database structure

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13656
  • View blog
  • Posts: 54,487
  • Joined: 12-June 08

Re: Need smart person for difficult database structure

Posted 19 November 2017 - 04:05 PM

I am not certain what you are asking. Please explain it.
Was This Post Helpful? 0
  • +
  • -

#3 astonecipher  Icon User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2363
  • View blog
  • Posts: 9,482
  • Joined: 03-December 12

Re: Need smart person for difficult database structure

Posted 19 November 2017 - 04:43 PM

It sounds like a typical issue, but to be sure, more info is needed. Define the relationships and it should come to you.
Was This Post Helpful? 0
  • +
  • -

#4 maceysoftware  Icon User is online

  • D.I.C Lover
  • member icon

Reputation: 350
  • View blog
  • Posts: 1,508
  • Joined: 07-September 13

Re: Need smart person for difficult database structure

Posted 20 November 2017 - 04:10 AM

for information, this was also posted on stack overflow:

https://stackoverflo...abase-structure
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1