had a uni exam in databases (just closely didn't make it๐Ÿ˜’)
it didn't even have sql in it!?

questions about ER diagrams and draw a diagram, functional dependencies with given dependencies, find candidate key and what not, work on a b-tree (miserably failed๐Ÿ˜ฃ), datalog (who the fuck cares about datalog? the least expected topic) and transaction management/serializability

whose idea was it to not include sql?? isn't it one the fundamental parts of relational databases?

  • 3
    I'm ashamed to say I've been a developer for a couple years now and I dont know half that shit. ER diagrams kind of worth tho - that's not as much about efficiency as making a decent model that makes sense.
  • 0
    @craig939393 i'm really questioning some of the parts i had (and still have) to learn, like datalog ... why on earth will i ever need it? maybe ok to get an intro to logical programming but come on, why in an exam?๐Ÿ˜ฏ
  • 2
    OK but knowing ER diagrams and 3NF will get you 99% of the way to making a decent DB schema that can be refined and tweaked later by a specialist. You would not believe the amount of gross nasty I have seen because people didn't understand how to model objects in a relational database, and it's super easy. SQL you can pretty easily learn on your own. (Arguably you could learn ER and 3NF on your own too but most of the bootcamp grads I've seen haven't been able to do so for some reason.)

    A CS degree also isn't supposed to be just a trade school. They're teaching you datalog because part of the curriculum of any decent CS program is to teach you the different programming paradigms, whether or not they're currently fashionable in industry. I mean, functional programming was also considered financially-worthless when I was in school but nowadays there are actually jobs out there for Haskell. Prolog and datalog are most popular options for logic programming.
  • 0
    @HollowKitty agree with ER and the NF's although the decomposition and synthesis(?) algo weren't explained well and not expected, still we had to use the the synth algo, which was explained in mostly cryptic pseudo code ๐Ÿ™„
    but i still don't understand the meaning of datalog in such an exam?
    it was ok when we had to deal with it as an exercise to get a feel of the paradigm (and had more help than in the exam)
Add Comment