Concept map for "what is a relational database"

[brainwane]

This issue springs from discussion of pull request #99 in which @heereman wrote a definition of a relational database, and @orchid00 and I thought it might be a good idea to add a concept map to the instructor's notes for this lesson.

My question:

It seems to me like the concepts and linkages @heereman mentioned in their definition are most of the concepts and linkages that ought to go into the concept map -- here's my list, and I'd love feedback on what else should go into the map for this lesson, or what I could leave out:

• users/researchers
• queries
• SQL
• data/values
• storage
• retrieval
• tables
• rows
• columns
• records
• record IDs
• atomic
• relationships
• joining
• functions
• nulls
• aliases

I'd love to know others' feedback on what I could leave out of this! I'm thinking maybe "atomic"?

[orchid00]

Just confirm, this list is to make the concept map of database. It al depends how deep you want to describe database. Leaving out atomic, seems like a good idea. Suggest adding:

• aggregation
• order

We can wait for @tpoisot feedback

[tpoisot]

We should maybe add

• views
• sorting
• groups

since these are used in the lessons.

[orchid00]

Hi @brainwane It has been long. would you like to suggest a concept map as contribution? or spread the word about it so someone else can contribute? I would suggest your own circle or using twitter or a write blog post for the carpetries community.

[brainwane]

Hi, and sorry for the wait. I won't be doing this, but I posted on Twitter and Mastodon to recruit folks to try to help.

[sgthomas29]

I'm willing to work on this, but I'm unsure of where in the lesson this would go. The very beginning to convince students why relational databases are superior to spreadsheet management?

[remram44]

I don't think RDM is a widely used acronym for relational databases. Wikipedia refers to it as RM. It also conflicts with other acronyms that people are likely to encounter in an academic setting, such as Research Data Management.

[brainwane]

I'm willing to work on this, but I'm unsure of where in the lesson this would go. The very beginning to convince students why relational databases are superior to spreadsheet management?

The concept map would go into the instructor's notes for the lesson. This would aid future people who are improving the lesson.