MySQL Forums
Forum List  »  Newbie

Basic Data Modelling
Posted by: Daniel Münch
Date: December 30, 2019 03:08AM

Hello,

I have a basic problem with Data Modeling.
I want to build up a small database containing information about servers.

We have several servers with different OS and different applications running on top of if. For each OS or application type different information (different columns) should be available.
So my question is: Should I have one central table "servers" and then separate tables for every OS or application type? Or should I put it all in one table and only fill out the fields I need to?

If I should make separate tables: How can I join them? This means I would have to create an "ID" column for each application / OS and use it as a foreign key, right?

Thanks in advance,
Daniel

Options: ReplyQuote


Subject
Written By
Posted
Basic Data Modelling
December 30, 2019 03:08AM
December 30, 2019 10:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.