L
L
low molecular macro2021-11-05 13:29:21
Database design
low molecular macro, 2021-11-05 13:29:21

How to describe the implementation of the database in isolation from a specific DBMS?

It is necessary to tell how I would design a database for a particular business. With a description of all fields, types and relationships. All this needs to be written in a simple text field on the site, so (as far as I understand) no schemes or sample queries are expected from me. Therefore, the question is: how to do this correctly, so that it is clear what is connected with what, and what structure does it have?
As an example, such a simple database
6185063142fd4194817368.png

So far, the only thing that came to mind is to write like this

Purchases (
id integer unique not null PK
client integer not null FK (clients.id)
product integer not null FK (products.id)
quantity integer not null
)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
C
ComodoHacker, 2021-11-05
@ComodoHacker

Apparently, you are expected to have a logical data model. You can make it in a specialized editor, put the file somewhere and give a link. You can finally give a link to the picture.
But if I were you, I would think about whether it is even worth dealing with those who left only a "simple text field on the site" for such voluminous information.
You can troll them a little more and send an ASCII diagram made with https://asciiflow.com/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question