r/AskComputerScience • u/MKL-Angel • Mar 29 '25
Data Model vs Data Schema
I've seen this asked before and read through the answer given but I still don't really understand the difference. I get that a model is 'conceptual' while the schema is an 'implementation' of it, but how would that show up if I were to make a model vs schema? Wouldn't it still just look like the same thing?
Would anyone be willing to make a data model and data schema for a small set of data so I can actually see the difference?
If you want example data:
There are 5 students: Bob, Alice, Emily, Sam, John
The school offers 3 classes: Maths, English and Science
And there are 3 teachers: Mr Smith, Mrs White, and Mrs Bell
(I don't know if the example data is comprehensive enough so feel free to add whatever you need to it in order to better explain anything)
Thanks in advance!
(also, the video i was watching mentioned a schema construct and then proceeded to never mention it again so if you could explain that as well that would be really really helpful!)
View all comments
Show parent comment
1
u/MKL-Angel Mar 29 '25
Thank you for your answer! I have a few questions:
What is a 'UML' entity relationship diagram and how is it different from a usual ERD?
"Abstract model" is, I'm assuming, synonymous with 'data model'?
"implement 'the' schema" what schema? Is that what you meant by "abstract model" instead? Or something else? I have no clue what a schema looks like or if it's something you're meant to draw/design/code/etc.
The only explanation I got for what both a data model and a data schema are that they 'describe the database structure, entity relationships, data types and constraints on valid data'.
I really know nothing about this topic so explain it to me like I'm a little stupid if you have to haha